Question: Need excel formulas used to answer all the questions below Editing 021 X fx B C D E G H M N P ACME WIDGETS

Need excel formulas used to answer all the questions below

Editing 021 X fx B C D E G H M N P ACME WIDGETS kem Code Descriptio Price Instock Customer Customer Tax Invoice W44832 Washing! $ 450.00 One: November 17, 2020 072329 Dishwash $ 498.00 Isvoice # R39245 Refridger. $ 677 00 Customer 10 P97347 Plasma TV $ 1,589.00 co 4 To P97350 Plasma Ts $ - 1,899.00 10 L44242 LCD TV 4. $ 1,399.00 2 Description Qty Unk Price Like Total No Changes Create 2 customers. 1and 2. one customer has a Y in the tax column and one has a N Subtotal $ Sales Tor You will need a formula. Both are vlookup, but one vlookup is embedded in an IF statement' You wil need data that looks something up in the Product Database or Customer database depending on the field. Your choice Tax rate is 7 25% 31 Directions: Follow the color codes above In F2. put in one of the curtomer numbers you created. The name will appear in B6 32 In AT1 put in an kem Code from the Product Database. The name will appref in Description. In DTI put in a Quantity and the total price wil arrear in F13 33 Check both customer numbers, one should add tax in F21 and one should not Paraking Bonus Invoice Product Database Customer Grades Grades 2 (+ - Archiving Data.. Sales Template
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
