Excel Advanced

Match it! Select the correct answer from the pull down...Good luck!

John has used four different colors to show the different products his company sells. How will John show which color is used with which product?

When creating a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the x-axis?

Which chart type will best represent the percentage of expenses for office supplies, salaries, and travel for a company's total budget?

Which function will result in the total number of entries in the cell range B5 to B14?

Which chart type BEST represents the thousands of hits on multiple websites due to advertising?

Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?

Which chart will best present a comparison of the average family income for three states, with emphasis on the states?

If Jake wants to study the relationship between the daily temperature and the amount of fruit sold during a week, what kind of chart should he used?