wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets Knowledge Check

Total questions: 15

Worksheet time: 16mins

Name
Class
Date
1.

The intersection between a row and a column is known as what?

a)

Row

b)

Cell

c)

Column

2.

The part labelled in red is called what?

a)

Active Cell

b)

Column

c)

Row

3.

The part labelled in blue is called what?

a)

Active Cell

b)

Column

c)

Row

4.

Write the cell address of 3

4 lines
5.

Write the cell address of 5

4 lines
6.

Write the cell address of 6

4 lines
7.

What are individual rectangles on a spreadsheet called.

a)

Workbook

b)

Spreadsheet

c)

Cell

d)

Entry

8.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
9.
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)

10.

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

a)

True

b)

False

11.

Select all the equations that are in the correct form.

a)

=sum(A1:A10)

b)

45+23=

c)

=45+23

d)

=B2+C4

12.

How do we name the columns in a Spreadsheet

a)

With numbers

b)

With letters

c)

With a code

d)

With colours

13.

How do we name the rows in a spreadsheets?

a)

With colors

b)

With numbers

c)

With letters

d)

With a code

14.

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.

15.

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.