French Fries
Pizza
Tacos
Fried Chicken
Steak
100
John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create? NCCTE.9_12.BE.BM20.1.12 RBT: A. PivotChart B. Line chart C. Embedded chart D. Linked chart
What is B Line Chart
100
John would like to add a banner at the top of his spreadsheet. Which object should he insert? NCCTE.9_12.BE.BM20.1.13 RBT: A. Shapes B. Picture C. SmartArt D. Screenshot
What is A Shapes
100
Which of the following is the default method for summarizing data in a PivotTable? NCCTE.9_12.BE.BM20.1.12 RBT: A. Count B. Average C. Max D. Sum
What is D Sum
100
Which command creates decorative text in a worksheet? NCCTE.9_12.BE.BM20.1.13 RBT: A. SmartArt B. WordArt C. Draw D. Shape
What is B WordArt
100
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart? NCCTE.9_12.BE.BM20.1.12 RBT: A. Style B. Design C. Layout D. Format
What is B Design
200
John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use? NCCTE.9_12.BE.BM20.1.12 RBT: A. Design B. Layout C. Format D. Analyze
What is C Format
200
John wants to change the chart style on his PivotTable. Which PivotTable chart tools tab would he create? NCCTE.9_12.BE.BM20.1.12 RBT: A. Design B. Layout C. Format D. Analyze
What is A Design
200
Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart? NCCTE.9_12.BE.BM20.1.12 RBT: A. Design B. Layout C. Format D. Analyze
What is B Layout
200
Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart? NCCTE.9_12.BE.BM20.1.12 RBT: A. Design B. Layout C. Format D. Analyze
What is A Design
200
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? NCCTE.9_12.BE.BM20.1.12 RBT: A. PivotChart B. Line chart C. Embedded chart D. Linked chart
What is C Embedded Chart
300
When creating a PivotTable, which are drawn in columns in the worksheet data? NCCTE.9_12.BE.BM20.1.12 RBT: A. Records B. Fields C. Cells D. Ranges
What is B Fields
300
Which is the name of an interactive graphical representation of data that allows a user to change the groupings? NCCTE.9_12.BE.BM20.1.12 RBT: A. PivotChart B. PivotTable C. PivotDate D. Rotate Table
What is A PivotChart
300
Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable? NCCTE.9_12.BE.BM20.1.12 RBT: A. Layout B. Options C. Design D. Format
What is C Design
300
Which is a tiny chart that provides a visual representation of data in a worksheet cell? NCCTE.9_12.BE.BM20.1.12 RBT: A. Trendline B. Sparkline C. Dataline D. Flashpoint
What is B Sparkline
300
What graphically represents trends in plotted data and predicts future values? NCCTE.9_12.BE.BM20.1.12 RBT: A. Sparkline B. Trendline C. Chartline D. Error bar
What is B Trendline
400
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles? NCCTE.9_12.BE.BM20.1.12 RBT: A. Style B. Design C. Layout D. Format
What is B Design
400
Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt? NCCTE.9_12.BE.BM20.1.13 RBT: A. Data B. Design C. Style D. Format
What is D Format
400
What term refers to an Excel Chart with offset pieces? NCCTE.9_12.BE.BM20.1.12 RBT: A. Exploded B. Shattered C. Separated D. Detached
What is A Exploded
400
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet? NCCTE.9_12.BE.BM20.1.13 RBT: A. Shapes B. Picture C. SmartArt D. Screenshot
What is D Screenshot
400
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? NCCTE.9_12.BE.BM20.1.13 RBT: A. Picture Styles B. Artistic Effects C. Corrections D. WordArt Styles
What is A Picture Styles
500
John 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? NCCTE.9_12.BE.BM20.1.12 RBT: A. Report filter B. Legend fields C. Axis fields D. Values
What is B Legend Fields
500
Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet? NCCTE.9_12.BE.BM20.1.13 RBT: A. Clip Art B. Picture C. SmartArt D. Instant Art
What is A Clip Art
500
What is the process of viewing a PivotTable report for a subset that meets the criterion only? NCCTE.9_12.BE.BM20.1.12 RBT: A. Filtering B. Sorting C. Positioning D. Arranging
What is A Filtering
500
Which Chart Tools Ribbon tab allows a user to insert various labels on the chart? NCCTE.9_12.BE.BM20.1.12 RBT: A. Style B. Design C. Layout D. Format
What is C Layout
500
What is typically included in the range of data selected to create a chart? NCCTE.9_12.BE.BM20.1.12 RBT: A. Titles only B. Numeric data and totals only C. Numeric data, totals, and titles D. Numeric data and titles
What is D Numeric Data and Titles
M
e
n
u