Lesson 17 Quiz

Please sign up for the course before taking this quiz.
  1. If we entered the formula: =A14/$K$28, to do an AutoFill, this would be an example of using:50

  2. In reference to the graphic below, we wanted to know each salesperson’s Quarter 1 total as a percent of the Quarter 1 Grand Total. For Salesperson Tom, in cell address B7, we entered the formula: =B6/G6 and we received a result of 0.18. We wanted to know the same result for all of the other salespersons, so we did an AutoFill, beginning at cell address B7. We performed an AutoFill through cell address F7. Why did we get Divison by 0 errors for the other salespeople when doing this AutoFill?50
Back to: Lesson 17

Comments are closed.