Page 336 - TP_IT_V1.0_C9_flipbpookl
P. 336

c.  Write the formula in F2 to find the average marks scored by Arshia.
                     d.  Copy the formula entered in F2 for other students.
                     e.  Write the formula in cell B7 to find the highest score in Hindi.
                     f.  Write the formula to find the highest score in English and Maths in C7 and D7 respectively.
                     g.  Write the formula in cell B8 to find the total number of students who appeared in Hindi.
                     h.  Write the formula in cell B9 to find the lowest score in Hindi.
                     i.  Write the formula to find the lowest score in English and Maths in C9 and D9 respectively.
                 3.  Consider a mathematical function, such as Y=3*X+1. Calculate the value of Y for each value of X, as given in the table below.
                            Value of X   2            4            6             8            10
                            Value of Y   ?            ?            ?             ?            ?
                     Perform the given tasks:
                     a.  Enter these values in Calc spreadsheet.
                     b.  Use formula to find out the values of Y for each value of X.
                     c.  Plot a line chart of X and Y values together.
                 4.  Collect the electricity bill of your home for each month from January to May. Create a spreadsheet with the data of Month
                    Name and Bill Amount as below.
                      MONTH                                        BILL AMOUNT
                      JANUARY                                      ?
                      FEBRUARY
                      MARCH
                      APRIL
                      MAY

                    Enter the data in a spreadsheet and plot any three charts. Also find out that which type of chart will be more appropriate
                    for such type of data.

                    Assertion and Reasoning Based Questions:
                    Direction: Questions 5-6, consist of two statements – Assertion (A) and Reasoning (R). Answer these questions by selecting
                    the appropriate option given below:
                     a.  Both A and R are true and R is the correct explanation of A.
                     b.  Both A and R are true but R is not the correct explanation of A.
                     c.  A is true but R is false.
                     d.  A is false but R is true.
                 5.  Assertion (A): Absolute cell references in LibreOffice Calc are useful when you want a formula to always refer to a specific
                    cell, regardless of where the formula is copied.
                       Reason (R): Absolute cell references are indicated by adding a dollar sign ($) before the column letter and row number
                    (e.g., $A$1).
                 6.  Assertion (A): Line charts in LibreOffice Calc are used to show trends over time or for continuous data.
                     Reason  (R): Line  charts and pie  charts serve different purposes; one is  more effective than  the other for displaying
                    proportions of a whole.
                    Statement Based Questions:
                     Two statements are given. Statement 1 and Statement 2. Examine the statements and answer the question according to
                    the instructions given below:
                     a.  Statement 1 is True, Statement 2 is True
                     b.  Statement 1 is False, Statement 2 is False
                     c.  Statement 1 is True, Statement 2 is False
                     d.  Statement 1 is False, Statement 2 is True
                  7.  Statement 1: Autofill in LibreOffice Calc allows you to quickly fill cells with data based on a pattern or series.
                    Statement 2: Autofill in LibreOffice Calc can be used to extend a series of dates or numbers automatically.





                334   Trackpad Information Technology (Ver. 1.0)-IX
   331   332   333   334   335   336   337   338   339   340   341