Computers and Technology
Computers and Technology, 20.08.2020 23:01, ciarab196

The worksheet named ElectronicsSales contains information about several sales made at an electronics store. A salesperson’s name will be entered in B17. (6 points) a. Write an Excel formula that can be copied from C17 to D17:F17 that will extract that salesperson’s radio sales to C17, TV sales to D17, printer sales to E17, and CD sales to F17. b. Make necessary changes to the data file and make the search more flexible. In other words, use Data Validation to allow a user of the model to choose one salesperson from the list, and one product from the list, and then write a formula to show up the units sold automatically.

answer
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 02:00, itsyagirl11076
What is the process in which the software development team compiles information to determine the final product.
Answers: 3
image
Computers and Technology, 24.06.2019 08:10, anthonysutton82
Where are american poets found in the dewey decimal system
Answers: 1
image
Computers and Technology, 24.06.2019 11:20, davionb556
William travels a lot on business purpose. he needs to regularly communicate with his business partner. he also needs to send out weekly reports to his boss while he is traveling. which web-based application best suits william’s needs? (social media, webmail, wiki) is the best web-based application for william. he can access this application via the internet using a (digital cable, fax machine, web browser).
Answers: 1
image
Computers and Technology, 24.06.2019 15:30, sonyfan
What is the total number of time zones that can be configured to show by default in a calendar in outlook 2016?
Answers: 1
Do you know the correct answer?
The worksheet named ElectronicsSales contains information about several sales made at an electronics...

Questions in other subjects:

Konu
Biology, 21.07.2019 14:30