A. Select the correct option.
SECTION 1: OBJECTIVE TYPE QUESTIONS (SOLVED)
1. Which of the following feature of Excel will you use to collate the data of several worksheets into a m
worksheet?
he
a. Subtotal
b. Consolidate
c. Data Provider
2. Which step should you follow before using the Subtotal command?
a. Consolidate data
b. Sort data
c. Filter data
3. Which tab has the Subtotal command in Excel?
a. Tools
b. Sheet
c. Data
4.
Which of the following is performed to achieve the goal as per the target value?
a. Goal Seek
b. Subtotal
c. None of these
5. Which is the best tool if you have a problem with the multiple unknown variables?
a. Goal Seek
b. Scenario
c. Solver
6. In Excel, which of these is used to perform the What-If analysis?
a. Scenario
b. Goal Seek
c. Both a and b
Answers
Answered by
1
Answer:
hi the answer is in explanation
Explanation:
1.A
2.A
3.C
4.B
5.C
6.C
Similar questions