Page 429 - TP_IT_V1.0_C10_flipbpookl
P. 429

Viva Voce Questions










                   1.  Which feature enables us to build an automated table of contents from the headings present in our document?
                  Ans.  Table of Contents
                   2.  What is data consolidation?

                  Ans.  Data  consolidation  refers  to  collecting  and  integrating  data  from  multiple  worksheets  or  workbooks  into  a
                      single/master worksheet.

                   3.  What is the use of ‘Record’ feature in LibreOffice Calc?
                  Ans.  ‘Record’ feature is used to track every edited cell by highlighting with a coloured border.
                   4.  What is an organised collection of data that can be visualised as a container of information called?
                  Ans.  Database

                   5.  Which command is used to automatically create groups and apply inbuilt functions like SUM, COUNT, AVERAGE,
                      etc. to summarise data in Calc?
                  Ans.  Subtotal
                   6.  Define Macro.
                  Ans.  Macros are the set of stored functions that can be used to automate processes that are repeated often.
                   7.  What is a collection of multiple data stored in related fields that can be treated as a single unit called?

                  Ans.  Record
                   8.  Which data type stores year, month, day, hour, minute, and second values?
                  Ans.  Timestamp
                   9.  Name any one Fire Safety Equipment.

                  Ans.  Smoke Alarms
                   10.  Define Template.
                  Ans.  A  template  is  a  document  that  contains  pre-defined  formatting  styles,  graphics,  tables,  objects,  and  other
                      information that are commonly used in a particular pattern.
                   11.  Name  the  feature  in  spreadsheet  that  helps  to  run  reverse  calculations,  sensitivity  analysis  and  scenarios
                      comparison.
                  Ans.  What-If Analysis
                   12.  Under which menu in Calc is Macros available?

                  Ans.  Tools
                   13.  Define Styles.
                  Ans.  A Style is a set of pre-defined formatting options that can be applied in a Word Processor document of LibreOffice
                      Writer or MS Word.
                   14.  Which operator checks if value of ‘a’ is not greater than value of ‘b’. If yes, condition becomes true.

                  Ans.  ‘!>’




                                                                                                       Practical Work
                                                                                                 Viva Voce Questions   427
   424   425   426   427   428   429   430   431   432   433   434