Page 289 - TP_IT_V1.0_C10_flipbpookl
P. 289
8. Assertion (A): Two-input What-If analysis allows you to examine the effects of changes in two input variables on the
outcome of a formula or calculation.
Reasoning (R): You set up a grid of cells containing different combinations of values for the two input variables and
observe how changes in both variables simultaneously affect the result of the formula.
Statement Based Questions:
Two statements are given. Statement 1 and Statement 2. Examine the statements and answer the question according to the
instructions given below.
a. Statement 1 is TRUE, Statement 2 is TRUE
b. Statement 1 is FALSE, Statement 2 is False
c. Statement 1 is TRUE, Statement 2 is False
d. Statement 1 is FALSE, Statement 2 is TRUE
9. Statement 1: Comments in spreadsheets are solely for decoration and have no practical purpose.
Statement 2: Comments can be used to explain specific formulas or data points for better understanding.
Previous Years' Questions
1. While consolidating data, a cell range can be named using option. [2024]
a. Name range b. Consolidate name
c. Define range d. Define name
2. Kawal and his friends are working on a Spreadsheet for entering data and updating records. They wish to keep a track of
changes. Which of the following options will help in knowing who made the changes and what changes were done in the
spreadsheet? [2024]
a. View changes b. Record changes
c. Store changes d. Track changes
3. is a more elaborate form of Goal Seek. [2024]
a. Database b. Hyperlink
c. Report d. Solver
4. Macro functions can be written to behave as regular functions by writing a/an . [2024]
a. Void b. Return
c. Add-In d. Dim
5. option of Calc helps in viewing the changes made to a worksheet using original and edited
worksheet. [2024]
a. Edit→Revise document b. Edit→Consolidate
c. Edit→Compare document d. Edit→Collaborate document
6. In Calc, shared workbooks allow: [2024]
a. Merging cells b. Conditional formatting
c. Inserting pictures/graphs d. Adding text
7. What is the purpose of consolidating data in spreadsheets ? Discuss briefly. [2024]
8. What are the two parts of a cell reference while referencing data on other sheets ? Explain with an example. [2024]
9. Explain four types of hyperlinks that can be applied in spreadsheets. [2024]
10. A statistical formula can be applied to a selected array of cells using . [2023]
a. Consolidate b. Goal seek
c. Subtotal d. Autosum
11. Which of the following term refers to a cell or range of cells that can be used in a formula? [2023]
a. Cell Reference b. Cell Formula
c. Formula Reference d. Linked Cells
Electronic Spreadsheet (Advanced) using LibreOffice Calc 287

