Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/18
Score 0
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?
60
Axis
Chart title
Legend
Data label
Q 2/18
Score 0
Leigh 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?
60
Axis
Chart title
Legend
Data label
18 questions
Q.
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?
1
60 sec
Q.
Leigh 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?
2
60 sec
Q.
What are graphical objects that contain buttons a user can click to filter the data in PivotTables and
PivotCharts?
3
60 sec
Q.
Joe has created a PivotChart 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?
4
60 sec
Q.
Efram would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart
type should he create?
5
60 sec
Q.
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
6
60 sec
Q.
Jason wants to identify the exact value that each column in his chart represents. Which option should he
choose?
7
60 sec
Q.
What term refers to an Excel Chart with offset pieces?
8
60 sec
Q.
Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart?
9
60 sec
Q.
Jeff would like to display the count of employee last names on the Y-axis of a PivotChart. What area would he drag this information to in order to display correctly?
10
60 sec
Q.
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
11
60 sec
Q.
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
12
60 sec
Q.
What can you use to easily filter PivotTables and cube functions interactively in a worksheet?
13
60 sec
Q.
What is typically included in the range of data selected to create a chart?
14
60 sec
Q.
Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
15
60 sec
Q.
John wants to change the chart style on his PivotTable. Which PivotTable chart tools tab would he create?
16
60 sec
Q.
What ribbon contains the commands for creating charts in Microsoft Excel?
17
60 sec
Q.
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?
