Open the workbook OM455. Save the file under a new name, OM455COUNTIF.xls. Suppose we wish to automatically

Question:

Open the workbook OM455. Save the file under a new name, OM455COUNTIF.xls. Suppose we wish to automatically count the number of each letter grade.
a. Begin by putting the letters A, B, C, D, and F in cells C29:C33. Use the COUNTIF function in cells D29:D33 to count the number of each letter grade. Create the necessary COUNTIF function in cell D29. Use absolute referencing on the range ($E14:$E$24) and then copy the function to cells D30:D33 to count the number of each of the other letter grades.
b. We are considering a different grading scale as follows:


Open the workbook OM455. Save the file under a new

For the current list of students, use the COUNTIF function to determine the number of A, B, C, D, and F letter grades earned under this newsystem.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Quantitative Methods For Business

ISBN: 148

11th Edition

Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey Cam

Question Posted: