USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
X
|
|
|
X
|
Detailed explanation-1: -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-2: -To summarize and report results from separate worksheets, you can consolidate data from each sheet into a master worksheet. The sheets can be in the same workbook as the master worksheet, or in other workbooks. When you consolidate data, you assemble data so that you can more easily update and aggregate as necessary.
Detailed explanation-3: -Consolidate by position: Used when data in all the worksheets is arranged in exactly the same order and location. Consolidate by category: Used when the worksheets have the same row and column labels, but the rows and columns aren’t arranged in the same order on all the worksheets.