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

Need excel formulas used to answer all the questions below

021 X fx B C D E G H M N P

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!