CBSE Class 9 Computer Applications
Question 1 of 53
Spreadsheet Tool : OO Calc I — Question 1
Back to all questions 1
Question Question 1
A university student uses a PC to help plan a budget for the first term. Their first attempt is shown below.
(a) Tick one box to show which type of software package has been used.
| Tick one box only | |
|---|---|
| Graphics | |
| Database | |
| Spreadsheet | |
| Multimedia |
(b) Which cell contains the spending on rent per week ?
(c) Which one of the following is the formula used in cell D23 ?
| Tick one box only | |
|---|---|
| = D21 - D8 | |
| = D8 - D21 | |
| = sum(D2 : D12) |
(d) Tick one box to show a disadvantage of using a software package to help work out the budget rather than using a calculator, pen and paper.
| Tick one box only | |
|---|---|
| The formulae could be wrong | |
| The wrong prices could be input | |
| A virus may corrupt the information | |
| Multiple printouts could be produced |
(a)
| Tick one box only | |
|---|---|
| Graphics | |
| Database | |
| Spreadsheet | ✓ |
| Multimedia |
(b) D12
(c)
| Tick one box only | |
|---|---|
| = D21 - D8 | |
| = D8 - D21 | ✓ |
| = sum(D2 : D12) |
(d)
| Tick one box only | |
|---|---|
| The formulae could be wrong | |
| The wrong prices could be input | |
| A virus may corrupt the information | ✓ |
| Multiple printouts could be produced |