The marks in Accountancy of some students are given below Name-Marks Priya- 89, Indira - -ab-, Sindhu - 56

Question

The marks in Accountancy of some students are given below

Name	Mark
Priya	89
Indira	-ab-
Sindhu	56
Reny	64
Beena	49
Bindu	50
Resmi	-ab-

Calculate: 

1. Number of students in the class 

2. Number of students appeared in the Accountancy examination 

3. Total marks in Accountancy examination 

4. Average Marks in Accountancy examination 

5. Lowest mark in Accountancy 

6. Highest mark in Accountancy

Answer 1

Procedure: 

Step 1 – Open LibreOffice Calc Work sheet Application → Office → LibreOffice Calc

Step 2 – Enter the given data in appropriate cells.

	A	B
1	Name	Mark
2.	Priya	89
3.	Indira	-ab-
4.	Sindhu	56
5.	Reny	64
6.	Beena	49
7.	Bindu	50
8.	Resmi	-ab-

Step 3 – Enter the following details and formula in the given cells

	A	B
9	Number of students	= COUNTA (A2 : A8)
10	Students appeared in exam	= COUNTA (B2 : B8)
11	Total mark	= SUM (B2 : B8)
12	Average mark	= AVERAGE (B2 : B8)
13	Lowest mark	= MIN (B2 : B8)
14	Highest mark	= MAX(B2 : B8)

Output: