Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
Importing data
Home
Custom Filter
Styles
Format as Table
Query
Sort Filter
Sort
Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
Importing data
Home
Custom Filter
Styles
Format as Table
Query
Sort Filter
Sort
Which ribbon includes the commands to apply a quick table style to a range of cells?
Importing data
Home
Custom Filter
Styles
Format as Table
Query
Sort Filter
Sort
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?
Importing data
Home
Custom Filter
Styles
Format as Table
Query
Sort Filter
Sort
What is the process of bringing data containing text fields separated by commas into Excel called?
Importing data
Home
Custom Filter
Styles
Format as Table
Query
Sort Filter
Sort
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
Importing data
Home
Custom Filter
Styles
Format as Table
Query
Sort Filter
Sort
Which command on the Home Ribbon do you use to organize data in ascending or descending order?
Importing data
Home
Custom Filter
Styles
Format as Table
Query
Sort Filter
Sort
David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task?
Importing data
Home
Custom Filter
Styles
Format as Table
Query
Sort Filter
Sort
Check it!