subject

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.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 09:50
17. implement the jvm dload instruction for the mic-2. it has a 1-byte index and pushes the local variable at this position onto the stack. then it pushes the next higher word onto the stack as well
Answers: 2
question
Computers and Technology, 22.06.2019 17:40
Gabe wants to move text from one document to another document. he should copy the text, paste the text, and open the new document highlight the text, select the cut command, move to the new document, make sure the cursor is in the correct location, and select the paste command select the save as command, navigate to the new document, and click save highlight the text, open the new document, and press ctrl and v
Answers: 1
question
Computers and Technology, 23.06.2019 14:00
In which job role will you be creating e-papers, newsletters and preiodicals
Answers: 1
question
Computers and Technology, 24.06.2019 08:00
Can someone work out the answer as it comes up in one of my computer science exams and i don't understand the cryptovariables
Answers: 1
You know the right answer?
The worksheet named ElectronicsSales contains information about several sales made at an electronics...
Questions
question
Mathematics, 29.05.2020 21:59
question
English, 29.05.2020 21:59
question
Mathematics, 29.05.2020 21:59
Questions on the website: 13722367