wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet basics

Total questions: 20

Worksheet time: 14mins

Name
Class
Date
1.

What are the individual rectangles on a worksheet called?

a)

Rows

b)

Columns

c)

Cells

d)

Formulae

2.

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

a)

Row

b)

Column

3.

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

a)

Row

b)

Column

4.

How are columns labelled on a worksheet?

a)

Letters

b)

Numbers

5.

How are rows labelled on a worksheet?

a)

Letters

b)

Numbers

6.

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

7.

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

8.

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

a)

Cell width

b)

Cell height

c)

Text colour

d)

Font size

9.

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

a)

Formula

b)

Formatting

10.

What do all formulae start with in a spreadsheet?

a)

+

b)

/

c)

*

d)

=

11.

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

a)

/

b)

-

c)

+

d)

=

12.

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

a)

/

b)

-

c)

*

d)

=

13.

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

a)

/

b)

-

c)

*

d)

=

14.

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

a)

/

b)

-

c)

*

d)

=

15.

If you wanted to add the values in four consecutive cells together which function would you use?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

16.

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

a)

A3

b)

3A

c)

C5

d)

D7

17.

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

a)

8A

b)

C5

c)

A8

d)

B8

18.

To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?

a)

Item

b)

Price

c)

Number Sold

d)

Total

19.

Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Fanta

a)

£1.25 times 12

b)

C5*D5

c)

=C5*D5

20.

Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Walkers salt and vinegar.

a)

£0.65 times 23

b)

C10 * D10

c)

=C10 * D10