The spreadsheet below shows a list of fruits with their calorie count, grams of sugar, dietary fiber, and protein. 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?

Sort Sugar in descending order, and filter Calories by under 100 calories.
Sort Sugar in ascending order, and filter Calories by over 100 calories. Filter Calories by over 100 calories, and sort Sugar in descending order. Filter Calories by over 100 calories, and sort Sugar in ascending order.

Answer:

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

Explanation:

Filter Calories by over 100 calories, and sort Sugar in descending order. Thus, option A is correct.

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).

140 calories with fat from a snack is ideal. It is recommended  that 25-35% of daily calorie intake come from fat, with less than 7% from saturated fat, a maximum of 10% from polyunsaturated fat and a maximum of 20% from monounsaturated fat.

Therefore, Filter Calories by over 100 calories, and sort Sugar in descending order. Thus, option A is correct.

Learn more about Filter Calories on:

https://brainly.com/question/30799744

#SPJ3

plz help thank u

Which option in PowerPoint allows
users to configure the number of columns and rows manually, using numerical values?
O Insert Table dialog box
O Draw Table option
O Insert Table drop-down menu
O Excel spreadsheet​