WorksheetsNational 5 Admin Quiz
Total questions: 17
Worksheet time: 6mins
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)
To multiply with a spreadsheet formula, you must use a different symbol. On your keyboard, this is:
£
X
*
?
To divide with a spreadsheet formula, you must use a different symbol. On your keyboard, this is:
=
/
?
@
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.
Alignment of Data
Different fonts, styles, sizes
Formatting sales to currency/number/percentage to specified decimal places.
Borders and shading
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.
Alignment of Data
Different fonts, styles, sizes
Formatting sales to currency/number/percentage to specified decimal places.
Borders and shading
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.
Alignment of Data
Different fonts, styles, sizes
Formatting sales to currency/number/percentage to specified decimal places.
Borders and shading
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.
Alignment of Data
Different fonts, styles, sizes
Formatting sales to currency/number/percentage to specified decimal places.
Borders and shading
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.
True
False
