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