You are setting the rules for the use of an icon set based on specific values. What should you remember to do first? Select an answer: When defining an icon set's conditional format, always change the Value first, so Excel wall present the correct Types. When defining an icon set's conditional format, always choose your lcons first, because they need to match your Type. When defining an icon set's condaional format, always change the Type first, because it changes the comparison value back to zero. When defining an icon set's conditional format, always change the Type first, because it changes the value to the highiest value in the table. Which PivotTable area includes the detailed data that makes up the PivorTable? Select an answer: To define a conditional format using the comparison rule >=58808, go to the Home tab of the ribbor, click Conditional Formatting, and then click from the button list that appears. Select an answer: You are creating a table of data with 30 rows, but you do not have a header row. Which step should you take to have Excel define a header for the table? Select an answer: Check the checkbox for headers in the Format As Table dialog box. Right-click the Excel row where you want to include the header. Indra is creating a link to a PivotTable cell. She selects a cell in worksheet1. What is the next action she should take to initiate the formula as she chooses which value in the PivotTable to use? Select an answer: She needs to go to the worksheet with the PivotTable. You can use a filter to display just the highest or lowest values in a data set. Select an answer: You can include summary formulas as part of an Excel table by displaying the Select an answer: You decide your dashboard design looks better with worksheet gridlines turned off. On which ribbon tab can you find the check box to make this change? Select an answer: You want to create a rule-based filter to view all values that are greater than or equal to 50,000 . Is this possible? Select an answer: No, there is only a Value Filter for Greater Than. You will need to manually solect values equal to 50,000 to ween them in view. Drew wants to take a course to learn how to create a dashboard in Excel. What is the least likely skill she neods to know before doing so? Izzabella is constrained in the amount of space she has in her dashboard worksheet, but needs to show visual summaries of data. How can she accomplish this effectively? Select an answer: How can you add fields to a PivotTable? Select an answer: Display the PivotTable Fields task pane and dragf fields to one of the PivotTable areas