Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
What is the process of bringing data containing text fields separated by commas into Excel called?
Query
Subtotal
Importing data
Sort and Filter
Sort
Sort
Ascending
Filter
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?
Query
Subtotal
Importing data
Sort and Filter
Sort
Sort
Ascending
Filter
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
Query
Subtotal
Importing data
Sort and Filter
Sort
Sort
Ascending
Filter
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?
Query
Subtotal
Importing data
Sort and Filter
Sort
Sort
Ascending
Filter
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
Query
Subtotal
Importing data
Sort and Filter
Sort
Sort
Ascending
Filter
Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to know how many members are in the same first period class. Which feature would allow him to do this?
Query
Subtotal
Importing data
Sort and Filter
Sort
Sort
Ascending
Filter
Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?
Query
Subtotal
Importing data
Sort and Filter
Sort
Sort
Ascending
Filter
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?
Query
Subtotal
Importing data
Sort and Filter
Sort
Sort
Ascending
Filter
Check it!