Page 218 - CA 165 ver 1.0 Class 9
P. 218
4. What is the formula to find out the most costly item in the list?
i. =MAX(D4:D10) ii. =MAX(D4;D10)
iii. =MAX(F4:F10) iv. =MAX(F4;F10)
5. What is the data type for the field ‘Items purchased’?
i. Numeric ii. Alpha–Numeric
iii. Date/Time iv. Formula
Ans. 1. iii 2. ii 3. iii 4. i 5. i
PART B
A. Short answer type questions.
1. What is meant by sorting data?
Ans. Sorting refers to the process of arranging data in ascending or descending order based on a certain
criteria.
2. State the purpose of TODAY() and NOW() functions.
Ans. TODAY() produces the current date, it contains no argument.
NOW() produces the current date and time, it contains no argument.
3. What is meant by Gridlines in a chart?
Ans. Gridlines refers to the horizontal and vertical lines in the plot area. The gridlines are inserted in the chart
to enhance its readability.
4. What does a #REF! error indicate?
Ans. #REF! occurs when a cell reference is not valid.
5. Give difference between column chart and a bar chart.
Ans. Column chart Bar chart
A column chart represents the data over a A bar chart represents the data in horizontal
period of time in columns. columns.
The measurement values are shown vertically The measurement of values are organized
as Y-axis. horizontally.
6. What is a chart? List any three advantages of a chart.
Ans. Charts and graphs are visual or graphical representation of data from a worksheet which is very useful for
instant analysis and decision making. Three advantages of charts are:
● Charts summarize large data set in visual form and estimate key value at a glance.
● Charts are visually appealing and it is easy for the users to compare the information.
● Charts help to forecast the trends on the basis of comparisons done.
B. Long answer type questions.
1. Discuss the components of an Excel formula using an example.
Ans. A formula in a spreadsheet package may consist of the following:
● Cell Address: A1, C11, A24:B36, etc.
● Functions: SUM, MAX, MIN, etc.
● Equal to’ operator: A formula always starts with an ‘=’ operator.
● Operators: + (Addition), - (Subtraction), * (Multiplication), / (Division), Exp (Exponent) are mathematical
operators. >(Greater than), <(Less than), = (Equal to), <>(Not equal to), <= (Less than or equal to),
>=(greater than or equal to) are relational operators.
● Parenthesis: ().
216 Touchpad Computer Applications-IX

