Select the correct option. (advanced electronic spreadsheet) 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 more target variables.
a. Scenario
b. Goal Seek
c. Detective