Question

The monthly sales of a company for the first six months are given below in Rupees (₹). 

Hint:

Excel functions like \texttt{SUM}, \texttt{AVERAGE}, \texttt{MIN}, and \texttt{MAX} are powerful tools for analyzing and summarizing data in financial reports.

Answer 1

(a) Find the total sale for the six months. 
To calculate the total sale, use the SUM formula in Excel: \[ \text{Total Sale} = \text{SUM(B2:B7)} \] This formula adds all the sales figures from January to June, giving the total sale for the six months. 
(b) Find the average sale of the six months. 
To calculate the average sale, use the AVERAGE formula in Excel: \[ \text{Average Sale} = \text{AVERAGE(B2:B7)} \] This formula calculates the average of the sales for the six months. 
(c) Find the lowest sale of the six months. 
To find the lowest sale, use the MIN formula in Excel: \[ \text{Lowest Sale} = \text{MIN(B2:B7)} \] This formula returns the lowest sale figure from the list. 
(d) Find the highest sale of the six months. 
To find the highest sale, use the MAX formula in Excel: \[ \text{Highest Sale} = \text{MAX(B2:B7)} \] This formula returns the highest sale figure from the list.