DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You can consolidate data only form the different worksheets of the active workbook
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Combine by category Open each source sheet. In your destination sheet, click the upper-left cell of the area where you want the consolidated data to appear. Note: Make sure that you leave enough cells to the right and underneath for your consolidated data. On the Data tab, in the Data Tools group, click Consolidate.
Detailed explanation-2: -Linking is the process of using references to cells in external workbooks to get data into your worksheet. Consolidating involves combining or summarizing information from two or more worksheets (which can be in multiple workbooks).
There is 1 question to complete.