Microsoft Excel Final Exam Review #1

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

John would like to add a banner at the top of his spreadsheet. Which object should he insert?

Leigh Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include?

Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?

Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create?

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

Ken has inserted a picture into his spreadsheet and would like it to standout with a frame or 3D effect. Which tool would he use to achieve this?

Which command creates decorative text in a worksheet?

Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?