National 5 Admin Quiz

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

• Rectangle

• Square

• Cell

• Input cube

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

• Word

• Excel

• PowerPoint

• Access

Each cell in a spreadsheet is referred to by its:

• Cellname

• Nickname

• Name

• Cell reference

Examples of cell references might be...

• 2A, H8, 19K

• A2, H8, K19

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

• Row

• Column

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

• Row

• Column

What special name is given to text in a spreadsheet?

• Value

• Text

• Label

• Sticker

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

• Cell numbers

• Value

• Digits

• Figures

What symbol do all formulas begin with?

• -

• +

• ?

• =

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

• =A8:A8

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

• =sum(A3:A8)

• sum(A3:A8)