Question

SPREADSHEET TOOL OO CALCI 271
Type B : Application Oriented Questions
1. A university student uses a PC to help plan a budget for the first term. Their first attempt is shown
below
8
1 Weekly Budget
2.
1
D
E
3
Income
Student Loan (per term)
5 Monthly allowance from parents
6 Weekly wage from part-tme job
Amount in
(Rs.)
94500
6700
1400
Income
per week
Weeks in (Rs.)
12 7870
4 1680 5
1 1440
7
8
Total Income per week
10990 5
10
11
Amount
12100
2250
11250
6700
Spending
12 Rent (paid monthly
13 Gas/electric bills (paid monthly)
14 House bills - food etc (per month)
15 Books etc for university (per term)
16 Clothes (per term)
17 Travel (per term)
18 Leisure nights out etc
19 Leave in bank for unexpected spending
20
21 Total spending per week
Spending
per week
Weeks in (Rs.)
4
3030 5
4 560 5
4 28105
12 560 5
12 7855
12 450
1
2250
12
374 5
9450
9450
2250
4500
10822
168 5
23 Money left per week
(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 ?
(0) Which one of the following is the formula used in cell D23 ?
Tick one box only
= D21 - 08
D8 - D21
sum(D2:012)
(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​

Answer 1

Answer:

offucfyxyixfx dxdyz Dr ryzryxfuxrxryxf

Answer 2

Answer:

The presence of starch in leaves can be tested by the Iodine test. When we remove chlorophyll from the leaf by boiling it in alcohol and then put two drops of iodine solution, it is colour change to blue indicates the presence of starch.