Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

Need excel formulas used to answer all the questions below

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Big Java, Enhanced Early Objects

Authors: Cay S Horstmann

7th Edition

1119499097, 9781119499091

More Books

Students also viewed these Finance questions