Page 250 - IT_Play_V1.0 Class9
P. 250
7. How is a decimal value formatted to two decimal places in LibreOffice Calc using Format Cells dialog box?
i. Use the Font tab ii. Use the Number tab iii. Use the Alignment tab iv. Use the Border tab
8. Which of these is NOT a horizontal alignment option?
i. Center ii. Left iii. Top iv. Right
B. Fill in the blanks.
1. In LibreOffice Calc, you can change text alignment using the ................................. menu.
2. The alignment that spaces text evenly across the cell's width is called ..................................
3. Wrap Text Automatically increases the row ................................. to accommodate the text within the column width.
4. To format a cell to display dates in a specific format, select the Numbers tab from the ................................. dialog box.
21 st
C. Assertion and reasoning questions. Century #Critical Thinking
Skills
The following questions consist of two statements – Assertion (A) and Reason (R). Answer these questions 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.
iii. A is true but R is false.
iv. A is false but R is true.
1. Assertion (A): To format a cell to display a date in the format "DD/MM/YYYY," you need to select the "Date"
option in the Numbers tab.
Reason (R): The "Date" option provides various date formats, including "DD/MM/YYYY," which can be applied to
cells to display dates correctly.
2. Assertion (A): Formatting cells to display dates in various formats is a feature available in LibreOffice Calc.
Reason (R): Formatting cells for dates is only possible if you use the "Wrap Text".
21 st
Century #Critical Thinking
D. Statement-based question. Skills
In the following question, two statements are given. Statement 1 and Statement 2. Examine the statements
and mark the correct option:
i. Statement 1 is true , Statement 2 is true
ii. Statement 1 is false , Statement 2 is false
iii. Statement 1 is true , Statement 2 is false
iv. Statement 1 is false , Statement 2 is true
Statement 1: In LibreOffice Calc, the "Fill Handle" can be used to copy formulas across a row or column, extending
the data as required.
Statement 2: To use the Fill Handle, you must manually enter the formula into each cell individually.
Section B (Subjective Type Questions)
A. Answer the following questions:
1. How do you apply the Fill Handle for a number series?
2. What are the uses of the Alignment tab in the Format Cells dialog box?
3. How can you format a spreadsheet cell to hold a date?
4. Explain the steps to copy a formula using the Copy-Paste method.
5. What are the steps to format a cell to hold time? 21 st
Century #Critical Thinking
B. Application-based questions. Skills
1. Tina is preparing a spreadsheet for her monthly expenses. She wants all amounts displayed as currency with two
decimal places. How can Tina format her spreadsheet to achieve this?
2. Ravi is creating a timetable for his school. He wants the text "Science Class" to appear in the centre of a cell both
horizontally and vertically. What steps should Ravi follow to align the text correctly?
248 Information Technology Play (Ver 1.0)-IX

