wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets

Total questions: 20

Worksheet time: 12mins

Name
Class
Date
1.

What do you use in the beginning of a function/formula?

a)

/

b)

#

c)

=

d)

*

2.

what is the selected cell in this image?

a)

A4

b)

C78

c)

09V

d)

A1

3.

What does merge mean?

a)

multiplication

b)

dividing

c)

combine cells

d)

select all

4.

What is the range of the selected cells?

a)

C9:D10

b)

B11:E6

c)

C8:D12

d)

S23637282:F20349

5.

Who is the favorite student based on this graph?

a)

Makenna

b)

David

c)

Gavin

d)

Zaheim

e)

Brady

6.

What could we do to this graph to make it neater?

a)

Add more people

b)

Add different colors

c)

Make a border around everything

d)

Bold the names

e)

Make a graph

7.

 =SUM(F4:F17)=SUM\left(F4:F17\right)  
What will this function do?

a)

Add F4:F17

b)

Subtract F4:F17

c)

Pineapple 

d)

Add the aveage 

8.

What are rows labeled by?

a)

numbers

b)

letters

c)

shapes

d)

colors

9.

What are columns labeled by?

a)

numbers

b)

letters

c)

colors

d)

shapes

10.

What is a cell?

a)

Color

b)

Column and row combined

c)

human body organism

d)

shape

11.

How do you change the size of a column?

a)

Bob

b)

Drag the arrow between 2 columns

c)

drag a cell

d)

select cells the size you want the column

12.

What will this function do?


=(C6*F3)

a)

Subtract C6 from F3

b)

Multiply C6 by F3

c)

Multiply C6 by F5

d)

Divide G6 by D7

13.

Why do you need an equal sign at the beginning of every function?

a)

It makes the function work

b)

It is equal to everything

c)

I have no idea

d)

because it divides your answer

14.

What kind of graph/chart(s) can we use to show data?

a)

Bar graph

b)

Pie chart

c)

Line graph

d)

table chart

15.

What can be used to show what the content of a column involves?

a)

numbers

b)

labels

c)

subheading

d)

title

16.

What data can be figured out by the chart?

a)

What is tom's percentage?

b)

How many people don't like cats?

c)

Why are dogs mean?

d)

What is the most common name?

17.

Will this formula work?

-(F7:G8)

(a)  

18.

What can you do to the title to cover more than one cell?

a)

merge it with different cells

b)

add a function

c)

out a subheading below it

d)

make sure to add a title

19.

Can you use the divison sign in a function?

a)

yes

b)

no

c)

maybe

20.

how do you add a chart?

a)

insert>chart

b)

add-ons

c)

insert

d)

shift