MS Excel Honors #6

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

Which is a prewritten formula that is built into Microsoft Excel?

Angie is calculating her average sales for the past four months. If she uses =AVERAGE(B1:B4), this is an example of which type of entry?

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?

Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?

Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?

Which group on the Formulas tab enables a user to specify when a formula is computed?

John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create?

Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?