IT 402 CBSE Class 10 Unit 2 Electronic Spreadsheet

__________ allows you to gather data from different worksheets into a master worksheet.

• Goal Seek

• Solver

• Data Consolidation

• Total Data

Consolidate option is available under __________ menu.

• Tool

• Insert

• Data

• View

We can consolidate data by ___________

• Row Label

• Column Label

• Both Row and Column Label

• None of them

Which of the following functions are available in consolidate window?

• Max

• Sum

• Count

• All of the above

If you select ________ 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

Data can be consolidated from two sheets only (True / False).

• True

• False

Which option is used to name a range of cells?

• Range name

• Cell Range

• Define Range

• Select Range

Define range option is available under _________ menu.

• Insert

• View

• Data

• File

SUBTOTALS ________ data arranged in an array (a group of cells)

• ADD

• CLEAR

• MIN

• AVERAGE

SUBTOTAL is available in ________ menu.

• Tools

• Format

• Insert

• Data