Page 286 - TP_IT_V1.0_C10_flipbpookl
P. 286
Assertion and Reasoning Questions:
Direction: Questions 3-4, consist of two statements – Assertion (A) and Reasoning (R). Answer these questions by selecting
the appropriate option given below:
a. Both A and R are true and R is the correct explanation of A.
b. Both A and R are true but R is not the correct explanation of A.
c. A is true but R is false.
d. A is false but R is true.
3. Assertion (A): One-input What-If analysis allows you to examine how changes in a single input variable impact the outcome
of a formula.
Reasoning (R): Two-input What-If analysis extends this concept to explore the effects of changes in two input variables on
the outcome.
4. Assertion (A): Linking the sheets is done to access data present in different sheets of the same spreadsheet or in different
spreadsheets.
Reasoning (R): Hyperlink is a feature that allows you to jump to a different location from within a spreadsheet.
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
5. Statement 1: Storing a spreadsheet in a network location allows multiple users to edit it simultaneously.
Statement 2: Sharing a spreadsheet with others is not necessary for collaborative work.
Ans. 3. a 4. c 5. c
Unsolved
SECTION A (Objective Type Questions)
A. Choose the correct option.
1. To the comment, hover the mouse pointer over the cell that has the comment.
a. Edit b. View
c. Hide d. None
2. You can save time by saving the repeated commands as .
a. Scenario b. Goal Seek
c. Macros d. Subtotal
3. tab in the Manage Changes dialog box is used to specify the filter criteria.
a. Tools b. Data
c. Filter d. Criteria
4. In spreadsheet, to apply Goal Seek your cell pointer must be in .
a. The Changing cell whose value you need to find b. The Result Cell where formula is entered
c. The cell where your targeted value is entered d. The active cell with no value
5. Which of the following tools deals with multiple unknown values?
a. Goal Seek b. Scenario
c. Solver d. Subtotal
6. Which of the following options is not present in the Hyperlink dialog box?
a. Internet b. Mail & News
c. Document d. Video
284 Trackpad Information Technology (Ver. 1.0)-X

