On the Grade Average worksheet, select G7 and type "Average." In cell G8, use a formula to generate the average of the contents in Cells B8:F8. Use the fill handle to populate your results through G10.
The syntax for the Excel Average function is the following: AVERAGE(argument1, [argument2],...).
Arguments can be numbers, named ranges, cell references that contain numbers, or arrays.
Select Cell A12, and enter "Class Average." Use a formula to generate the average of IP Assignment 1 in cell B12. Use the fill across handle to populate your results of averaging the other assignments to F12
Solved by Z. A. in 22 mins