You are trying to set up an Excel spreadsheet to track customer orders for a company. There are a few

things you need to complete:

$($a$)$ Create defined names for selected cells in the Policy worksheet

You need to use the suggested names given in the Policy worksheet.

$($b$)$ Determine the appropriate price based on quantity ordered

Use appropriate function$($s$)$ to set up a formula to look up$,$ for each customer, the price in the Price

Table using the quantity ordered.