Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel 2016 MOAC Lesson 04

Total questions: 10

Worksheet time: 6mins

Name
Class
Date
1.

Which of the following is not an arithmetic operator?

a)

+

b)

-

c)

*

d)

]

2.

Per the order of operations, what is the answer to this formula: =2*(2+2)?

a)

6

b)

8

c)

4

d)

2

3.

Per the order of operations, what is the answer to this formula: =2*2+2?

a)

6

b)

8

c)

4

d)

2

4.

Which of the following is an example of an absolute cell reference?

a)

A9

b)

A$9

c)

$A$9

d)

A9:E9

5.

Which of the following is an example of a relative cell reference?

a)

A9

b)

A$9

c)

$A$9

d)

A9:E9

6.

To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

a)

TRUE

b)

FALSE

7.

It is always best to use the exact value instead of the cell reference when using formulas.

a)

TRUE

b)

FALSE

8.

You can press the F4 key to add the $'s to an absolute reference.

a)

TRUE

b)

FALSE

9.

The order of operations determines which parts of a formula are calculated before other parts of the formula.

a)

TRUE

b)

FALSE

10.

The formula = 6 * 2 + 3 produces the same result as = 6 * (2 + 3).

a)

TRUE

b)

FALSE