Spreadsheet Charts

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

• Exploded Pie
• Line
• Pie
• XY Scatter

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

• Columns
• Line
• Pie
• Scatter

Hal has used four different colors to show the different products that his company sells. What will Hal use to explain the different product colors?

• X axis 
• Y axis
• Legend
• Chart Title

Amanda has created multiple charts for each product sold. How will her manager know the name of each chart?

• X axis
• Y axis 
• Legend
• Chart Title

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

• Column
• Line
• Pie
• Bar

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 use?

• Column
• Line
• Pie
• Bar

Which function can an accounting department use in Cell A2 that will result in the current date?

• Count
• Count A
• Days 360
• Now

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

• Column
• Line
• Pie
• Bar

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

• Months
• Oil Prices
• Stock Names
• Stock Prices

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

• Count
• Max
• MIn
• Sum