Working with Functions Answers

Which tab on the ribbon houses the sort functions?

Click the tab.

In the group, click to access the Subtotal dialog box.

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

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

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

Which option is an appropriate database function syntax?

Select .

Click the tab.

What is the purpose of the Subtotal feature?

What are some tips to keep in mind when sorting data? Check all that apply.Remember that data will change when sorted.Remember that data will not change when sorted.Rows and columns can be sorted.Only one row or column can be sorted at once.Multiple criteria can be used to sort data.Sorting cannot be undone.

What are some commands found in the Sort dialog box? Check all that apply.add levelrename leveledit leveldelete levelcopy levelmove up or down

What is the definition of filtering data?

What does an outline do?

In the group, click to access the Subtotal dialog box.