Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet Test

Total questions: 12

Worksheet time: 6mins

Name
Class
Date
1.

Which tool do you use to add a set of numbers?

a)

sort and filter tool

b)

borders tool

c)

fx tool

d)

increase decimal tool

2.

To organize a list of names in alphabetical order, which tool would you use?

a)

sort and filter tool

b)

increase decimal tool

c)

fx tool

d)

borders tool

3.

Why would you use a spreadsheet?

a)

To write a letter to your best friend

b)

To create a presentation for your teacher

c)

To create a budget

4.

What is a spreadsheet?

a)

a blank document like a sheet of paper, usually used to write letters or reports

b)

a type of presentation

c)

a document that is used to organize information or calculate data

5.

A cell that has a dark green box around it and is currently selected is called

a)

bordered

b)

active cell

c)

centered

d)

calculated

6.

What are the boxes on a spreadsheet called?

a)

cells

b)

active

c)

rows

d)

columns

7.

What are the group of cells that go up and down called?

a)

Rows

b)

Columns

8.

What are the group of cells that go across called?

a)

Rows

b)

Columns

9.

Which symbol key do you use to create a formula in a cell?

a)

#

b)

=

c)

$

d)

%

10.

Which of the following is an example of a cell name or address?

a)

B4

b)

C

c)

9

d)

=sum(B4:C4)

11.

Which function would you use to create a multiplication problem on a spreadsheet?

a)

sum

b)

product

c)

times

d)

x

12.

Which of the following is an example of a formula in spreadsheet?

a)

B4

b)

C

c)

9

d)

=sum(B4:C4)