This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: C. Select the data table area except the descriptive labels. From the Data Tab, What-If Analysis Tools, select Data Table: The Data Table dialog box will appear. Select the cell that holds the variable you wish to change. Since the variable is in the first row, enter this in the Row Input Cell area: Click OK. The Data Table will be populated with values: Format the results as currency with no decimals: D. Apply conditional formatting to show all options that are above Janes target goal:...
View Full Document
- Winter '11