wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheet Basics

Total questions: 35

Worksheet time: 18mins

Name
Class
Date
1.

A vertical line of cells in a spreadsheet is a what?

a)

Row

b)

Column

2.

A horizontal line of cells in a spreadsheet is a what?

a)

Row

b)

Column

3.

If you wanted to change the colour of the text inside a cell, which tool would you use?

a)

Text colour

b)

Fill colour

c)

Borders

d)

Bold

4.

If you wanted one cell or a number of cells to stand out from the rest which tool could you use?

a)

Bold

b)

Fill Colour

c)

Currency

d)

Borders

5.

Something that automatically calculates something for you using the data in cells is a:

a)

Formula

b)

Formatting

6.

What do all formulae start with in a spreadsheet?

a)

+

b)

/

c)

*

d)

=

7.

Which mathematical operator (symbol) would you use if you are adding the values in cells together?

a)

/

b)

-

c)

+

d)

=

8.

Which mathematical operator (symbol) would you use to divide the values in two cells?

a)

/

b)

-

c)

*

d)

=

9.

Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?

a)

/

b)

-

c)

*

d)

=

10.

Which mathematical operator (symbol) would you use to multiply the values in two cells together?

a)

/

b)

-

c)

*

d)

=

11.

What is the cell reference of the cell with value Coca-Cola inside?

a)

A3

b)

3A

c)

C5

d)

D7

12.

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

a)

8A

b)

C5

c)

A8

d)

B8

13.
The intersection of a row and column in a spreadsheet is called a __________.
a)
Cell
b)
Formula
c)
Label
d)
Value
14.
In spreadsheets, columns are marked with _________.
a)
Letters
b)
Numbers
c)
= sign
d)
Both a letter and a number
15.
In spreadsheets, rows are marked with _____.
a)
Letters
b)
Numbers
c)
= sign
d)
Both a letter and a number
16.
Is it a formula or a function:
=Sum(E2:E25)
a)
Formula
b)
Function
17.
Is this a formula or a function?
=A1 + B5 + C10
a)
Formula
b)
Function
18.
Each box on a spreadsheet is called a ...
a)
row
b)
column
c)
cell
d)
box
19.

What is the name of this part of a Spreadsheet?

a)

Row

b)

Column

c)

Letters

d)

Cells

e)

Spreadsheet

20.

What is the name of this part of a Spreadsheet?

a)

Row

b)

Column

c)

Letters

d)

Cells

e)

Spreadsheet

21.

What is the name of this part of a Spreadsheet?

a)

Row

b)

Column

c)

Letters

d)

Cell

e)

Spreadsheet

22.

How do we call the text in bold in this spreadsheet?

a)

Values

b)

Columns

c)

Capitals

d)

Labels

23.

How do we call the part in orange in this spreadsheet?

a)

Price

b)

Items

c)

Labels

d)

Values

24.

What is the cell reference of the one that is highlighted?

a)

B3

b)

A2

c)

Row B

d)

3B

25.

The graph shows the number of colored beads used to make a necklace. How many purple and green beads were used in all?

a)

23

b)

20

c)

18

d)

15

26.
How many students' favorite color is blue?
a)
11
b)
12
c)
14
d)
17
27.

The least animals in the farm are . . . .

a)

cows

b)

chicken

c)

sheep

28.
Katie asked her friends their favorite food. Select the number of tally marks for Hot Dog.
a)
3
b)
4
c)
5
d)
6
29.
What type of graph is this?
a)
Bar Graph
b)
Line Plot
c)
Pictograph
d)
Tally Chart
30.

Which circle graph has the same data as the bar graph?

a)
b)
c)
d)
31.
According to this graph, what is the most popular flavor of Jolly Rancher?
a)
Cherry
b)
Grape 
c)
Blue Rasberry
d)
Watermelon
32.

Name the type of graph.

a)

pie chart

b)

tally chart

c)

pictograph

d)

bar graph

33.

Name the type of graph.

a)

pie chart

b)

tally chart

c)

pictograph

d)

bar graph

34.

Name the type of graph.

a)

pie chart

b)

tally chart

c)

pictograph

d)

bar graph

35.
What type of graph is this?
a)
Line Graph
b)
Pictograph
c)
Bar Graph
d)
Histogram