which set of steps will organize the data to only show foods with more than 100 calories and rank their…

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?\nsort sugar in descending order, and filter calories by under 100 calories.\nsort sugar in ascending order, and filter calories by over 100 calories.\nfilter calories by over 100 calories, and sort sugar in descending order.\nfilter calories by over 100 calories, and sort sugar in ascending order.

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?\nsort sugar in descending order, and filter calories by under 100 calories.\nsort sugar in ascending order, and filter calories by over 100 calories.\nfilter calories by over 100 calories, and sort sugar in descending order.\nfilter calories by over 100 calories, and sort sugar in ascending order.

Answer

Explanation:

Step1: Select relevant foods

We first need to filter out foods with more than 100 calories. This narrows down the data - set to the foods we are interested in.

Step2: Rank sugar content

After filtering for calories, we rank the remaining foods by their sugar content from greatest to least, which means sorting the sugar - column in descending order.

Answer:

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