Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
line chart
Ascending
design
Filter
Custom Filter
Styles
insert
Conditional Formatting
John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create?
line chart
Ascending
design
Filter
Custom Filter
Styles
insert
Conditional Formatting
David only wants to view the employees in the Marketing department who earn a salary of more than $25,000. What command should he use to complete this task?
line chart
Ascending
design
Filter
Custom Filter
Styles
insert
Conditional Formatting
Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?
line chart
Ascending
design
Filter
Custom Filter
Styles
insert
Conditional Formatting
What ribbon contains the commands for creating charts in Microsoft Excel?
line chart
Ascending
design
Filter
Custom Filter
Styles
insert
Conditional Formatting
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
line chart
Ascending
design
Filter
Custom Filter
Styles
insert
Conditional Formatting
Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that?
line chart
Ascending
design
Filter
Custom Filter
Styles
insert
Conditional Formatting
What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
line chart
Ascending
design
Filter
Custom Filter
Styles
insert
Conditional Formatting
Check it!