Question

Observe
10
11
(c) Write the Excel function that is used to calculate Maximum Expenditure displayed
(e) Which Excel tool is used to display the headings in the first two rows so that they spel
My House Budget
Year - 2012
Total
Expenditure
January February March
Head
Expenditure
4 House Rent 26000 26000 26000
76000
6 Food
16000 20000 23000
68000
6 Entertainment 10000 8000 4000
22000
7 Petrol
16000 16000 14000
45000
o Electricity 7000
6000 8600
21600
Telephone 3000 3600 6000
12600
Total
Expenditure 234000
Max. Total
12 Expenditure 75000
Max. Total
13 Expenditure 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
B13
over the whole worksheet columns?
(d) Write the Excel function that is used to calculate Total Expenditure displayed in calle​

Answer 1

Answer:

Observe

10

11

(c) Write the Excel function that is used to calculate Maximum Expenditure displayed

(e) Which Excel tool is used to display the headings in the first two rows so that they spel

My House Budget

Year - 2012

Total

Expenditure

January February March

Head

Expenditure

4 House Rent 26000 26000 26000

76000

6 Food

16000 20000 23000

68000

6 Entertainment 10000 8000 4000

22000

7 Petrol

16000 16000 14000

45000

o Electricity 7000

6000 8600

21600

Telephone 3000 3600 6000

12600

Total

Expenditure 234000

Max. Total

12 Expenditure 75000

Max. Total

13 Expenditure 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

B13

over the whole worksheet columns?

(d) Write the Excel function that is used to calculate Total Expenditure displayed in calle