NEW
Font size
WorksheetsExcel Data and Formula
Total questions: 15
Worksheet time: 5mins
Which of the following formulas correctly adds the values in cells A1 and B1?
`=A1+B1`
`=SUM(A1:B1)`
`=ADD(A1, B1)`
`=A1*B1`
What is the result of the formula `=B1*2` if B1 contains the value 5?
5
10
15
20
What is the difference between relative and absolute cell references?
Relative references change when copied; absolute references do not.
Absolute references change when copied; relative references do not.
Both change when copied.
Neither change when copied.
What is the name of the cell that is colored blue?
A
B
2B
B2
How is the COLUMN in a MS Excel Spreadsheet named?
Numbers
Letters
Cells
Columns
How are ROWS in MS EXCEL spreadsheet named?
numbers
letters
cells
columns
What does every formula in MS EXCEL start with?
+
-
=
*
What is the symbol for division when using MS EXCEL.
/
+
*
-
Which is a formula using MS Excel using addition.
2 + 3 =
= A + B
=A2+B3
A2+B3
What is an example of a RANGE in MS Excel.
B2-F5
F5:B2
B2:5F
(B2:F5)
Which Formula is written correctly for multiplying cell A1 and A7?
=A1+A7
=A1*A7
A1+A7
A1*A7
When is a MS Excel Spreadsheet used?
Making a Drawing
When Reading
For Collecting Information
For Baking a Cake
