SQA Spreadsheets UPDATED ACTUAL Exam Questions and
CORRECT Answers
Model - A simulation of a real-life situation. For example, a spreadsheet model might be used to
help plan an event like a school trip or concert.
Row - Horizontal line of cells
Cell - The boxes on the spreadsheet
Column - A vertical line of cells
Cell Reference - The column and the row number of a cell, e.g. C13; F27;
Formula Bar - A bar located between the ribbon and the worksheet in which users can edit the
contents of a cell.
+ - This symbol is used in a formula to add
- - This symbol is used in a formula to subtract
/ - This symbol is used in a formula to divide
* - This symbol is used in a formula to multiply
: - Range operator: Means inclusive; including all the cells. For Example; B3:B37 means b3,b4,
b5,...to b37
CORRECT Answers
Model - A simulation of a real-life situation. For example, a spreadsheet model might be used to
help plan an event like a school trip or concert.
Row - Horizontal line of cells
Cell - The boxes on the spreadsheet
Column - A vertical line of cells
Cell Reference - The column and the row number of a cell, e.g. C13; F27;
Formula Bar - A bar located between the ribbon and the worksheet in which users can edit the
contents of a cell.
+ - This symbol is used in a formula to add
- - This symbol is used in a formula to subtract
/ - This symbol is used in a formula to divide
* - This symbol is used in a formula to multiply
: - Range operator: Means inclusive; including all the cells. For Example; B3:B37 means b3,b4,
b5,...to b37
