Page 221 - CA 165 ver 1.0 Class 9
P. 221
3. ..................................... is the pictorial representation of data present in a worksheet.
4. ..................................... is the process of arranging data in ascending and descending order based on a
particular field.
5. ..................................... error occurs when a cell reference is not valid.
PART B
A. Short answer type questions.
1. Explain any two logical functions with example.
2. Define Operators. List and describe all the operators.
3. Describe the reason for the occurrence of the following errors:
i. #VALUE ii. #REF!
4. Write down the steps to hide columns in OpenOffice Calc.
5. Explain the following terms used in a chart:
i. Data Series ii. Walls & Floors
B. Long answer type questions.
1. What is Formula? Explain the different types of formula used in ‘Calc’.
2. What is the significance of Cell Referencing? Explain the different types of cell referencing used in ‘Calc’.
3. What are the different parts of a Function? Explain with an example.
4. Explain different types of errors in ‘Calc’.
5. What are Charts in ‘Calc’? Discuss different types of Charts.
C. 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 Calc. Which formula has she used in the cell B8?
Data Analysis 219

