Explain the difference between a “what-if” analysis and Goal Seek by giving an example based on the worksheet shown in Question 11.
Answer to relevant QuestionsList and describe the significance of each of Tufte’s five data graphics principles. What chart sub-types are available for the stock chart in Excel? Explain how you interpret the data markers on each of the sub-types. Explain the difference between the data points in a line chart and an X Y (Scatter) chart. List and describe the four areas of a PivotTable report. Explain how you must vary the setup of a two-variable data table to run a simulation.
Post your question