Question

Which set of steps will organize the data to only show foods with more than 100 calories and rank their sugar content from greatest to least?

Answer 1

Here are the multiple choices below:

A. Sort sugar in descending order, and filter Calories by under 100 calories.

B. Sort sugar in ascending order, and filter Calories by over 100 calories.

C. Filter Calories by over 100 calories, and sort Sugar in descending order.  

D. Filter Calories by over 100 calories, and sort Sugar in ascending order.

Sorting and Filtering in Excel or Access are two tools that let you organize and view your data. Sorting your data puts it in order and filtering lets you hide unimportant data. And in this case, it is no different. If you want to show foods with more than 100 calories, you should filter calories by over 100 and sort sugar in highest to the lowest (descending order).