NEW
Font size
WorksheetsMastering Spreadsheet Basics
Total questions: 9
Worksheet time: 5mins
What is the correct formula to add cells A1 and A2?
=A1 * A2
=SUM(A1, A2)
=A1 + A2
=A1 - A2
How do you create a formula that multiplies B1 by C1?
=B1*C1
=B1+C1
=B1-C1
=B1/C1
What symbol is used to start a formula in a spreadsheet?
-
+
=
*
What function would you use to find the average of a range of cells?
SUM
MAX
COUNT
AVERAGE
How do you create a formula that subtracts D1 from D2?
=D2+D1
=D1+D2
=D2-D1
=D1-D2
What is the purpose of the SUM function in spreadsheets?
The purpose of the SUM function is to calculate the total of a set of numbers.
To count the number of entries in a dataset.
To display the maximum value in a range of cells.
To find the average of a set of numbers.
What does the COUNT function do in a spreadsheet?
The COUNT function sums all entries in a range.
The COUNT function counts all entries, including text.
The COUNT function averages numeric entries in a range.
The COUNT function counts numeric entries in a range.
How do you create a formula that divides E1 by F1?
=E1/F1
E1/F
E1 divided by F1
=F1/E1
What function would you use to find the maximum value in a range?
MAX
SUM
AVERAGE
MIN
