WorksheetsWeek 10
Total questions: 10
Worksheet time: 5mins
All formulas in Excel must begin with an
minus sign (-)
Equal sign (=)
Question mark (?)
The standard operator for multiplication formula in Excel is
/
+
*
This function adds all of the values of the cells in the argument
Sum
Max
Count
This function determines the lowest cell value included in the argument.
Average
Min
Max
This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range.
Count
Min
Sum
Formulas can be copied to adjacent cells using the
Ctrl+C
Fill handle
Ctrl+V
Which mathematical operator used to find the total for column K
/
+
-
The correct Formula for counting the average is
=AVERAGE M2,L2,M3,M4,L4
=AVERAGE(M2,L2,M3,L3,M4,L4,)
=AVERAGE''M2,L2,M3,L3,M4,L4''
This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.
Max
Average
Count
The standard operator for division operations is Excel is
/
-
^
