Question

Below is given the table showing the Name, Class, and Fees due to different students. 

• Find out the total fees due from the students. 
• Find the average amount of fees 
• Find the highest amount of fees 
• Find the lowest amount of fees

Answer 1

Procedure:

Step 1 – Open a new blank worksheet in LibreOffice Calc 

Step 2 – Enter the following details in the worksheet as follows.

Step 3 – Enter the following text in respective cells.

Cell	Text
A9	Total Fess due
A10	Averages Fees
A11	Highest amount of fees
A12	Lowest amount of fees

Step 4 – Enter the following formula in respective cells

Cell	Formula
B9	= SUM (D2: D8)
B10	= Average (D2: D8)
B11	= Max (D2;D8)
B12	= Min (D2: D8)

Output:

Total Fees Due	2700
Average Fees	386
Highest Amount of Fees	625
Lowest Amount of Fees	60