Page 232 - CA_165_V2.0_C9_Flipbook
P. 232
C. Assertion and Reasoning question:
The following questions consist of two statements – Assertion (A) and Reasoning (R). Answer these
questions by selecting the appropriate option given below:
i. Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation of Assertion (A).
ii. Both Assertion (A) and Reason (R) are true but Reason (R) is not the correct explanation of Assertion (A).
iii. Assertion (A) is true, but Reason (R) is false.
iv. Assertion (A) is false, but Reason (R) is true.
1. Assertion (A): The =TODAY() function in OpenOffice Calc returns the current date.
Reason (R): The =TODAY() function does not require any arguments and updates automatically to
reflect the current date.
2. Assertion (A): Sorting data in OpenOffice Calc only works with numeric values.
Reason (R): Sorting in OpenOffice Calc can be done with both text (alphabetically) and numbers
(numerically), depending on the selected range
Ans. 1. i. 2. iii.
SECTION B
(Subjective Type Questions)
A. Very short answer type questions.
1. Name the error displayed when we write =SIM in place of =SUM while applying the sum function.
2. Which feature helps arrange data in ascending or descending order?
3. Name the chart that uses lines to show information and change over a period of time.
4. Name the chart that represents data in horizontal columns.
5. What is a set of values which the user wants to plot in a chart called?
Ans. 1. #NAME 2. Sorting 3. Line Chart 4. Bar Chart 5. Data Series
B. 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.
230 Touchpad Computer Applications (Ver. 2.0)-IX

