А
My House Budget
Year - 2012
January February March
3
26000
25000
20000
Expenditure
Head
4 House Rent
6 Food
6 Entertainment
7 Petrol
• Electricity
• Telephone
16000
10000
16000
7000
3000
Total
Expenditure
75000
68000
22000
46000
21500
12500
26000
23000
4000
14000
8600
6000
8000
16000
6000
3600
3. Observe the following Excel worksheet and answer the questions that follow
(c) Write the Excel function that is used to calculate Maximum Expenditure displayed in cell
(d) Write the Excel function that is used to calculate Total Expenditure displayed in cell Bil.
B13
10
234000
Total
11 Expenditure
Max. Total
12 Expenditure
Max. Total
13 Expenditure
75000
12500
(a) How many rows and columns are utilised in the worksheet?
(b) What is the cell address of the cell displaying Total Expenditure on Entertainment?
(e) Which Excel tool is used to display the headings in the first two rows so that they span
over the whole worksheet columns?
Answers
Answered by
0
Answer:
excuse me what type of question it is this is sooooooo long
Answered by
0
Answer:
hjgjchcjvnc FB check
hjhghjjuu hjgjchcjvn hurdy-gurdies
Similar questions