Creating a new worksheet and using VLOOKUP: a. Copy the data from the Products worksheet to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Creating a new worksheet and using VLOOKUP: a. Copy the data from the Products worksheet to a new worksheet named: Vlookup O Note: See step 38 for information on how to copy dato from one worksheet to another 6. Enter the following text 0 In cell G1: Handling Fee N) In cell A12:Category iii) In cell A13: AT iv) In cell A14: DE v) In cell A15: MD vi) In cell A16: WD vii) In cell B12: Handling Fee in Dollars vili) in cell B13:0 ix) In cell B14:2 x) In cell B15:5 xi) In cell B16:10 c. Autofit the column width for column G d. In cell G2, insert a VLOOKUP function that determines the correct handling fee as follows: ) The function will refer to the Lookup_value in C2 i) The function with use the Table array A12:B16 (though it will need to be gbsoluted so that each row will reference the some toble arroy once it's copied) ) The function will take the value from the table array from column 2 Iv) The function must contain a Range_lookup of FALSE so that the categories are identical matches between the table array and the main data (f not, AT could be matched in more than one placeask your instructor to explain this) e. Use the fillhandle to copy this formula down to row 7. 1 Format G2 :G7 to Currency Number Format with 2 decimal places 48. Category UnitPrice UneCost Spokesperson Handling Fee $2.00 $0.00 1 rodactio ProducName 1 The Will Smith Special DE AT 149.99 56.25 WSL 87.60 119.99 6Athlete Pre 42.5 JR1 15 Dress 400 16 Manic 200 65.8 RG1 160.99 125.74 82 150.79 100.58 MAL $10.00 $0.00 WD AT 19 Boxing 198O 21 Miley Cyrun Music 2011 DE MD $5.00 154.99 36.15 MCI $2.00 10 12 Category Handling Fee in Dallars 13 AT 14 DE 2 15 MD 16 WD 10 Products Updated Produrts Vlookup • Save and close the excel workbook. You may now proceed to access project instructed below. Creating a new worksheet and using VLOOKUP: a. Copy the data from the Products worksheet to a new worksheet named: Vlookup O Note: See step 38 for information on how to copy dato from one worksheet to another 6. Enter the following text 0 In cell G1: Handling Fee N) In cell A12:Category iii) In cell A13: AT iv) In cell A14: DE v) In cell A15: MD vi) In cell A16: WD vii) In cell B12: Handling Fee in Dollars vili) in cell B13:0 ix) In cell B14:2 x) In cell B15:5 xi) In cell B16:10 c. Autofit the column width for column G d. In cell G2, insert a VLOOKUP function that determines the correct handling fee as follows: ) The function will refer to the Lookup_value in C2 i) The function with use the Table array A12:B16 (though it will need to be gbsoluted so that each row will reference the some toble arroy once it's copied) ) The function will take the value from the table array from column 2 Iv) The function must contain a Range_lookup of FALSE so that the categories are identical matches between the table array and the main data (f not, AT could be matched in more than one placeask your instructor to explain this) e. Use the fillhandle to copy this formula down to row 7. 1 Format G2 :G7 to Currency Number Format with 2 decimal places 48. Category UnitPrice UneCost Spokesperson Handling Fee $2.00 $0.00 1 rodactio ProducName 1 The Will Smith Special DE AT 149.99 56.25 WSL 87.60 119.99 6Athlete Pre 42.5 JR1 15 Dress 400 16 Manic 200 65.8 RG1 160.99 125.74 82 150.79 100.58 MAL $10.00 $0.00 WD AT 19 Boxing 198O 21 Miley Cyrun Music 2011 DE MD $5.00 154.99 36.15 MCI $2.00 10 12 Category Handling Fee in Dallars 13 AT 14 DE 2 15 MD 16 WD 10 Products Updated Produrts Vlookup • Save and close the excel workbook. You may now proceed to access project instructed below.
Expert Answer:
Answer rating: 100% (QA)
Autofit the column width for column G Select the entire column G and select Format from Home tab ie ... View the full answer
Related Book For
Differential Equations and Linear Algebra
ISBN: 978-0131860612
2nd edition
Authors: Jerry Farlow, James E. Hall, Jean Marie McDill, Beverly H. West
Posted Date:
Students also viewed these accounting questions
-
a. Search the Java Web site for information on how to use a JTextArea. Write an application for the WebBuy Company that allows a user to compose the three parts of a complete e-mail message: the To:,...
-
In this assignment you need to write a program in MIPS assembly language. Your program should perform following tasks: It should prompt the user to enter five numbers one by one. Once user has...
-
A small coil C with N = 200 turns is mounted on one end of a balance beam and introduced between the poles of an electromagnet as shown in Fig. 3.70. The cross-sectional area of the coil is S = 1.0...
-
What risks accompany a standby credit letter for (a) the issuer and (b) the beneficiary?
-
What are some competitive issues that might lead a company to fully integrate e-business operations with its traditional business? What issues might lead it to keep its e-business as a separate unit...
-
Ken is 63 years old and unmarried. He retired at age 55 when he sold his business, Understock.com. Though Ken is retired, he is still very active. Ken reported the following financial information...
-
Suppose that \(x_{i}\) only takes on the values 0 and 1. Out of the \(n\) observations, \(n_{1}\) take on the value \(x=0\). The \(n_{1}\) observations have an average \(y\) value of \(\bar{y}_{1}\)....
-
How would you evaluate this team based on each of the seven characteristics of effective groups?
-
I. Byte stuff the following frame ESC Flag II. ESC ESC ESC Flag Bit unstuff the following received frame 01111110010001111101100111110010001111101111101001111101111110 III. Specify whether the...
-
Andrea is in charge of scheduling the work for the service department of a car dealership. Lately, people in the sales department have been taking telephone calls from customers and promising that...
-
Online Vegan Sushi catering business - Evaluate your company's strengths, weaknesses, opportunities, and threats by conducting a SWOT Analysis. - Determine the main sources and intensity of...
-
$10,000 pesos are invested in the purchase of a machine to produce tortillas and it promises income for the first three months of $5000, $3000 and $5000. What is the rate of return on investment or...
-
DM acquired 80%-of the equity shares in SZ on 1 January 20X1. The consideration for the acquisition consisted of the following: Cash of $4,800,000 paid on 1 January 20X1 Cash of $2,000,000 payable on...
-
If we obtain a personal loan of $8,000 for 48 months, with an annual rate of 21% which we plan to amortize through unpaid balances, what is the first monthly payment that the bank will deduct from us...
-
The Diamond Jubilee is a floating riverboat casino that operates on the Mississippi River. Casinos attain a profit by collecting the bets/wagers placed by guests, but giving back on average a % of...
-
Businesses are required to record proof that workplace health and safety information was communicated clearly. What are some ways to achieve this?
-
What does the following algorithm do? Figure out its best-case running time function and worst-case running time function, and express them using "Big-Oh" notation. Algorithm Unknown (A, n): Input:...
-
Which of the following statements is false? a. Capital leases are not commonly reported in a Capital Projects Fund. b. A governmental entity may report a Capital Project Fund in one year but not the...
-
Verify that y = cet is a solution for any real c. of y' = 2ty determine c so that y(0) = 2
-
Autonomous Analysis For the first-order autonomous equations in Problems, complete the following. (a) Sketch qualitative solution graphs. (b) Highlight the equilibrium points of the equation and draw...
-
Wronskian Suppose that f and g are differentiable functions on the unit interval I. The Wronskian of f and g is given by Show that if W[f, g] (t) ( 0 for all t in I, then f and g are linearly...
-
You have two regions, A and B, of differently doped silicon, with the regions joined together to make a continuous silicon crystal. When the positive terminal of a battery is connected to region...
-
In Figure P32.33, what combinations of positive bias (input signals) A, B, C, D allow the light bulb to light up? Data from Figure P32.33 A B OR JOR AND D
-
Suppose a transistor consists of a very narrow \(p\)-type material sandwiched between two very wide regions of \(n\)-type material. (a) Is the charge on the \(p\)-type region positive or negative,...
Study smarter with the SolutionInn App