FREE Trial
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

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

★★★★★
The National Turkey Association wants to experiment with the effects of three different feed mixtures on weight gain in poults. Because no experience exists regarding the three mixtures, no...

Answered: 1 week ago

Question

★★★★★
Question 2 Donutland Ltd. reported the following on their balance sheet for the year-ending December 31, 2020: Donutland Ltd. Partial Balance Sheet As at December 31, 2020 Contributed Capital...

Answered: 1 week ago

Question

★★★★★
8. At this point, what are some conclusions that you can draw about the relationship between goal setting and achievement-goal orientation?

Answered: 1 week ago

Question

★★★★★
JoyceClifford gave a check for $5,000 to her nephewCarl to help with living expenses for his last year of college. The face of the check stated, As a loan. Years later, Carl wrote to his aunt asking...

Answered: 1 week ago

Question

★★★★★
Exercise 10-12 Keep or replace LO A1 Xinhong Company is considering replacing one of its manufacturing machines. The machine has a book value of $43,000 and a remaining useful life of 4 years, at...

Answered: 1 week ago

Question

★★★★★
If a new business purchased an existing building and is currently in a build out phase but has not started operations, would the paint purchased for the building be capitalized or an expense?

Answered: 1 week ago

Question

★★★★★
SECTION 2 READING STUDY GUIDE Economic Choice Today: Opportunity Cost Before You Learned The economic problem of scarcity guides economists to ask and answer basic questions about the economy. Now...

Answered: 1 week ago

Question

★★★★★
Which of the following statements is not true regarding incremental and iterative development approaches? A) Both incremental and iterative approaches are used in adaptive projects. B) Both...

Answered: 1 week ago

Question

★★★★★
A merchant obtains the retail price of an item by adding 20% to the wholesale price. Later, he has a sale and marks every item down 20% from the retail price. Is the sale price the same as the...

Answered: 1 week ago

Question

★★★★★
One gallon equals 4 quarts. The following program intends to read a floating-point value from input, convert the value from quarts to gallons, and output the volume in gallons, but the code contains...

Answered: 1 week ago

Question

★★★★★
Cash $ 120,000 Accounts receivable 48,000 Maintenance expense 22,000 Advertising expense 17,360 Fees earned 128,800 Lisa Assaad, Capital, April 1 ? Salaries expense 61,000 Machinery 93,000 Accounts...

Answered: 1 week ago

Question

★★★★★
Think about the last major purchase you made. Now consider the information you had prior to the purchase (advertisements, reviews in the media, advice from others). Did you rely primarily on...

Answered: 1 week ago

Question

★★★★★
Persuading Your Audience Strategies for

Answered: 1 week ago

Question

★★★★★
During a campaign season, pay attention to the candidates speeches and debates, or visit presidentialrhetoric.com to view current and past presidential speeches. How often does the speaker put forth...

Answered: 1 week ago

Previous Question Next Question