STAT122 TS11 Subject

MS Excel Spreadsheet

https://docs.google.com/spreadsheets/d/15rLv19aOJiSutzi4koFA4lec2g6waJWh/edit?usp=sharing&ouid=104241546016050269610&rtpof=true&sd=true

This is the data or table to be able to answer in excel 1-5. ^^

1. The formula in cell I2 contains a referencing error that must be fixed before copying the formula down the column. Assuming you want the formula in H2 to always reference the cell directly to its left, correct the formula and copy the corrected formula on the spreadsheet.

2. Once the formula in I2 is fixed, copy the formula down the column. What is the "Order Type" of Order ID 20193, placed on October 2, 2012?

3. Your manager decides that using only 3 levelssmall, medium, and largedoes not give the shipping department enough information. She wants to use the 10 levels shown in Lookup Table 1 (A3:B12). Based on the layout of Lookup Table 1, should you use a VLOOKUP function or an HLOOKUP function?

4. What is the "Expanded Order Type" of Order ID 20193, placed on October 2, 2012?

5. The company gives a 1% discount on any Extra Large or larger orders. In the "Discount" column, make a formula that returns 0.01 if the "Expanded Order Type" is Extra Large, XX Large, or XXX Large, and returns 0 otherwise. Copy the formula down to all rows. How many orders will have a discount applied?

If done correctly, will leave a thumbs up and a positive comment. thank you in advanced!