IT - CH. 4

Name of the student:

Class & Section:

Divya wants to prepare a master sheet with a combination of data from another 3 worksheets. Which of the following feature is useful for her?

• Data Table
• Data Consolidate
• Link worksheets
• Cell Referencing

The consolidate option is available under __________ menu.

• File
• Insert
• Tools
• Data

The difference between Consolidation ranges and Source data ranges are A: Consolidation ranges are selected from source ranges only B: Source data ranges are actual ranges from the data worksheet.

• A is correct and B is not correct
• B is correct and A is not correct
• A and B both are correct
• A and B both are incorrect

To make the modification automatically in the consolidated (target) sheet while making any changes in the source data, the _______________option needs to be checked.

• Modify Source Data
• Hyperlink to Source Data
• Connecting to Source Data
• Link to Source Data

The copy results to option are

• the cell references where the result is going to be displayed
• the absolute cell references
• the relative cell references
• the cell references to be used for formula

Which of the following function is set as by default in data consolidation?

• count
• sum
• max
• min

The keyboard shortcut for data>consolidation is?

• Ctrl+D
• Alt+D
• Ctrl+C
• Alt+C

You need to check the following before consolidating data. Option A• Open each sheet in the spreadsheet and check that the data types must match which you want to consolidate. Option B• Match the labels from all the sheets which are used for consolidating. Option C• Enter the first column as the primary column on the basis of which data is consolidate

• Option A
• Option B
• Option C
• All of these