Working with Lists (Excel)

Which tab on the ribbon houses the sort functions?

Data

What are some commands found in the Sort Options dialog box? Check all that apply.

sort top to bottom sort left to right case sensitive

What is the purpose of the Subtotal feature?

summarizes data for analysis

Order the steps to AutoFilter data

Select any cell in the data range Click the data tab Go to Sort & Filter group Click Filter and select proper controls

What are the required components of a database function? Check all that apply.

= D in front of the command range field criteria

DMIN DCOUNT DMAX DSUM DAVERAGE

displays the smallest value in the field that meets the criteria. counts the cells that contain numbers in a given table column that match criteria. displays the largest value in the field that meets the criteria. adds the numbers in a field of records in a database that matches conditions. averages values in a field of records in a database that matches conditions.

What is the definition of filtering data?

hide data that does not fit criteria from display

What is the best location for the criteria range when filtering data?

immediately above the data you wish to sort

What are some tips to keep in mind when sorting data? Check all that apply.

Remember that data will not change when sorted. Rows and columns can be sorted. Multiple criteria can be used to sort data.

Which button in the Sort & Filter gallery of the Data tab would alphabetize from A to Z quickly?

AZ down arrow

Which option is an appropriate database function syntax?

=DSUM(A4:D8,"Unit Cost",A1:B2)

What steps can be used to access the Subtotal dialog box? Select any cell in the data range.

Data Outline Subtotal

Select the correct navigational path to sort data using multiple levels.

Data Sort & Filter Sort

What steps can be used to open the Custom AutoFilter dialog box? Select any cell in the data range.

Data Sort & Filter Text Filters

What are some commands found in the Sort dialog box? Check all that apply.

add level delete level copy level move up or down

What are the steps for subtotaling data?

any cell in the data block Data

What is the quickest way to remove filters from a worksheet?

clear

What does an outline do?

groups data by levels