Spreadsheet Basics

A Cell in a Spreadsheet may contain some of the following.
Tick all that apply.
1. Text
2. Numbers
3. Range
4. Formula
When you type 1.234 into a Cell in a Spreadsheet, the appearance changes to £1.23. What does this tell you about the Cell?
1. It is locked
2. It has been formatted to 2 decimal places
3. It has been formatted to display Currency
4. It has been protected
A Function in a Spreadsheet may look like :-
1. = A3 + B4 + B5
2. A3 + B4 + B5
3. = SUM(A3 : B5)
4. SUM(A3 : B5)
A Formula in a Spreadsheet may look like :-
1. A3 + B4
2. A3 = B4
3. A3 + B4 =
4. = A3 + B4
Which of the following are Cell Attributes?
Tick all that apply.
1. Font size and colour
2. Border style and shading
3. Cell Protection
4. Range
What answer will you get from the Spreadsheet Formula
= 3 + 4 * 5
1. 12
2. 23
3. 35
4. 60
A Row is
1. A Vertical line of Cells
2. A Horizontal line of Cells
3. The Cells listed in a Formula
4. The Cells listed in a Function
Cell A5 contains the formula = A2 + A3 - A4
When A5 is copied to C5, the new formula will look like :-
1. =B2 + B3 - B4
2. = B3 + B4 - B5
3. = C2 + C3 - C4
4. = C3 + C4 - C5
Cell A6 contains the formula = A4 * $A$5
When this formula is copied to Cell B6, the formula changes to :-
1. =A4 * $A$5
2. =A4 * $B$5
3. =B4 * $A$5
4. =B4 * $B$5
What name could you give to all the Cells from C3 to G12
1. A Row
2. A Column
3. A Range
4. A Group
What type of Data does a Spreadsheet work with?
1. Text
2. Numbers
3. Fields
4. Graphical