Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
241 views
in Spread Sheet by (27.3k points)
closed by

From the given values, calculate the following:

Values 500 300 700 600 300 400 200
  • Find the number of values 
  • Find the total sum of the values 
  • Find the average 
  • Find the largest value 
  • Find the smallest value

1 Answer

+1 vote
by (25.6k points)
selected by
 
Best answer

Procedure: 

Step 1 – Open a new blank worksheet in LibreOffice Calc

Step 2 – Enter the values in the work sheet as follows.

Step 3 – Enter the following text in the respective cells.

Cell Text
A8 Number of values
A9 Sum of the values
A10 Average
AH Largest value
A12 Smallest value

Step 4 – Enter the following formula in the respective cells.

Cell Formula
B8 = COUNT (A1: A7)
B9 = SUM(A1: A7)
B10 = AVERAGE/A1: A7)
B11 = MAX/A1: A7)
B12 = MIN(A1: A7)

Output:

Number of values 7
Sum of the values 3000
Average 429
Largest value 700
Smallest value 200

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...