Question

select the correct option:-
1. It collates the data from different ranges and places it in a worksheet.
a) Consolidate
b) Combining
c) Subtotals
2. It generates a subtotal to summarise the data.
a) Define range
b) Total
c) Subtotals
3. Which tab holds the 'What-If Analysis' option?
a) Analysis
b) Data Tools
c) Developer
4. It is the elaborate form of Goal Seek.
a) Detective
b) Solver
c) Scenario
5. It is used to set a goal to find the optimum value for one or target more variables.
a) Scenario
b) Goal Seek
c) Detective

CLASS-10th ON IT,
IT MEANS - COMPUTER


​

Answer 1

Answer:

1 . consolidate

2 . Subtotals

3 . Data Tab

4 . Not have the answer sorry

5 . Goal Seek

mark me brilliant please this all answers are correct