Page 442 - TP_IT_V1.0_C10_flipbpookl
P. 442

Q2.  Answer any 5 out of the given 6 questions                                             (1 x 5 = 5 marks)
                   i.  What is a style in LibreOffice Writer?
                      a.  A method of typing                      b.  A collection of all formatting information
                      c.  A tool for drawing shapes               d.  A spell-check feature
                   ii.  Which of the following is an example for absolute cell referencing?
                      a.  C5              b.  $C$5                 c.  $C                  d.  #C
                  iii.  Which of the following tabs is by default active when the Table of Contents, Entries or Bibliography dialog box is opened?
                      a.  Entries         b.  Background           c.  Styles              d.  Type
                  iv.  Which of the following is true about Track Changes feature of Writer?
                      a.  You cannot record a change made in the document.
                      b.  A comment of a particular author only can be deleted
                      c.  Any change made to the document is permanent.
                      d.  None of the above
                   v.   Imagine you are a financial analyst tasked with analyzing quarterly sales data for a multinational corporation. The data
                      is stored in separate sheets within an Excel workbook, each representing sales figures from different regions (e.g., North
                      Zone, East Zone, South Zone). How can you efficiently view and compare quarterly sales data from multiple regions
                      in a single spreadsheet to identify trends and relationships?
                      a.  By creating separate charts for each region’s data.
                      b.  By using the Consolidate function to combine information from all regional sheets into one summary sheet.
                      c.  By manually copying and pasting data from each region’s sheet into a new sheet.
                      d.  By deleting unnecessary data from each region’s sheet.
                  vi.  Sore lower back is caused due to.
                      a.  reaching forward frequently             b.  no lumbar support
                      c.  no upper back support from chair        d.  reaching forward for long periods
              Q3.  Answer any 5 out of the given 6 questions                                             (1 x 5 = 5 marks)

                   i.  What is the extension of spreadsheet file in Calc?
                      a.  .odb            b.  .odt                 c.  .odg                d.  .ods

                   ii.  Which of the following is the shortcut key to open the Templates dialog box?
                      a.  Ctrl+Alt+N      b.  Ctrl+Shift+N         c.  Ctrl+Alt+T          d.  Shift+Alt+T

                  iii.  Which style category would you use to format a section containing text, graphics, and lists?
                      a.  Page Style      b.  Paragraph Style      c.  Character Style     d.  Frame Style

                  iv.   It is a reference point for the graphics which is created while positioning any image. This point could be the page, or
                      frame where the object is either a paragraph, or even a character in a word processor.
                      a.  Wrap Text       b.  Anchoring            c.  Alignment           d.  BookMark
                   v.  Which of the following is an invalid Macro Name?
                      a.  1formatword     b.  format word          c.  format*word         d.  Format_word
                  vi.  A fresh food cafeteria helps to maintain the of the employee.
                      a.  Health          b.  Morale               c.  Productivity        d.  Engagement

              Q4.  Answer any 5 out of the given 6 questions                                             (1 x 5 = 5 marks)
                   i.   Which  of  the  following  feature  is  used  to  jump  to  a  different  spreadsheet  from  the  current  spreadsheet  in
                      LibreOffice Calc?
                      a.  Macro           b.  Hyperlink            c.  connect             d.  Copy

                   ii.  Which of the following operations cannot be performed using LibreOffice Calc?
                      a.  Store and manipulate data               b.  Create graphical representation of data
                      c.  Analysis of data                        d.  Mail merge



                440   Trackpad Information Technology (Ver. 1.0)-X
   437   438   439   440   441   442   443   444