Page 318 - IT_V1.0_Class10
P. 318
Viva Voce Questions
1. Which feature enables us to build an automated table of contents from the
21 st
headings present in our document? Century #Communication
Skills
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 ‘Track Changes’ feature?
Ans. ‘Track Changes’ feature is used to track every edited cell by highlighting with a coloured border.
4. What is a systematically arranged collection of data, which can be viewed as a repository of information,
called?
Ans. Database
5. Define Table.
Ans. Table is a collection of organised data in the form of rows and columns, and it is used to represent the
relations.
6. Define cropping.
Ans. Cropping typically refers to the process of removing unwanted outer areas from an image or a
photograph to improve framing, composition, or focus on the main subject.
7. How template eases the work of a user?
Ans. Templates provide a predefined structure or format, ensuring consistency across documents or projects.
This consistency makes it easier to create new documents without having to redesign or format them
from scratch each time.
8. What is the purpose of a Table of Contents (TOC) in a document?
Ans. A Table of Contents (TOC) outlining the structure and organisation of a document. It helps them navigate
through the content efficiently and understand the document’s layout without having to read through
it sequentially.
9. Which command is used to automatically create groups and apply inbuilt functions like SUM, COUNT,
AVERAGE, etc. to summarise data in Calc?
Ans. Subtotal
10. Define Macro.
Ans. Macros are the set of stored functions that can be used to automate processes that are repeated often.
11. What is a collection of multiple data stored in related fields that can be treated as a single unit called?
Ans. Record
12. What is goal seek?
Ans. Goal Seek is used to find a specific input value that produces a desired result
13. Define solver.
Ans. A solver is used to optimise a target variable by adjusting multiple input variables under defined
constraints.
14. Name one fire safety equipment.
Ans. Smoke Alarms
316 Information Technology Play (Ver 1.0)-X

