Question

Shaarvi has created a following worksheet of expenses-
Price per
Total
S.No.
Item
Quantity
piece amount
1.
Milk
20
18
360
2.
Juice
110
20
200
3.
pizza
1
250
250
bus fare
112
5
60
write steps to show how she perform the following task-
i. Sort the total amount in INR column from the largest to the smallest.
ii. Filter the data to show only eatables.
iii. Use the conditional formatting to highlight the item with Quantity> 200.
iv. Filter the data to get the item with price >5 per piece.​

Answer 1

Answer:

it about 29 because milk cost is more