USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
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.
Detailed explanation-4: -If you just want to enter same dada in several worksheets in workbook, please click an worksheet tab, hold the Ctrl key, and then click to select other worksheets one by one.