Excel creating a basic dashboard Chapter 1 1) You want to create a PivotTable of your own. What is the next step after selecting any cell inside the table you are using? Select PivotTable on the Insert tab This is the action you would take to begin creating your own type of PivotTable. 2) Lee-Jin created a conditional format based on a formula. What is the advantage of using a formula-based conditional format? Lee-Jin can update the rule by changing values in cells the formula references When using a formula-based value and the target is edited, the conditional format updated automatically 3) Miguel wants to modify his PivotTable to include currency. Which action allows him to do this in the PivotTable? Change the format applied to the data field This action enables Miguel to chan
