please explain this spreadsheet so I can get a clear understanding please.

sell Page Layout Formulas Data Review View Help Arial X cut [ Format Painter Paste Copy General BIU-EB 12. AA = = 29 Wrap Text a A F Merge & Center $ -% Clipboard IN Font Alignment Num FS A B E F F H G 1 1 2 C D Calculating net price Identify the correct price with discount Calculate the correct net price for all 18 cases 3 4 Price w/ discount if applicable 5 Number 6 7 2 8 3 9 9 4 10 5 6 12 7 13 8 14 9 15 10 16 11 17 12 18 13 19 14 20 15 21 16 22 17 23 18 24 25 26 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Price 45.00 238.00 6.50 68.00 13.00 78.50 27.90 180.40 55.30 44.80 56.60 60.00 13.75 149 10 26.25 53.80 59.70 119.30 Shipping Net Price $ 820 $24.20 $ 4.60 $ 7.80 $ 5.70 $11.20 $ 5.40 $16.70 $ 4.60 $ 5.80 $ 7.20 $ 6.80 $ 4.50 $27.90 $ 5.60 $ 7.30 $ 6.40 $17.20 + Price discount le Discount amount $ 60.00 5% Problem 1 Problem 2 Problem 3 LE Type here to search 0 a TALE 15 16 17 10 11 12 13 14 15 18 19 $ $ $ $ $ $ $ $ $ 44.80 56.60 60.00 13.75 149.10 26.25 53.80 59.70 119.30 $ 5.80 $ 7.20 $ 6.80 $ 4.50 $27.90 $ 5.60 $ 7.30 $ 6.40 $17.20 20 21 17 18 22 23 24 25 26 Price discount le Discount amount $ 60.00 5% 27 28 Rule: Use the IF function to calculate both columns. For the 'Price wldiscount if applicable' column: If the price is at least at the 'Price discount level($60) then apply the 'Discount 29 amount' (5%) to the price 30 For the 'Net Price' column: Shipping is free if the 'Price w/ 31 discount if applicable' is $50 or over 32 33 34 35 Problem 1 Problem 2 Problem 3 + Type here to search o BI a TALE