Spreadsheet Charts and Advanced Features

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

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

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

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?

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

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

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

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

What function will produce results that indicate whether a student has passed or failed a course by entering the text 'Pass' or 'Fail'