Melanie Wants to Change the Default PivotTable Style for a Workbook.She

question 19

Multiple Choice

Melanie wants to change the default PivotTable Style for a workbook.She selects a cell in a Pivot Table,then clicks a certain tab on the Ribbon,under the PivotTable Tools tab.Then she right-clicks the style she wants to set as the default In the PivotTable Style gallery and finally clicks on Set As Default in the context menu.What is the tab Melanie clicks during this procedure?

• A) Data tab
• B) Home tab
• C) Insert tab
• D) Design tab

---

Definitions:

Present Value

The worth as of today of a future money sum or cash flow series, taking into consideration a specific rate of return.

Present Values

This is a concept in finance that calculates the current worth of a future sum of money or stream of cash flows given a specified rate of return.

Discount Rate

This rate is applied in the framework of DCF analysis for the purpose of calculating the current value of foreseeable cash flows.

Compounded Annually

Compounded annually refers to the calculation and addition of interest to the principal sum of a loan or deposit once every year.