Exercise 1.4-1 Chapter Review – Creating Charts



Exercise 1.4-1 Chapter Review – Creating ChartsWhat type of chart would best display the current values of each of the stocks in your portfolio?Bar or ColumnIf you were to configure the chart you’ve selected in question one, what range would you use on your chart such that it would include the stock name and value?A2:A7;G2:G7If you were to configure the chart you’ve selected in question one, which would you use for the x-axis values – values along rows or columns?RowsWhat type of chart would best display the relative proportions of each of these stocks in your portfolio based on their current values?PieYou have downloaded the historical prices (date and price) of Microsoft stock over the past five years onto a separate worksheet. What type of chart would best display the trend of price fluctuations for this data?LineYour buddy (Mr. Get Rich Quick) swears that there is a relationship between the daily temperature and whether or not Microsoft’s stock price goes up or down. So to prove him wrong you have input the temperature in New York for each of the dates corresponding to the prices you downloaded. What type of chart would best show this functional dependency between temperature and price?Scatter ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download