Page 236 - CA_165_V2.0_C9_Flipbook
P. 236
B. Fill in the blanks.
1. The addressing of a cell in a formula is called ......................................
2. ..................................... referencing is a way to apply formula in which the value of range of cells do not change
even if the formula is copied to a new cell.
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.
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): In OpenOffice Calc, mixed referencing allows copying formulas while keeping either the
row or column fixed.
Reason (R): A mixed reference like $A1 or A$1 ensures only one part remains constant when copied.
2. Assertion (A): The <> operator in OpenOffice Calc is used to compare two numeric values only.
Reason (R): In OpenOffice Calc, the <> operator checks for inequality and can be used to compare both
numeric and text values.
SECTION B
(Subjective Type Questions)
A. Very short answer type questions.
1. Give formula to add content of cell A2 and A3.
2. What is the formula to divide the content of C4 by the product of content of cells A3 and A5.
3. How to find out minimum value out of the range B3: B7? Give formula.
4. What is the formula to find out the no. of employees whose salaries are given in the range D6:D30.
5. Write the formula to find out the value of 5 .
4
B. 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
C. Long answer type questions.
1. What is Formula? Explain the different types of formula used in OpenOffice Calc.
2. What is the significance of Cell Referencing? Explain the different types of cell referencing used in
OpenOffice Calc.
234 Touchpad Computer Applications (Ver. 2.0)-IX

