SQA Spreadsheets UPDATED ACTUAL Exam Questions and CORRECT Answers

SQA Spreadsheets UPDATED ACTUAL
Exam Questions and CORRECT Answers
Model - CORRECT ANSWER - 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 - CORRECT ANSWER - Horizontal line of cells



Cell - CORRECT ANSWER - The boxes on the spreadsheet



Column - CORRECT ANSWER - A vertical line of cells



Cell Reference - CORRECT ANSWER - The column and the row number of a cell, e.g.
C13; F27;


Formula Bar - CORRECT ANSWER - A bar located between the ribbon and the worksheet
in which users can edit the contents of a cell.


+ - CORRECT ANSWER - This symbol is used in a formula to add



- - CORRECT ANSWER - This symbol is used in a formula to subtract



/ - CORRECT ANSWER - This symbol is used in a formula to divide



* - CORRECT ANSWER - This symbol is used in a formula to multiply



: - CORRECT ANSWER - Range operator: Means inclusive; including all the cells. For
Example; B3:B37 means b3,b4, b5,...to b37