WorksheetsSpreadsheet Formulas
Total questions: 6
Worksheet time: 3mins
Name
Class
Date
1.
In a spreadsheet formula, which symbol is used for ADDITION?
a)
+
b)
-
c)
*
d)
/
2.
In a spreadsheet formula, which symbol is used for MULTIPLICATION?
a)
+
b)
-
c)
*
d)
/
3.
In a spreadsheet formula, which symbol is used for SUBTRACTION?
a)
+
b)
-
c)
*
d)
/
4.
In a spreadsheet, a formula must ALWAYS start with...
a)
a cell address
b)
a letter
c)
an equals sign
d)
an empanada
5.
True or False: The FILL handle can be used for formulas.
a)
True
b)
False
6.
Why are formulas helpful in a spreadsheet? (Check all that apply)
a)
They will automatically calculate results if numbers are changed.
b)
They can quickly perform mathematical calculations.
c)
They can be filled to other cells to repeat a calculation.
d)
They can be used for a range or list of numbers.
100 %
