Worksheets2016 MS Excel - Lesson 9 Vocats
Total questions: 15
Worksheet time: 8mins
Kenyon would like to convert the cell range A1:F20 to a Medium 18 style. Which formatting style should he select?
Cell Style
Conditional Formatting
Fill Color
Format as Table
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
Find & Select
Format Cell
Sort & Filter
Organize
What is the process of bringing data containing text fields separated by commas into Excel called?
Importing data
Data collection
Data integration
Data migration
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?
Ascending
Descending
Filter
Custom Filter
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
Insert
Probe
Query
Sort
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?
Collapse
Group
Outline
Subtotal
Which ribbon includes the commands to apply a quick table style to a range of cells?
Data
Home
Insert
Page Layout
Which command on the Home Ribbon do you use to organize data in ascending or descending order?
Find & Select
Format Cell
Organize
Sort & 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?
Ascending
Customer Filter
Descending
Primary Sort
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?
Filter
Formula
Macro
Sort
What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
Alignment
Editing
Font
Styles
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?
AutoFill
Filter
Find and Replace
Sort
How can a table style be quickly modified to meet user preferences?
Choose Modify from the Styles Group on the Home Ribbon
Double-click a style from the Table Quick Styles Gallery
Right-Click on a style and choose Duplicate
Right-Click on a style and choose Modify
Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a summary view of all of the first period classes. Which feature would allow him to do this?
Collapse
Group
Outline
Subtotal
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?
AutoFill
Filter
Find & Replace
Sort
