Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

P4 MICROSOFT EXCEL QUIZ 1

Total questions: 21

Worksheet time: 20mins

Name
Class
Date
1.

A cell is a...

a)

area where columns and rows intersect

b)

grid made of columns and rows

2.

How are rows designated?

a)

By numbers

b)

By letters

3.

The highlighted region of the picture below is a:

a)

row

b)

column

c)

label

d)

sheet

4.

How are columns designated?

a)

By numbers

b)

By letters

5.

The highlighted region of the picture below is a ...

a)

column

b)

row

c)

label

d)

sheet

6.

The highlighted region of the picture below is a:

a)

Active Cell

b)

Cell Name

7.

In a cell reference, for example A1, what does the letter refer to?

a)

The row the cell is in

b)

The column the cell is in

8.

Which of the following tasks would a spreadsheet be best used for?

a)

Keep track of money you have

b)

Creating posters and flyers

9.

What is the name of this cell?

a)

D1

b)

1D

c)

DD

d)

11

10.

In a cell reference, for example D23, what does the number refer to?

a)

The row the cell is in

b)

The column the cell is in

11.

What is a value?

a)

text or a word in a spreadsheet

b)

a number and a calculation in a spreadsheet

12.

What is a label?

a)

text or a word in a spreadsheet

b)

a number and a calculation in a spreadsheet

13.

What is the label in this active cell?

a)

ABC

b)

DEF

c)

GHI

14.

What tool is in number 3?

a)
b)
c)
d)
15.

What tool is in number 6?

a)

Copy

b)

Center

c)

Font

d)

Wrap text

16.

What tool is in number 2?

a)

Picture

b)

Chart

c)

Table

17.

What tool is in number 3?

a)
b)
c)
18.

What tool is in number 1?

a)

Font

b)

Copy

c)

Center

d)

Paste

19.

In Excel, all FORMULAS must begin with what symbol?

a)

@

b)

-

c)

+

d)

=

20.

What function can be used to find a total number in a range of numbers?

a)

+

b)

ADD

c)

SUM

21.

=C5-C1 is a ...

a)

range

b)

cell

c)

formula