Write the format of the functions used in MS Excel to perform the foll

1.	Write the format of the functions used in MS Excel to perform the followingtasks:1. To calculate the average of 82, 67, 80, 74 and 95. ______________________2. To find the highest value of the cell references from D3 to K3.______________________3. To calculate the sum of the first five multiples of 7.______________________4. To determine the lowest value of the cell references from A4 to A12.______________________5. To find the sum of all the prime numbers from 1 to 10.______________________6. To find the arithmetical mean of the cell references from E4 to K4.______________________
Answer» Explanation: To calculate the average of 82, 67, 80, 74 and 95. ______________________ 2. To find the highest value of the cell REFERENCES from D3 to K3. ______________________ 3. To calculate the sum of the first five multiples of 7. ______________________ 4. To determine the lowest value of the cell references from A4 to A12. ______________________ 5. To find the sum of all the prime numbers from 1 to 10. ______________________ 6. To find the ARITHMETICAL mean of the cell references from E4 to K4. ______________________

Write the format of the functions used in MS Excel to perform the followingtasks:1. To calculate the average of 82, 67, 80, 74 and 95. 2. To find the highest value of the cell references from D3 to K3.3. To calculate the sum of the first five multiples of 7.4. To determine the lowest value of the cell references from A4 to A12.5. To find the sum of all the prime numbers from 1 to 10.6. To find the arithmetical mean of the cell references from E4 to K4.

Answer»

Explanation:

To calculate the average of 82, 67, 80, 74 and 95.

______________________

2. To find the highest value of the cell REFERENCES from D3 to K3.

______________________

3. To calculate the sum of the first five multiples of 7.

______________________

4. To determine the lowest value of the cell references from A4 to A12.

______________________

5. To find the sum of all the prime numbers from 1 to 10.

______________________

6. To find the ARITHMETICAL mean of the cell references from E4 to K4.

______________________