Excel Lesson 12 Part 2
Quiz by Lisa DeCastillia
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
18 questions
Show answers
- Q1Ann 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?AxisChart titleLegendData label60s
- Q2Leigh 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?AxisChart titleLegendData label60s
- Q3What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?SliversMoversPartialsSlicers60s
- Q4Joe 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?Legend fieldsValuesReport filterAxis fields60s
- Q5Efram would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create?LineBarColumnPie60s
- Q6Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?LayoutDesignFormatStyle60s
- Q7Jason wants to identify the exact value that each column in his chart represents. Which option should he choose?LabelsPicturesArrowsGridlines60s
- Q8What term refers to an Excel Chart with offset pieces?SeparatedShatteredExplodedDetached60s
- Q9Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart?AnalyzeDesignFormatLayout60s
- Q10Jeff 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?Axis fieldsValuesLegend fieldsReport filter60s
- Q11Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?LayoutDesignFormatStyle60s
- Q12What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?Decrease/IncreaseReduce/AddCollapse/ExpandSubtract/Add60s
- Q13What can you use to easily filter PivotTables and cube functions interactively in a worksheet?SliverSlicerDivisionCutter60s
- Q14What is typically included in the range of data selected to create a chart?Numeric data, totals, and titlesNumeric data and totals onlyNumeric data and titlesTitles only60s
- Q15Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?DesignLayoutFormatAnalyze60s