What ribbon contains the commands used to create a chart in Excel?
Insert Ribbon
100
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
Design
100
John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create?
Line Chart
100
Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature should she modify?
Plot Area
100
What term refers to an Excel Chart with offset pieces?
Exploded
200
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
Screenshot
200
What ribbon contains the commands used to create a chart in Excel?
Insert Ribbon
200
Which is a tiny chart that provides a visual representation of data in a worksheet cell?
Sparkline
200
Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include?
Gridlines
200
What is typically included in the range of data selected to create a chart?
Numeric data and titles
300
Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
Screen Clipping
300
John wants to identify the exact value that each column in his chart represents. Which option should he choose?
Labels
300
What graphically represents trends in plotted data and predicts future values?
Trendline
300
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?
Chart Title
300
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
Rotate
400
Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
Clip Art
400
John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?
Legend Fields
400
What is a visual way to show how two variables relate to each other in a table?
Trendline
400
Which Chart Tools Ribbon tab allows a user to insert various labels on the chart
Layout
400
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?
Embedded Chart
500
What is the main function of the Insert Ribbon?
To insert various things into an excel document.
500
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?
Legend
500
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create?
Column
500
Which command creates decorative text in a worksheet?
Word Art
500
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?