2. Ravi wants to create a table that calculates the total expenditure and profit of his company in a spreadsheet. In the spreadsheet, he wants to calculate the total and average profits of the company. He also wants to calculate the average expenditure and profit.
The cells from A2 to A85 contain the expenses of the year. The cells B2 to B8 5. contain the total profit of the year.
Answers
Answer:
Ravi wants to create a table that calculates the total expenditure and pro
of his company in a spreadsheet. In the spreadsheet. he wants to calculate
the total and average profits of the company. He also wants to calculate the
The cells from A2 to A85 contain the expenses of the year. The cells B2 to be
average expenditure and profit.
contain the total profit of the year.
(a) Write the formula to calculate the total expenditure in cell AB6
(52
Write the formula to calculate the total profit in cell 386.
Write the formula to find out the total profit in cell C86.
Write the formula to find out the average expenditure in cell AB7
Write the formula to find out the average profit in cell B87.
Write the formula to find out the average expenditure in cell C87