Which feature allows you to gather data from different worksheets into a master worksheet?

• Subtotal

• Goal Seek

• Solver

• Data Consolidation

We can consolidate data by which labels?

• Row Label

• Column Label

• Both a & b

• None of these

Which of the following functions are available in the Consolidate window?

• Max

• Min

• Count

• All of these

If you select this option, then any values modified in the source range are automatically updated in the target range.

• Link to source data

• Link to sheet data

• Link to original data

• Link to source range

Which option is used to name a range of cells?

• Range name

• Cell Range

• Define Range

• Select Range

Subtotals perform which action on data arranged in an array (group of cells)?

• Add

• Average

• Find

• Clear

In Subtotals we can select up to how many groups of arrays?

• 3

• 2

• 4

• Infinite

We can shift from one scenario to another by using which option?

• Navigator

• Data Source

• Data filter

• None of these

Scenarios are a tool to test which type of questions?

• if else

• what else

• what if

• if

Identify the correct sequence for applying Subtotals.

• First open Subtotals window and then select the data where we need to apply subtotals.

• First select data and then open Subtotals window.

• Both of the above are correct

• None of these