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: -Step 1: Open all files (workbooks) that contain the data you want to consolidate. Step 2: Ensure the data is organized in the same way (see example below). Step 3: On the Data ribbons, select Data Tools and then Consolidate. Step 4: Select the method of consolidation (in our example, it’s Sum).
Detailed explanation-2: -The correct answer is “Pivot Table". Key PointsPivot Table: We can use pivot tables to sort, reorganize, group, count, total or average data stored in a database. They are the perfect solution when you need to summarize and analyze large amounts of information.
Detailed explanation-3: -This can be done using the (Data > Consolidate) dialog box. You can use (Data > Consolidate) to combine the corresponding values in up to 255 different worksheets into a single worksheet.