00:01
So for the first question, the first part of the question is 21.
00:05
They have asked that for a presentation, we need to sort the customer orders for the quarter from the largest to the smallest and also highlight the orders.
00:14
So which options will choose they have asked.
00:18
So among the given options the answer is we will go for the option b.
00:25
Option b states that after sorting that is after the arrangement after sorting use the above average conditional formatting route.
00:37
After sorting, use the above average conditional formatting rule and select the highlight order.
01:03
So after using the formatting rule, then only we are going to select highlight order.
01:12
So this is the then select the highlight order.
01:20
So this is the correct answer option because this will highlight orders that are larger than the average amount.
01:28
So next is we will deal with the next question...