Lesson 17 - Midlands Microsoft Office Provider

Please sign up for the course before taking this quiz.

If we entered the formula: =A14/$K$28, to do an AutoFill, this would be an example of using:50
- Relative References
- Absolute References
- Combination of Relative References and Absolute References
- None of the above
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
- We needed to change the formula to: =$B$6/G6
- We needed to change the formula to: =B6/$G$6
- Either A or B will work
- None of the above

Comments are closed.

Lesson 17 Quiz