The file named Lookupmultiplecolumns.xlsx contains information about several sales made at an electronics store. A salespersons name
Question:
The file named Lookupmultiplecolumns.xlsx contains information about several sales made at an electronics store. A salesperson’s name is 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.
Transcribed Image Text:
7 A Tom Dick B Harry Wendy Charlene Juli Jami Vivian Christina TV Salesperson Radio Tom fx 2 Radios 11 902166B083 6251 SNCN62 3 TV 9 12 11 9 12 9 7 9 E LL Ipods CD's 9712951167 Printer CD's 5 ܣ ܗ ܗ ܩ ܗ ܝ ܣ ܣ ܣ ܟ 8 9 5 11 8 8 6 Computers Printers 8 ( 5 5850 10 61296 11 H 12 7 286967 12 11 8 1 11
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 100% (4 reviews)
To extract the sales for each product category for the spe...View the full answer
Answered By
User l_917591
As a Business Management graduate from Moi University, I had the opportunity to work as a tutor for undergraduate students in the same field. This experience allowed me to apply the theoretical knowledge I had gained in a practical setting, while also honing my teaching and communication skills.
As a tutor, I was responsible for conducting tutorial sessions, grading assignments and exams, and providing feedback and support to my students. I also assisted with the preparation of course materials and collaborated with other tutors and professors to ensure consistency in teaching and assessment.
0.00
0 Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
You work in the Human Resources Department (or simply HR) for the accounting firm Winston, Winston & Coombs. The firm has recently increased its client base and hired several university graduates for...
-
The following data are for calculator sales in units at an electronics store over the past 9 weeks: Use trend projection with regression to forecast sales for weeks 10-13. What are the error measures...
-
1. (Adverse Selection) Consider a labor market model with many identical firms hiring workers. The firms produce a homogeneous product with a constant-returns-to-scale technology and act as price...
-
Baxter Industries, Inc., is a U.S. company that has a wholly owned subsidiary. The subsidiary maintains its book and records in a foreign currency (FC) and the majority of its local expenses such as...
-
For the plane strain elements shown in Figure P6-9, the nodal displacements are given as u1 = 0.001 in...............v1 = 0.005 in..............u3 = 0.001 in. v2 = 0.0025 in..............u3 = 0.0...
-
The trial balance for Gold Rush Exploration Company, Inc. does not balance. The following errors were detected: a. The cash, balance is overstated by \($2,000\). b. Rent expense of \($390\) was...
-
On January 1, 2006, Mason Co. entered into a 12-year lease on a building. The lease contract requires (1) annual (prepaid) rental payments of $ 36,000 each January 1 throughout the life of the lease...
-
The prices for the last 10 weeks have been collected Week GAS PRICES ($) 1 3.363 2 3.465 3 3.457 4 3.568 5 3.456 6 3.597 7 3.689 8 3.645 9 3.787 10 3.891 11 ???
-
When did the rapid development of the management science discipline begin?
-
In the file named Pinevalley.xlsx, the first worksheet contains the salaries of several employees at Pine Valley University, the second worksheet contains the ages of the employees, and the third...
-
The file Grades.xlsx contains students grades on an exam. Suppose the curve is as follows: Use VLOOKUP formulas to return each students letter grade on this exam. Score Below 60 60-69 70-79 80-89 90...
-
Proactive searching for analytical symptoms means that we are looking for accounts that appear too high or too low or that are unusual in some other way. (True/False)
-
True or false. If women are crowded into elementary education and away from fire fighting, wages in fire fighting will tend to be lower than if women werent crowded into elementary education.
-
In Table 7.1, suppose the marginal utility numbers for books change: for each quantity of books, the marginal utility is 6 utils higher. For example, for 24 books, the marginal utility is 8 utils...
-
What are the main arguments for and against UBI? What is your personal opinion on the probable effects of UBI?
-
What groups benefit and what groups have lost from the U.S. Conservation Reserve Program? Are the intended beneficiaries of the program actually doing better as a result of the program? Explain.
-
Distinguish between price loss coverage and agricultural risk coverage. How do they help reduce the volatility of farm income? In what way do farm subsidies perpetuate the longstanding problem of too...
-
Why was it important for General Motors to develop the Volt?
-
Find the market equilibrium point for the following demand and supply functions. Demand: 2p = - q + 56 Supply: 3p - q = 34
-
For the completed decision tree in Figure 6.9, the monetary values in black are those you enter. The monetary values in color are calculated automatically by Precision Tree. For this particular...
-
For the SciTools example, once you build the tree as in Figure 6.9 and then run a one-way sensitivity analysis with the dialog box filled in as in Figure 6.22, you obtain three strategy charts....
-
The tornado chart in Figure 6.24 and the spider chart in Figure 6.25 show basically the same information in slightly different forms. Explain in words exactly what information they provide.
-
Given $$ z(x, y)-\sin\left(x^{4} y^{2} ight) $$ find $\frac{\partial z}{\partial y}$. Enter your answer below as a function of $x$ and $y$ : ?
-
Regarding the diagnostic/ analytic models appropriate for analyzing the data, either an individual-level diagnostic model or an organization-level diagnostic model would work. Briefly explain how...
-
Write a computer program using the assembly language of the Intel 8085 processor. The program should mask b7, b4, b2, and bo. The given data is (-102) io then finally deposit the result into...
Study smarter with the SolutionInn App