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
   245   246   247   248   249   250   251   252   253   254   255