Answered step by step
Verified Expert Solution
Question
1 Approved Answer
9. In cell H23, calculate the sales tax, sales tax is determined bythe subtotal ofthe items ordered multiplied by the sales tax rate in cell
9. In cell H23, calculate the sales tax, sales tax is determined bythe subtotal ofthe items ordered multiplied by the sales tax rate in cell G10. (7 points) 10. In cell H24, calculate the Shipping & Handling. The shipping & handling charge is based on the Delivery Type in cell B16. Use the VLOOKUP function to return the exact match Surcharge from the range F5:H8. (10 points) 11. In cell H25, use an IF function that tests whether the value of cell H22 is greater than 250 (the minimum order needed to qualify for free shipping). If it is, return the value in H24, otherwise, return the value of 0. (10 points) 12. In cell H27, calculate the totalcost of the order by usingthe SUM function to sum the values in the range H22:H24 and then subtracting the value in H25. (10 points) 13. Set the print area to the range A1:H27. (2 points) 14. Scale the printout to 70%. (2 points) HOME INSERT PAE LAYOLUT FORMLLAS DATA REIEV VIEW AutoSum Calib , Wrap Text Garneral Norma 2 Copy FormatPainter Conditional Formatas Good Formatting- Tabl B 1 u-|;;;. . Merge Center. $. % , Calculation Insert Delete Format Clear liphaard lignmert Oixie Kaufmann Delivery Tyoe urcharge Est. Delivery Days 5 Order Number e Order Date 12.95 1S.S5 S bb11Blister Patche 3b12215 Bot Laces (Medium 14.95 595 .55 2bl6658 Snowboard Leash 3R 75 404 Topeak Lane Fort Smith AK 72314 479| 355-2081 3.70% 11 State 1015 Zendo GPSrmeter ps1587GPS Tra ed?331LED Rechergeable Lantern d991LED Rechargeable t p5148ftng Pad S112.45 395 S21.94 37 25 S 29.1.5 175 22 85 87 178 21 S 234,9 148 21 148 21 S32.55 $48.78 S12.32 394:5 Chargo 13 981 led7991 #N/ A 15 15 Dei Delivery Opdons 7815 3 Day Foam Pad h5SS1 vrb7133 E401 #N/ A #N/A #N/A #N/A pi519 nsulated Jacket Wonen's DwS558 nsulated Pants Women's b2818Down Sleeping Ba 21 b5317 Attack Snowboard Women's b5501 Attack Snowboard Men's b6601 Selar Bat sbB103S Battery Panels b8502Sunblock SPF 30 1Hikirg Sizei g8128Polanzed Snow Goggles h5591 So Helmet Womeri:s sh9810 Sno Helmet Men's p553 Snowshoes Pair Unit hipping & Handing Ehipping & Handling Discount 25 28 29 3 21 t78294 Person Te r 8140 4 Person Tent
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started