wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets Introduction

Total questions: 25

Worksheet time: 13mins

Name
Class
Date
1.

Cells that run horizontally on a spreadsheet

a)

Row

b)

Column

c)

Workbook

d)

Range

2.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
3.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
4.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
5.
You can present your data graphically, using a 
a)
chart
b)
print
c)
font
d)
sort
6.
To show the quantities in particular categories use a?
a)
Column Chart
b)
Line Graph
c)
Scatter Graph
d)
Sort Chart
7.
Which chart should you use to show changes over time?
a)
Line
b)
Scatter
c)
Pie
d)
Bar
8.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
9.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
10.

What symbol should be used to perform an adding calculation?

a)

+

b)

-

c)

*

d)

/

11.

What symbol should be used to perform a subtraction calculation?

a)

-

b)

*

c)

+

d)

/

12.

What symbol should be used to perform a multiplying calculation?

a)

+

b)

-

c)

*

d)

/

13.

What symbol should be used to perform a division calculation?

a)

/

b)

-

c)

*

d)

+

14.

What software do we use to create spreadsheets?

a)

Word

b)

PowerPoint

c)

Sway

d)

Publisher

e)

Excel

15.

What are spreadsheets used for?

a)

To perform powerful calculations

b)

Make graphs and charts

c)

Analyse patterns in the data

d)

To store information and data

16.

A spreadsheet is made up of one "workbook" and can have have many "worksheets".

a)

True

b)

False

17.

Worksheets appear as tabs at the bottom of the spreadsheet.

a)

True

b)

False

18.

What is the name of each "box" on a spreadsheet?

a)

Cell

b)

Box

c)

Rectangle

19.

A cell reference is the specific location of the active cell (E.g. A1).

a)

True

b)

False

20.

What is the correct order for the parts that make up a Cell Reference?

a)

Letter then Number

b)

Number then Letter

21.
An individual box within a worksheet is known as?
a)
square
b)
range
c)
refernce
d)
cell
22.
Which of the following would NOT be stored in a cell?
a)
Formula
b)
Text
c)
Number
d)
Chart
23.

What is normally used to perform calculations in a spreadsheet?

a)

Magic

b)

Formula

c)

Conditional formating

d)

Macro

24.
Which of the following is an example of a cell reference?
a)
a. Column C
b)
b. =SUM
c)
c. Row 1
d)
d. A5
25.
The cell in which you are currently working is known as what?
a)
Active cell
b)
Cell address
c)
Cell reference
d)
Spreadsheet cell