Page 319 - IT_V1.0_Class10
P. 319

15.  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.
                   16.  Name the feature in spreadsheet that helps to run reverse calculations, sensitivity analysis and scenarios
                      comparison.
                 Ans.  What-If Analysis
                   17.  The Macros option is available under which menu in Calc?
                 Ans.  Tools

                   18.  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.

                   19.  Which operator checks if the value of `a’ is  not greater than the value of `b’. If yes, the condition
                      becomes true.
                 Ans.  ‘!>’
                   20.  How do you save changes to a shared spreadsheet?
                 Ans.  Changes in a shared spreadsheet are automatically saved as users update data or make edits
                   21.  Describe the process of sorting columns using a macro.
                 Ans.  A macro can automate the process of sorting data in columns based on specific criteria.

                   22.  In the LibreOffice Writer ‘Templates’ option is available under which menu?
                 Ans.  File
                   23.  Name the tool to test 'what-if' questions.
                 Ans.  Scenario
                   24.  What is the purpose of adding comments in Calc?
                 Ans.  Calc provides another type of comments which authors and reviewers often use to exchange ideas, ask
                      for suggestions or brainstorming the document.
                   25.  What do you understand by query?
                 Ans.  A query refers to a request for data or information from a database.

                   26.  Differentiate between data and information.
                 Ans.  Data refers to raw facts and figures, such as numbers and text. Information, on the other hand, is
                      processed data that has meaning and context.

                   27.  Define the primary key.
                 Ans.  A primary key is used to uniquely identify each record in a table.
                   28.  What is foreign key?
                 Ans.  A foreign key establishes a relationship between tables. It is a field (or set of fields) in one table that
                      matches the primary key in another table, enforcing referential integrity.
                   29.  Define DBMS.
                 Ans.  A database management system is a software package that controls the creation, maintenance and use
                      of a database.
                   30.  Why do you establish relationships between tables?
                 Ans.  Relationships between tables are established to logically connect related data across different tables.
                      This ensures data integrity, improves data organization, and allows for efficient querying and retrieval
                      of related information.




                                                                                             Viva Voce Questions    317
   314   315   316   317   318   319   320   321   322   323   324