Excel Review

Each day, $1 bills and $0.01 and $0.05 coins are given to charity.

Which function enables filling cell G15 with the correct number?

• 1. A.
     =SUM(C10,G10,G9)

• B.
  =SUMIF(C10,G10,G9)

• C.
  =COUNT(C10,G10,G9)

• D.
  =A10+E10+E9

Answer explanation

COUNT is not appropriate in this case as it shows the number of cells, which are not empty. It does not show the actual values.

ADD is not an existing formula. Answer D doesn’t count the correct values.

SUM is perfectly good and simple for the table, even though the question poses it as a condition.

You just need to specify which cells of the spreadsheet should be summed up → =SUM(C10,G10,G9)

Which of the following formulas will yield the correct daily average as in cell G8?

• A.
  =AVERAGE(B2:F6)/25

• B.
  =AVERAGE(B2:F6)

• C.
  =SUM(G2:G6)/5

• D.
  =AVERAGE(G2:G6)

Answer explanation

The average function sums the scope of elements and divides that sum by the number of elements.

Answer B averages all the daily paychecks in the table; therefore, it will yield the total daily average.

Answer A adds an unnecessary division by 25.

Answers C and D both yield the weekly average income.

Which function enables you to display only the required fields in column C, and “General or Text” data format in column D?

• A.
  Sort

• B.
  Clear Contents
  

• C.
  Custom Sort

• D.
  Text Filter

Answer explanation

The various sort functions only change the order of the table. “Clear contents” will remove the entire content from a cell range.

In which tab will you find the function that created this chart?

• A.
  Draw tab

• B.
  Formulas tab

• C.
  Insert tab

• D.
  Data tab

Answer explanation

In the “Insert” tab, you can insert tables, illustrations, charts, and more.

What is probably the reason for the error markings in column C?

• A.
  A value is not available to the formula or function.

• B.
  A value used in the formula is of the wrong data type.

• C.
  The formulas in the cells differ from one another in the same column.

• D.
  The numbers are formatted as text.

Answer explanation

When numbers are formatted as text, Excel automatically adds error markings to remind the user that these numbers cannot be used within formulas.

The different alignment of the numbers implies that.

Answer A is the description of the error #N/A.

Answer B is the description of the error #VALUE!

Answer C is a common error when formulas are copied and then altered. But it is not likely to be the error in this case.