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

