NEW
Font size
WorksheetsSpreadsheet Formulas
Total questions: 16
Worksheet time: 13mins
What is a formula in Excel? Fill in the blank: A formula is a special instruction you give to Excel to do ______ for you using the numbers in your spreadsheet.
maths
drawing
printing
sorting
Which sign must every formula in Excel start with?
=
+
-
$
Which of the following symbols is used to multiply in an Excel formula?
+
-
*
/
In Excel, you can use + to add, - to subtract, * to multiply, and / to divide in formulas.
True
False
What is the function of the Plus Sign (+) in spreadsheet formulas?
To subtract two numbers
To add two numbers or cells together
To multiply two numbers
To divide two numbers
What is the function of the Minus Sign (-) in spreadsheet formulas?
To add two numbers
To multiply two numbers
To take one number away from another
To divide two numbers
What is the function of the Asterisk (*) in spreadsheet formulas?
To divide two numbers
To multiply two numbers or cells
To add two numbers
To subtract two numbers
What is the function of the Slash (/) in spreadsheet formulas?
To multiply two numbers
To add two numbers
To divide one number by another
To subtract two numbers
Something that automatically calculates something for you using the data in cells is a:
Formula
Formatting
What formula would you use to add the values in cells A1 and B1?
=A1-B1
=A1+B1
=SUM(A1:B1)
=ADD(A1,B1)
If you wanted to calculate the average of the numbers in cells A1 through A5, which formula would you use?
=AVERAGE(A1:A5)
=AVG(A1:A5)
=MEAN(A1:A5)
=SUM(A1:A5)/5
How would you write a formula to subtract the value in cell B2 from the value in cell A2?
=A2-B2
=SUBTRACT(A2,B2)
=A2+B2
=DIFF(A2,B2)
Which formula correctly multiplies the values in cells A1 and B1?
=A1*B1
=MULTIPLY(A1,B1)
=A1xB1
=PRODUCT(A1,B1)
To divide the value in cell A1 by the value in cell B1, which formula should you use?
=A1/B1
=DIVIDE(A1,B1)
=A1÷B1
=RATIO(A1,B1)
