### Question 2

In **D16**: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the product is a** Microwave** insert the product **Price**, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell **D14** use the appropriate function to calculate the **total **from the results. *Format comma style, 0 decimal. *

*Blank 1 *

### Question 3

2 Points

In **E16**: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the product is a** White Refrigerator** insert the product **Quantity**, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell **E14** use the appropriate function to calculate the **total **from the results. *Format comma style, 0 decimal.*

Blank 1

### Question 4

2 Points

In **F16**: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the product is a** Standard, White, Microwave** insert the product **Price**, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell **F14** use the appropriate function to calculate the **total **from the results. *Format comma style, 0 decimal.*

Blank 1

### Question 5

3 Points

In **G16**: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the product is a** Premium, Stainless Steel, 120 V, Refrigerator** insert the product **Price**, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell **G14** use the appropriate function to calculate the **total **from the results. *Format comma style, 0 decimal.*

Blank 1

### Question 6

3 Points

In **H16**: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the product is a** Premium, Stainless Steel, Microwave or Wall Oven** insert the product **Quantity**, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell **H14** use the appropriate function to calculate the **total **from the results. *Format comma style, 0 decimal.*

Blank 1

### Question 7

4 Points

In **I16**: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the product is a **White or Stainless Steel, 120 V, Microwave or Dishwasher** insert the product **Price**, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell **I14** use the appropriate function to calculate the **total **from the results. *Format comma style, 0 decimal.*

Blank 1

### Question 8

4 Points

In **J16**: Use the product code breakdown provided at the top of the worksheet as a guide to create appropriate nested functions to complete the following:

If the product is** Stainless Steel or White, Dishwasher or Refrigerator, 120 V or Standard** insert the product **Quantity**, otherwise the cell should be blank. Copy the function down to the other cells in the column.

In cell **J14** use the appropriate function to calculate the **total **from the results. *Format comma style, 0 decimal.*

Blank 1