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

