AutoSum, AVERAGE, and checking that the answer makes sense

Question 1 of 8

1. To total a column with AutoSum, first select:

   The File tab A chart The header row at the top of the column The cell immediately below the numbers
2. AutoSum writes a formula that uses the function:

   SUM AVERAGE only DATE FILTER
3. `=SUM(B2:B8)` means:

   Add B2 to B8 only (two cells) Add every cell from B2 through B8 Multiply B2 by B8 Sort column B
4. A Microsoft path for Average is:

   Insert > Chart > Average File > Print > Average Formulas tab > arrow next to AutoSum > Average Data > Filter > Average
5. With sample hours 6, 4, 7.5, 0, 5, 3, 0, `=SUM(B2:B8)` is:

   7 25.5 158.78 11
6. Including two zero days in AVERAGE:

   Converts hours into dollars Makes the sum larger Lowers the average compared with averaging working days only Deletes the zeros
7. If AutoSum proposes a range that includes your total cell as well as the days:

   Correct the range before you press Enter, or the answer will be wrong Always press Enter anyway Excel will refuse to calculate The file becomes a PDF
8. A useful sense-check for a total is:

   Never look at the formula bar Change the number format to Percentage Hide the total row Compare the result with a rough mental estimate and read the range