wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Intermediate Excel

Total questions: 10

Worksheet time: 3mins

Name
Class
Date
1.

These are predefined formulas that are already available in Excel.

a)

Formulas

b)

Functions

c)

Operators

2.

What part of a formula identifies a cell or a range of cells on a worksheet and tells Excel where to look for the value or data you want to use in the formula?

a)

Constants

b)

Functions

c)

References

3.

These are numbers or text entered directly into a formula. These values are not calculated.

a)

Constants

b)

Operators

c)

Functions

4.

These specify the calculation you want to perform on the elements of the formula.

a)

Functions

b)

Operators

c)

References

5.

This type of cell referencing is indicated by a "$".

a)

Absolute

b)

Arithmetic

c)

Relative

6.

These operators perform basic mathematical operations.

a)

Comparison

b)

Arithmetic

c)

Formulas

7.

VLOOKUP is an example of a ______________.

a)

Formula

b)

Cell Reference

c)

Function

8.

Which is an example of a Relative Cell Reference?

a)

$A$4

b)

A4

c)

None of the above.

9.

Which is an example of a Comparison Operator?

a)

>

b)

*

c)

/

10.

Which cell reference is best used if you want the reference to remain at cell D56 even if you extend the formula?

a)

D56

b)

$D56

c)

$D$56