DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A table containing data that is organized horizontally.
|
|
|
A table used to calculate financial pivot values.
|
|
|
A tool used to summarize data.
|
|
|
A table containing only black, grey and white formatting.
|
Detailed explanation-1: -A PivotTable is an interactive way to quickly summarize large amounts of data. You can use a PivotTable to analyze numerical data in detail, and answer unanticipated questions about your data. A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways.
Detailed explanation-2: -A pivot table is a data summarization tool that is used in the context of data processing. Pivot tables are used to summarize, sort, reorganize, group, count, total or average data stored in a database. It allows its users to transform columns into rows and rows into columns.
Detailed explanation-3: -As you can see, Pivot Table is a powerful tool that can get the analysis done the fastest! As you learn more about the Pivot Tables, you’ll realize that they can be used to summarize data from a single worksheet or multiple worksheets.
Detailed explanation-4: -A table which horizontally-organised data points. A table used to compute financial pivot values.