Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

National 5 Admin Quiz

Total questions: 17

Worksheet time: 6mins

Name
Class
Date
1.

Each ‘box’ in a spreadsheet is known as a:

a)

Rectangle

b)

Square

c)

Cell

d)

Input cube

2.

For spreadsheets, the name of the software we use is:

a)

Word

b)

Excel

c)

PowerPoint

d)

Access

3.

Each cell in a spreadsheet is referred to by its:

a)

Cellname

b)

Nickname

c)

Name

d)

Cell reference

4.

Examples of cell references might be...

a)

2A, H8, 19K

b)

A2, H8, K19

5.

The name given to a collection of cells going along in a straight line is:

a)

Row

b)

Column

6.

The name given to a collection of cells going down the way is:

a)

Row

b)

Column

7.

What special name is given to text in a spreadsheet?

a)

Value

b)

Text

c)

Label

d)

Sticker

8.

What special name is given to a number in a spreadsheet?

a)

Cell numbers

b)

Value

c)

Digits

d)

Figures

9.

What symbol do all formulas begin with?

a)

-

b)

+

c)

?

d)

=

10.

A quick formula to add cells A3, A4, A5, A6, A7 and A8 would be:

a)

=A8:A8

b)

=sum(A3+A4+A5+A6+A7+A8)

c)

=sum(A3:A8)

d)

sum(A3:A8)

11.

To multiply with a spreadsheet formula, you must use a different symbol. On your keyboard, this is:

a)

£

b)

X

c)

*

d)

?

12.

To divide with a spreadsheet formula, you must use a different symbol. On your keyboard, this is:

a)

=

b)

/

c)

?

d)

@

13.

Identify the type of formatting being described below:


Placing this around the cell makes it stand out by having a thick line around the cell or having a colour in the background of the cell.

a)

Alignment of Data

b)

Different fonts, styles, sizes

c)

Formatting sales to currency/number/percentage to specified decimal places.

d)

Borders and shading

14.

Identify the type of formatting being described below:


Text can be placed horizontally in the left, right or centre. In the spreadsheet text is automatically left aligned and numbers and values are automatically right aligned.


The direction of the text within a cell can be rotated. Or the text can be wrapped to be shown over more than one line within a cell and also aligned horizontally. Wrapping text is more useful than inserting a long column heading.

a)

Alignment of Data

b)

Different fonts, styles, sizes

c)

Formatting sales to currency/number/percentage to specified decimal places.

d)

Borders and shading

15.

Identify the type of formatting being described below:


Cells can be formatted for appearance for example to show the contents as a specified size, in bold, underlined or italicised. Formatting in this way helps identify information that is important for example headings.

a)

Alignment of Data

b)

Different fonts, styles, sizes

c)

Formatting sales to currency/number/percentage to specified decimal places.

d)

Borders and shading

16.

Identify the type of formatting being described below:


A cell can be formatted to show any number entered to appear automatically with a £, % or with a specific number of decimal places for example two.

a)

Alignment of Data

b)

Different fonts, styles, sizes

c)

Formatting sales to currency/number/percentage to specified decimal places.

d)

Borders and shading

17.

You should always check the exact formatting required. As this may lose you marks in the exam because you have not formatted to the correct number of decimal places.

a)

True

b)

False