French Fries
Pizza
Tacos
Fried Chicken
Steak
100
1. Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this? A. Share Workbook B. Protect Workbook C. Tracking Changes D. Export
What is C. Tracking Changes
100
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? NCCTE.9_12.BE.BM20.1.12 RBT: A. Axis B. Chart title C. Data label D. Legend
What is D Legend
100
What ribbon contains the commands used to create a chart in Excel? NCCTE.9_12.BE.BM20.1.12 RBT: A. Home Ribbon B. Insert Ribbon C. Formulas Ribbon D. Data Ribbon
What is B Insert Ribbon
100
What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts? NCCTE.9_12.BE.BM20.1.12 RBT: A. Slivers B. Partials C. Slicers D. Movers
What is C Slicers
100
What can you use to easily filter PivotTables and cube functions interactively in a worksheet? NCCTE.9_12.BE.BM20.1.12 RBT: A. Slicer B. Cutter C. Division D. Sliver
What is A Slicer
200
4. Lilly is making changes to a spreadsheet her FBLA Advisor created. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should she use? A. New B. Delete C. Edit Comment D. Show Ink
What is A New
200
In order to directly report the data, what must a PivotChart always be associated with? NCCTE.9_12.BE.BM20.1.12 RBT: A. Table B. Range C. PivotTable D. Worksheet
What is C PivotTable
200
John 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? NCCTE.9_12.BE.BM20.1.12 RBT: A. Report filter B. Legend fields C. Axis fields D. Values
What is D Values
200
2. Where is the spellchecker located? A. Home Ribbon B. Page Layout Ribbon C. Review Ribbon D. View Ribbon
What is C. Review Ribbon
200
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? NCCTE.9_12.BE.BM20.1.12 RBT: A. Axis B. Chart title C. Data label D. Legend
What is B Chart Title
300
John wants to identify the exact value that each column in his chart represents. Which option should he choose? NCCTE.9_12.BE.BM20.1.12 RBT: A. Gridlines B. Arrows C. Pictures D. Labels
What is D Labels
300
6. All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made? A. Track Changes B. Change History C. History D. Names Manager
What is B Change History
300
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? NCCTE.9_12.BE.BM20.1.12 RBT: A. Axis Title B. Chart Title C. Gridlines D. Plot Area
What is C Gridlines
300
5. What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook? A. Protect Workbook B. Protect Sheet C. Share D. Protection
What is A Protect Workbook
300
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called? NCCTE.9_12.BE.BM20.1.12 RBT: A. Total field B. AutoSum C. Calculated field D. Analyzed field
What is C Calculated Field
400
What ribbon contains the commands for creating charts in Microsoft Excel? NCCTE.9_12.BE.BM20.1.12 RBT: A. Home B. Page Layout C. Insert D. Data
What is C Insert
400
Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this? NCCTE.9_12.BE.BM20.1.11 RBT: A. Share Workbook B. Protect Workbook C. Tracking Changes D. Export
What is A Share Workbook
400
3. Which ribbon contains commands to add a comment about a selected cell in a worksheet? A. Home B. Insert C. Data D. Review
What is D Review
400
The FBLA Advisor at your school would like to create random ID numbers for FBLA members at your school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the new member ID numbers? NCCTE.9_12.BE.BM20.1.11 RBT: A. RAND() B. RAND BETWEEN(1000,5000) C. BETWEEN(1000,5000) D. RANDOM(1000,5000)
What is B. RAND BETWEEN(1000,5000)
400
Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose? NCCTE.9_12.BE.BM20.1.11 RBT: A. New B. Delete C. Edit Comment D. Show Ink
What is C Edit Comment
500
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable? NCCTE.9_12.BE.BM20.1.12 RBT: A. Decrease/Increase B. Collapse/Expand C. Reduce/Add D. Subtract/Add
What is B Collapse/Expand
500
Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature should she modify? NCCTE.9_12.BE.BM20.1.12 RBT: A. Axis Title B. Chart Title C. Gridlines D. Plot Area
What is D Plot Area
500
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create? NCCTE.9_12.BE.BM20.1.12 RBT: A. Bar B. Column C. Line D. Pie
What is B Column
500
Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data? NCCTE.9_12.BE.BM20.1.12 RBT: A. PivotChart B. PivotTable C. PivotDate D. Rotate table
What is B PivotTable
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? NCCTE.9_12.BE.BM20.1.12 RBT: A. Bar B. Column C. Line D. Pie
What is C Line
M
e
n
u