DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
We can define relationships between data tables.
|
|
|
Lookup definitions
|
|
|
Manage multiple worksheets
|
|
|
None of the above
|
Detailed explanation-1: -Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.
Detailed explanation-2: -With Power Pivot, users can pull in large volumes of data from multiple sources and easily create relationships between them. Power Pivot uses the DAX formula language, allowing users to make use of variables and powerful context manipulation.
Detailed explanation-3: -Pivot charts let you rapidly analyze large amounts of unsummarized data in different ways. Unlike normal charts, Pivot charts can be used to plot data with hundreds or thousands of rows.
Detailed explanation-4: -Advantages of Using Pivot Tables Pivot tables allow you to see how your data works – Pivot tables are one of the many tools out there that can help users get deeper insights into their data. You can create multiple reports on multiple data sets from a single pool of data.