FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Selecting the Bottom Row check box when consolidating data will give you all the columns of data instead of summarizing the data.
A
True
B
False
C
X
D
X
Explanation: 

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.

There is 1 question to complete.