Question: How would this be executed? Each photo is a different tab. Add a column that will use a vLookp function to display the price based

How would this be executed? Each photo is a different tab.

Add a column that will use a vLookp function to display the price based on the type of flower listed on the "Prices" tab.

The orders tabs

. How would this be executed? Each photo is a different tab. Add a column that will use a vLookp function to display the price

The Prices Tab

based on the type of flower listed on the "Prices" tab. The

you do not need to see the entire excel chart to answer the question. The question merely asked how you would execute the following using vlookup.

Columns Column 6 Column7 Columns Red Light Pink 8 13 8 White 21 15 16 5 2 4 8 16 12 5 2 3 1 2 4 23 19 8 3 7 10 7 6 14 15 14 9 10 6 8 18 19 8 18 15 8 3 7 2 10 1 Columni Column2 Column3 Column 4 The Whole Bouquet - A Floral Wholesale Supplier January Orders (by Dozen) Order# Order Date Delivery Date Customer 190101 1/2/19 1/11/19 Garcia 190102 1/2/19 2/11/19 Jones 190103 1/2/19 2/12/19 Jones 190104 1/2/19 2/11/19 Rivera 190106 1/2/19 1/11/19 Garcia 190107 1/2/19 1/9/19 Jones 190108 1/2/19 1/11/19 Jones 190109 1/2/19 2/11/19 Rivera 190110 1/2/19 1/9/19 Garcia 190111 1/2/19 2/12/19 Jones 190112 1/2/19 2/11/19 Martin 190113 1/2/19 2/12/19 Martin 190114 1/2/19 1/9/19 Kim 190115 1/2/19 | 2/11/19 Kim 190116 1/2/19 2/12/19 Kim 190117 1/2/19 2/12/19 Kim 190118 1/2/19 2/11/19 Kim 190119 1/2/19 2/12/19 Kim 190120 1/2/19 1/9/19 Smith 190121 1/2/19 2/12/19 Martin 190122 1/2/19 1/9/19 Kim 190123 1/2/19 1/11/19 Rivera 190124 1/2/19 1/9/19 Kim 190125 1/2/19 1/11/19 Kim 190126 1/3/19 2/11/19 Jones 190127 1/3/19 2/12/19 Garcia 190128 1/3/19 2/11/19 Garcia 190129 1/3/19 1/10/19 Garcia 190130 1/3/19 2/12/19 Kim 190131 1/3/19 1/10/19 Smith 190132 1/3/19 2/12/19 Rivera 190133 1/3/19 1/11/19 Smith 190134 1/3/19 2/11/19 Kim 190135 1/3/19 2/11/19 Kim 190136 1/3/19 2/12/19 Kim 190137 1/18/19 Rivera 190138 1/4/19 2/12/19 Garcia 8 2 10 9 9 Floral Type Roses Tulips Carnations Roses Tulips Roses Roses Miniature Roses Carnations Carnations Miniature Roses Carnations Roses Roses Roses Roses Roses Roses Roses Carnations Roses Miniature Roses Roses Roses Roses Tulips Roses Carnations Roses Tulips Miniature Roses Carnations Roses Roses Roses Miniature Roses Roses 4 4 8 2 17 4 3 5 7 2 3 4 1 18 3 3 3 5 9 1 6 6 4 1 6 4 4 4 2 6 13 11 1 2 22 2 17 8 1 8 11 4 5 2 watow on 8 21 2 1 2 1/4/19 3 11 2 6 1 Dark Pink Yellow 9 13 Lilac 4 6 Special 4 5 Total 70 75 62 26 11 3 4 11 4 4 2 2 1 2 1 3 12 4 1 5 2 1 5 Include Baby's Breath? Discounts 11 Yes 12 Yes 8 Yes 5 Yes 2 Yes 3 Yes 16 No 4 Yes 9 Yes 11 No 6 Yes 11 No 18 88 2 28 12 3 4 59 4 72 14 9 16 5 2 6 2 43 5 82 85 5 Yes 5 2 17 5 Yes 1 16 5 2 7 4 10 1 1 3 Yes 2 8 31 11 44 2 Yes 2 2 5 7 13 No Yes 4 37 75 16 15 Yes 3 2 1 1 1 1 1 1 2 3 Order Source 15% Phone 0% Main Website 0% Phone 0 0% Promotional Website 0% Main Website 0 0% Main Website 0% Phone 15% Main Website 0% Promotional Website 12% Phone 15% Phone 0% Phone 12% Phone 15% E-mail 0% Promotional Website 12% Phone 12% Main Website 15% Main Website 5% Phone 15% Phone 15% Phone 15% Phone 5% E-mail 12% Promotional Website 12% E-mail 5% Main Website 0% Main Website 12% E-mail 15% Main Website 15% E-mail 0% Main Website 15% Main Website 15% Main Website 15% Main Website 12% Promotional Website 12% Main Website 0% Promotional Website 10% E-mail 12% Main Website 12% Main Website Yes Yes 1 1 1 3 21 3 5 1 2 2 Yes 2 0 0 Yes 34 5 31 7 2 5 1 5 3 10 1 1 1 No Yes 4 19 1 3 7 2 2 1 5 Yes Yes 0 2 52 10 91 4 16 2 14 1 1 5 3 17 3 13 7 3 Yes Yes Yes Yes 13 79 4 3 10 3 13 1 1 Yes Yes 50 18 77 6 4 5 11 1 0 0 1 1 1 15 2 3 3 8 1 8 0 2 7 1 5 4 5 0 No Yes Yes Yes Yes Yes Yes 49 6 6 37 2 2 2 1 5 6 28 36 Wholesale Price List (per dozen) Roses 23 Miniature Roses 14 Tulips 18 Lilies 19 Carnations 11 Baby's Breath = Add $5 per dozen to total order Special Color = Add 20% to the prices

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

