DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Data can be consolidated from different workbooks in one worksheet.
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Expert-Verified Answer. It is false that data can be consolidated from two sheets only.
Detailed explanation-2: -On the Data tab, under Tools, click Consolidate. In the Function box, click the function that you want Excel to use to consolidate the data. In each source sheet, select your data, and then click Add. The file path is entered in All references.
Detailed explanation-3: -Excel has a built-in tool for consolidating multiple worksheets or multiple workbooks. If you need to total various worksheets that might have differing rows or columns, the Consolidate command uses the labels in the first row and first column to line up the data and combine it onto one worksheet.
There is 1 question to complete.