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 |