wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

S3 Spreadsheets

Total questions: 25

Worksheet time: 15mins

Name
Class
Date
1.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

2.
What is this?
a)
active cell
b)
column
c)
cell
d)
none of the above
3.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

4.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

5.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

6.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

7.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

8.

What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.

a)

SUMMING

b)

SUM

c)

ALL

d)

None at all

9.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

10.
Instructs the software to perform a calculation.
a)
Label
b)
Value
c)
Formula
d)
Function
11.

What is the cell range of the cells highlighted in blue?

(a)  

12.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
13.
What does cell C3 contain?
a)
23
b)
67
c)
Amount
d)
11.50
14.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
15.
What does cell A1 contain?
a)
Sweet
b)
Mars
c)
A1
d)
Cost
16.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
17.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
18.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
19.
What TAB allows you to add your name to the foot of the  document?
a)
Page
b)
Margins
c)
Header/Footer
d)
Sheet
20.

What should I tap to "finish" a formula?

a)

Enter

b)

Finish

c)

Done

d)

Space

21.

Every cell has its own, unique address. How does a cell get its name?

a)

by its row and sheet

b)

by its column and cell

c)

by its column and row

d)

by its row and formula

22.

Which is the correct formula to multiply?

a)

=B6*C6

b)

B6*C6

c)

B6C6*

d)

*B6C6

23.

What function do you use to add cells together?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

24.

What function do you use to find the lowest number?

a)

SUM

b)

MAX

c)

MIN

d)

AVERAGE

25.

What is the cell reference of the cell with value Sprite Lite inside?

a)

8A

b)

C5

c)

A8

d)

B8