CBSE Class 9 Computer Applications
Question 4 of 53
Spreadsheet Tool : OO Calc I — Question 4
Back to all questions 4
Question Question 4
A finance officer uses a spreadsheet to record sales from an equipment shop. This is part of the spreadsheet.
(a)
| Label | Formula | Label | Formula |
|---|---|---|---|
| A | =SUM(D4 : D10) | D | =SUM(D4 : D8) |
| B | =B7 * C7 | E | =A7 * B7 * C7 |
| C | =C6 * D6 |
- Write the label of the formula in cell D7.
- Write the label of the formula in cell D10.
(b) The price of a generator is reduced to 4000.00.
- Describe how the spreadsheet should be edited.
- When the spreadsheet was edited, the values displayed in some cells changed automatically. Write in the box the cell reference of two cell that changed automatically.
- Tick one box to show why a cell would change automatically when another cell is edited.
| Tick one box only | |
|---|---|
| Spreadsheet cells are all linked | |
| The cell contains a formula that refers to the other cell | |
| All the cells know what is happening in other cells | |
| The cell contains a description that refers to the other cell | |
| The spreadsheet contains a graph |
(a)
- The label of the formula in cell D7 is B.
- The label of the formula in cell D10 is D.
(b)
To edit the price of the generator, follow the given steps:
Step 1 — Select cell B6.
Step 2 — Type '4000' in the cell. The previous value (5000) will be overwritten.
The formula of cell D6 (= B6 * C6) will automatically update the sales value in the spreadsheet.D6 and D10.
Reason for cell updating automatically:
| Tick one box only | |
|---|---|
| Spreadsheet cells are all linked | |
| The cell contains a formula that refers to the other cell | ✓ |
| All the cells know what is happening in other cells | |
| The cell contains a description that refers to the other cell | |
| The spreadsheet contains a graph |