Page 238 - IT_Play_V1.0 Class9
P. 238
Recap Zone
Text data refers to the data which is a combination of alphabets, spaces, digits and/or other characters.
Numeric data consist of digits (0–9), Exponential (e), decimal (.) and numeric operators like +, -, /, *, %, $.
Date and Time are values and therefore can be added or subtracted and can be included for other
calculations.
A formula is an expression that helps to perform arithmetical calculation and also executes
non-arithmetical tasks.
Cell content can be modified by either replacing or deleting it.
Mathematical operator is a symbol that performs certain mathematical or logical operations.
Functions are in-built formula in LibreOffice Calc that can be used to perform arithmetical and
non-arithmetical tasks.
AUTOSUM is a shortcut tool for adding the values of a range of cells.
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. If you want to display the largest value from a set of cells, which function should you use?
i. MIN() ii. MAX() iii. AVERAGE() iv. COUNT()
2. Which of the following error occurs when there is a problem with a number in a formula or function?
i. ### ii. #VALUE! iii. #NAME? iv. #NUM!
3. What type of data can be entered as "5+8" in a cell?
i. Text ii. Formula iii. Date/Time iv. Numeric
4. Which key is used to paste the copied or cut content in a new cell?
i. Ctrl+C ii. Ctrl+V iii. Ctrl+X iv. Ctrl+Z
5. Which of the following is a valid formula?
i. =B1+B2 ii. =Sum(A1:A5) iii. =A1-A2 iv. All of these
B. State whether the following statements are true or false:
1. The #VALUE! error occurs when a wrong type of argument is used. .......................
2. The AND function returns TRUE if any condition enclosed in the bracket is TRUE, otherwise
it produces FALSE. .......................
3. The ROUND() and MOD() are example of statistical function. .......................
4. The * operator performs division operation. .......................
5. Text data refers to the data that is a combination of alphabets, spaces, digits and/or
other characters. .......................
21 st
C. Assertion and reasoning question. Century #Critical Thinking
Skills
The following question consists of two statements – Assertion (A) and Reason (R). Answer the question by
selecting the appropriate option given below:
i. Both A and R are true and R is the correct explanation of A.
ii. Both A and R are true but R is not the correct explanation of A.
236 Information Technology Play (Ver 1.0)-IX

