DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Groups
|
|
|
Set
|
|
|
Form
|
|
|
None of the above
|
Detailed explanation-1: -Click the Data tab on the ribbon. Click the Consolidate Data button in the Data Tools group. The Consolidate dialog box appears. Here you can choose what you want to do with the data, like find the sum, count, or average.
Detailed explanation-2: -What is Excel Consolidate? 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: -On the Data tab, in the Outline group, click Group. Then in the Group dialog box, click Rows, and then click OK. Tip: If you select entire rows instead of just the cells, Excel automatically groups by row-the Group dialog box doesn’t even open. The outline symbols appear beside the group on the screen.
Detailed explanation-4: -A ribbon is a command bar that organizes a program’s features into a series of tabs at the top of a window.