Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

8. The file named Lookupmultiplecolumns.xlsx contains information about several sales made at an electronics store. A salesperson's name will be entered in B17. Write an

image text in transcribed
image text in transcribed
8. The file named Lookupmultiplecolumns.xlsx contains information about several sales made at an electronics store. A salesperson's name will be entered in B17. 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. X for A B C D E F G H I Radios Ipods D's Computers Printers Tom Dick Harry Wendy Charlene Juli Jami Vivian Christina Novooo TV Printer CD's Salesperson Radio Tom

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

Fundamentals Of Database Systems

Authors: Ramez Elmasri, Shamkant B. Navathe

7th Edition Global Edition

1292097612, 978-1292097619

More Books

Students also viewed these Databases questions

Question

Persuading Your Audience Strategies for

Answered: 1 week ago