DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Pivot Tables
|
|
|
Summary Tables
|
|
|
Worksheet Tables
|
|
|
Management Tables
|
Detailed explanation-1: -Pivot Tables can help make your worksheets more manageable by summarizing data and allowing you to manipulate it in different ways.
Detailed explanation-2: -Introduction. When you have a lot of data, it can sometimes be difficult to analyze all of the information in your worksheet. PivotTables can help make your worksheets more manageable by summarizing your data and allowing you to manipulate it in different ways. Optional: Download our practice workbook.
Detailed explanation-3: -As Microsoft defines it, a pivot table is “a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.” A pivot table provides summarization and analysis capabilities by applying formulas and functions to the contents of a database.
Detailed explanation-4: -A pivot table is a statistics tool that summarizes and reorganizes selected columns and rows of data in a spreadsheet or database table to obtain a desired report.