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