Page 32 - Touchpad_Plus_V3.2_Class 7
P. 32
B. Fill in the blanks using the words given below:
Hints
functions, equal, dollar ($), square root, column
1. ...................... are predefined formulas in LibreOffice Calc.
2. Formulas in LibreOffice Calc begin with an ...................... sign.
3. The SQRT function returns the ...................... of the given number.
4. The ...................... chart usually displays the data in the form of vertical bars.
5. In Mixed Referencing, you can lock either a column or a row by preceding it with a
...................... symbol.
C. Write ‘T’ for true and ‘F’ for false.
1. Calc calculates expressions within parentheses first. ..........................
2. Legend is a key which shows the meanings of symbols and colours used in the chart. ..........................
3. Combined reference is a type of cell reference. ..........................
4. We cannot create Bar chart in Calc. ..........................
5. Calc calculates consecutive operators with the same level of precedence from
right to left. ..........................
D. Match the columns.
Column A Column B
1. Area chart a. Trends over period of time
2. Pie chart b. Quantitative magnitude of data
3. Bar chart c. Sector showing relative size of each value
4. Line chart d. Long rectangular rods to represent data
E. Short answer type questions.
1. What is cell reference?
.....................................................................................................................................................................................
2. What is category axis in a chart?
.....................................................................................................................................................................................
3. Define Legend.
.....................................................................................................................................................................................
4. What is the use of the LEN function?
.....................................................................................................................................................................................
30 Plus (Ver. 3.2)-VII