IMPORTANT INFORMATION: IGNORE THE FOLLOWING ON FIRST TAB (AS YOU DO NOT HAVE QUESTIONS TO ANSWER) After developing the performance reports, you will answer questions about the variances and determine...

Please show the formulas as well Flexible Budget Performance Report Project Upload your completed project to Blackboard using "Flex Budget_Last Name_TA" as the file name. Kelsey's Frozen...

Step 1: Import and Clean Up Text File Download starting student Excel file and the text file. Open the starting Excel file and navigate to Sheet1. Import the text file by using the Get External Data...

This is my Finance Investments project and I have no idea how to do any of it besides just downloading the data. If you can help in any way or tell me how to do the IF function that would be awesome....

You will be asked to complete Excel functions and tasks and answer questions from the text. Your case study will be found in Chapter 2, Peoples Choice Bank.. Your case study will ask for opinions and...

You don't need Describe how the following would be executed using excel: . Find the 3 month moving average of flowers ordered for 2018. 4. Add a series of columns to your Orders data table that will...

. Find the 3 month moving average of flowers ordered for 2018. 4. Add a series of columns to your Orders data table that will result in displaying the total price for each order. At a minimum, you...

Must know how to use excel. Please provide an explanation of how to execute the following. I just need a general understanding of how to do this. . Find the 3 month moving average of flowers ordered...

The orders tab The Prices Tab How would you approach the following functions using these excel tables? Columns Column 6 Column7 Columns Red Light Pink 8 13 8 White 21 15 16 5 2 4 8 16 12 5 2 3 1 2 4...

you do not need to see the entire excel chart to answer the question. The question merely asked how you would execute the following using vlookup. Describe how the following would be executed using...

1.Declare a two-dimensional array of Strings named chessboard . 2.Declare a two-dimensional array of integers named tictactoe . 3.Declare and create a two-dimensional array of chars, tictactoe , with...

On January 1, 2012, Platz, Inc., issued $200,000 of 9%, five-year bonds payable at 106. Platz has extra cash and wishes to retire the bonds payable on January 1, 2013, immediately after making the...

Pregunta 1 Para que sean significativos, los ratios financieros deben compararse con todos los siguientes excepto: Puntos de referencia (benchmarks) Empresas pares Tiempo Consumidores

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".