USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Sum
|
|
|
Average
|
|
|
Product
|
|
|
Dividend
|
Detailed explanation-1: -Option (d): All of the above functions are available in the consolidate window. Explanation: If you have a collection of tables (or lists), you can merge (or consolidate) all of the data into a single table (or list). The (Data > Consolidate) dialogue box can be used for this.
Detailed explanation-2: -The Consolidate Function[1] in Excel allows an analyst to combine information from multiple workbooks into one place. The Excel consolidate function lets you select data from its various locations and creates a table to summarize the information for you.
Detailed explanation-3: -Consolidate is an inbuilt function in Excel used to consolidate data from different workbooks opened simultaneously. This function is present in the “Data” tab. It allows us to select multiple data from other workbooks and consolidate them in a final workbook.
Detailed explanation-4: -In the Consolidate dialog box, you can select the cells you want to consolidate; or, if you named the ranges, you can enter the range names.