Computer Applications
Write the format of the functions used in MS Excel to perform the following tasks:
To find the sum of all the prime numbers from 1 to 10.
Related Questions
Write the format of the functions used in MS Excel to perform the following tasks:
To calculate the sum of the first five multiples of 7.
Write the format of the functions used in MS Excel to perform the following tasks:
To determine the lowest value of the cell references from A4 to A12.
Write the format of the functions used in MS Excel to perform the following tasks:
To find the arithmetical mean of the cell references from E4 to K4.
Spot the error in each of the following:
- =SUM ('C9':C14)
- =$B*$3*C$
- =COUNT(9, 12, 17, 26, A$)
- =AVERAGE(A1:An)/n
- =MAX('19', 70, 101)
- =ADD(24+54+77-38)