DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the name of the window used in Excel to insert a calculated column in a table?
|
Power Pivot
|
|
Pivot Power
|
|
Handles
|
|
Word Sauce
|
Explanation:
Detailed explanation-1: -You create calculated columns in Power Pivot in Excel within a table in the data model window to create a column value. You can then summarize that value within the PivotChart or PivotTable in the “Values” section.
Detailed explanation-2: -A calculated column gives you the ability to add new data to a table in your Power Pivot Data Model. Instead of pasting or importing values into the column, you create a Data Analysis Expressions (DAX)formula that defines the column values.
There is 1 question to complete.