Page 291 - TP_IT_V1.0_C10_flipbpookl
P. 291

26.  In Spreadsheets,
                       Statement I: To consolidate by row labels or column labels, the label must be contained in the selected source ranges.
                       Statement II: The text in the labels must be identical, so that rows or columns can be accurately matched.
                       Statement III: If the row or column label does not match any that exist in the target range, it will be appended as a new row
                       or column.
                       Consider the above three statements, identify the correct one.                               [2022]
                       a. Only Statements I and II are correct           b. Only Statements II and III are correct
                       c. Only Statement II is correct                   d. All the Statements are correct
                   27.   Statement I: The data from the consolidation ranges and target range are saved when you save the worksheet.
                       Statement II:  If you later open a worksheet in which consolidation has been defined, this data will not be available again.
                       Consider above two statements, identify the correct one.                                     [2022]
                       a. Statement I is wrong                           b. Statement II is wrong
                       c. Both the Statements I and II are wrong         d. Both the Statements I and II are correct
                   28.  Rohan has 50,000 that he wants to invest in two mutual funds for one year. Fund A is a low risk fund with 18% interest
                       rate and Fund B is a higher risk fund with 21% interest rate. Which feature of spreadsheets (Calc) will be help him to
                       decide                                                                                       [2022]
                       a. Solver                                         b. Subtotal
                       c. Linking sheets                                 d. Macros
                   29.               is one of the functions available in the spreadsheet to perform addition of selected numbers in
                       the sheet.                                                                                   [2020]
                   30.  Autosum automatically selects the values around the cells either    or            .         [2020]
                   31.  Given the following Spreadsheet, write the appropriate Formula/Expression/Function to be used for (a) to (e):   [2020]


















                       a. Write the formula to calculate the Total sales of North Zone.
                       b. Write the feature used for arranging the Sales from Lowest to the Highest.
                       c. To find the Maximum Sales in East Zone.
                       d. To find the Average Sales in Jan-Mar in cell C7.
                       e. To find the difference between the sales in East Zone and West Zone in Apr-Jun.

                   32.  List any two conditions/formats/items that can be used for conditional formatting in a Spreadsheet.   [2020]
                   33.  Print option is available under       menu.                                                 [2019]
                   34.  What do you mean by Freeze in Spreadsheet ?                                                 [2019]
                   35.  Aadya is working on a spreadsheet. Help her with the solutions for the following:           [2018]
                       a. Identify the following symbol/toolbar : Σ
                       b. Renaming a worksheet from sheet1 to Cost Sheet.
                       c. To keep the headings constant/visible even if she scrolls down.







                                                                      Electronic Spreadsheet (Advanced) using LibreOffice Calc  289
   286   287   288   289   290   291   292   293   294   295   296