P$2$: Your firm is thinking of advertising their products on a sitcom. As you buy more ads, a quantity discount is provided, and the price of each ad decreases as shown in Table $1$ in the attached file. Answer the following questions $($all in the same Excel file and in the appropriate highlighted cell$)$:

$($HINT: review the lectures to refresh yourself on how to change the table$$s template when dealing with numeric ranges in VLOOKUP$)$

Insert a table for the data and name the table as $$lookup$$

What is the VLOOKUP function you created to calculate the cost of $5$ ads?

What is the VLOOKUP function you created to calculate the cost of $12$ ads?

What is the VLOOKUP function you created to calculate the cost of $100$ ads?

What is the VLOOKUP function you created to calculate the cost of $0$ ads?