Page 237 - CA_165_V2.0_C9_Flipbook
P. 237
3. What are the different parts of a Function? Explain with an example.
4. Explain different types of errors in OpenOffice Calc.
5. What are Charts in OpenOffice Calc? Discuss different types of Charts.
D. Application based questions.
1. Akash Kumar is inserting the marks for 1st summative test. He wants to perform some calculations and do
analysis, i.e., Max, Min, Abs. Which Office application will you suggest Akash to use for this purpose?
2. While writing a formula Sudeep found an error having “####”. Name this error.
3. Sugandha has made the following data entries in OpenOffice Calc. Which formula has she used in the
cell B8?
SECTION C
(Case-based/Passage-based Type Questions)
Data can be easily displayed through charts in a spreadsheet package. Based on the same data, a user can easily
switch from one type of chart to another. The charts are always linked to the data they are depicting. If you
make any change in the data, it will be reflected in charts also.
1. .................................... charts help to compare how each value relates proportionally to the whole.
i. Bar ii. Pie
iii. Line iv. Area
2. Which among the following is a version of a line or column graph? It is useful to emphasise on volume of
changes of data.
i. X-Y Scatter ii. Bar
iii. Pie iv. None of these
3. Which among the following is not an advantage of chart?
i. It summarises only small data set in visual form and estimates key value at a glance.
ii. Charts are visually appealing and it is easy for the users to compare the information.
iii. Charts help to forecast the trends on the basis of comparisons done.
iv. None of these
Data Analysis 235

