Write the format of the functions used in MS Excel to perform the following
tasks:
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.
______________________
Answers
Answered by
11
Answer:
(1) =AVERAGE (82+67+80+74+95)
(2) =MAX( D3:K3 )
(3) =SUM( 7+14+21+28+35 )
(4) =MIN( A4:A12 )
(5) =SUM( 2+3+5+7 )
(6) =SUM( E4:K4 ) / 7
Answered by
7
Answer:
(1) =AVERAGE (82+67+80+74+95)
(2) =MAX( D3:K3 )
(3) =SUM( 7+14+21+28+35 )
(4) =MIN( A4:A12 )
(5) =SUM( 2+3+5+7 )
(6) =AVERAGE( E4:K4 )
Explanation:
Hope it helps
Please mark as brainliest
Similar questions