using Excel Index and match functions solve:

At the Riverview Pizza Parlor, pizzas are priced as follows:

Small Medium Large

Extra Cheese $7.95 8.95 10.95

Pepperoni 8.95 10.55 11.95

Meat Lovers 11.95 14.95 17.95

Taco 10.45 11.95 13.45

Supreme 10.00 12.00 14.00

Soda 0.95 1.25 1.75

1. Create a worksheet that allows a person to enter a type (input) and a size (input) and learn the price (output) of the pizza. Use index and match. Your index table should be located on the same sheet for this Exercise.

2. Use a drop down list for both the type and size inputs.