wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Skills Quiz

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

Labels (text) are aligned at the _________________ edge of the cell.

a)

Left

b)

Right

c)

Top

d)

Bottom

2.

You can complete a cell entry by pressing:

a)

Enter

b)

Tab

c)

An arrow key

d)

All of the above

3.

If you choose a larger font size, the height of the row is automatically made taller.

a)

True

b)

False

4.

Which button allows you to copy cell formats from one cell to another?

a)

Enter

b)

Autofit

c)

Format painter

d)

Esc

5.

All formulas in Excel begin with the following symbol:

a)

+

b)

=

c)

%

d)

#

6.

Which formula below will add the value of B2 to the value of C3?

a)

=B2+C3

b)

=B2+B3

c)

=2+3

d)

=B+C

7.

Which of the following option is a formula?

a)

Add A1 - A5

b)

Subtract the numbers from A1 to A5

c)

A1 = A5

d)

=SUM(A1:A5)

8.

A selection of mulitple cells is called a:

a)

Range

b)

Group

c)

Reference

d)

Package

9.

In the following IF Statement, =IF(A3=0,"YES","NO"), what is the value if the statement is false?

a)

0

b)

YES

c)

NO

d)

A3

10.

In the following IF Statement, =IF(A3=0,"YES","NO"), what is the value if the statement is true?

a)

0

b)

YES

c)

NO

d)

A3