Excel 2016 Lesson 9

Inserting a ______________ will bring up windows for specific topics that will allow you to filter a table so that it shows only records containing a certain object.

• table

• slicer

• criterion

Organizing data so that it can be viewed as a collapsible and expandable outline is

• delimiting

• criterion

• collapse

• grouping

A series of steps you can record to create a shortcut you can use for things you use a lot

• parse

• table

• filter

• macro

The sum of values that are grouped together is a

• filter

• subtotal

• outline

When importing a text file you can use tabs, commas, spaces, etc. to determine where rows and columns are divided. These are called

• subtotals

• markers

• delimiters

David only wants to see the employees in the Marketing department who earn a salary of more than $25,000. What command can he use to do this?

• sort

• 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?

• subtotal

• ungroup

• sort and filter

If you need to put a spreadsheet in alphabetical order, you would use which feature?

• sort

• filter

• group

You can add _____________ to ensure that the correct information is being entered. For example, you can restrict a selection to only allow 3 digits to be entered if a column is meant to record an area code.

• Ascending

• Data validation

• delimiter

• header row

If you filter data, what happens to the information that does not fit into the filter?

• It is deleted

• It is a different color

• It is hidden