Back to lesson
1. Given the picture below, what would we want to enter in cell D5 to get the product of B5 and C5?
2. Given the image below, what is the best way to get B10 to show the sum of the values from B5 through B9?
Select B10, go to the Home Tab and click the AutoSum button on the Editing group.
Select B10 and enter 278
Select B10 and enter the following formula: =B5+B6+B7+B8+B9
3. Given the image below, what would you expect to happen if you selected C10, then went to the Home tab, selected AutoSum from the Editing group, and chose Average from the list?
A value of 6.884 would be placed in the cell.
A formula would be entered in C10 that averaged the values of cells C5 through C9.
A formula would be entered in C10 that summed the values of cells C5 through C9.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement