Computer Applications
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)
Answer
The corrected formulae are given below:
- =SUM(C9:C14)
- =$B$3 * C$4
- =COUNT(9, 12, 17, 26)
This will give the output as 4 since there are 4 numeric values given as input to the count function. - =AVERAGE(A1:An)
where 'n' is the row number of the cell till where the average is required. - =MAX(19,70,101)
- =SUM(24,54,77)-38
Related Questions
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.
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.
Given below is a chart which shows the comparative study of the prices of TV sets of various companies:
On the basis of the above chart, answer the following questions:
(a) What is the type of the given chart?
(b) Name any two chart elements.
(c) Name the chart element to display the title.
(d) Which option will you select under chart element to display information along horizontal or vertical direction?