wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet Post Assessment

Total questions: 20

Worksheet time: 2hrs 40mins

Name
Class
Date
1.

To change the width of a row, you do this.

a)

hover between the column letters until you see a double arrow then slide it left or right.

b)

hover between the numbers on the left until you see a double arrow then slide it up or down.

c)

select one of the tools from the tool bar that makes the letters larger.

d)

select one of the tools from the tool bar that makes the numbers larger.

2.

To change the width of a column, you do this.

a)

hover between the column letters until you see a double arrow then slide it left or right.

b)

hover between the numbers on the left until you see a double arrow then slide it up or down.

c)

select one of the tools from the tool bar that makes the letters larger.

d)

select one of the tools from the tool bar that makes the numbers larger.

3.

Where are the pages of a spreadsheet workbook located?

a)

at the top next to the title

b)

at the bottom of the spreadsheet

c)

on the left side next to the row numbers

d)

on the right side

4.

Which tool is used to make the borders darker?

a)
b)
c)
d)
5.

Which tool is used to wrap text so you can see all the text?

a)
b)
c)
d)
6.

Which tool is used to merge cells together?

a)
b)
c)
d)
7.

Which cell is the active cell in this spreadsheet?

a)

B4

b)

A4

c)

C1

d)

B7

8.

What is the name of this workbook? Hint: Its the title of the spreadsheet.

a)

Workbook

b)

Practice spreadsheet #1

c)

Practice

d)

Your Name

9.

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

a)

B3

b)

A2

c)

Row B

d)

3B

10.

Which are correct equations to enter if you want to add 5 and 3? There is more than 1 answer.

a)

=sum(B3:b4)

b)

=B3+B4

c)

=5+3

d)

=3+5

11.

How do we name the rows in a spreadsheets?

a)

With colors

b)

With numbers

c)

With letters

d)

With a code

12.

How do we name the columns in a Spreadsheet

a)

With numbers

b)

With letters

c)

With a code

d)

With colours

13.

Select all the equations that are in the correct form.

a)

=sum(A1:A10)

b)

45+23=

c)

=45+23

d)

=B2+C4

14.

What is the name of this part of a Spreadsheet?

a)

Row

b)

Column

c)

Letters

d)

Cells

e)

Spreadsheet

15.

What is the name of this part of a Spreadsheet?

a)

Row

b)

Column

c)

Letters

d)

Cells

e)

Spreadsheet

16.

The spreadsheet is called a workbook and the pages are called sheets.

a)

True

b)

False

17.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)

+sum(c9:c10)

18.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
19.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
20.

What are individual rectangles on a spreadsheet called.

a)

Workbook

b)

Spreadsheet

c)

Cell

d)

Entry