If requested by your instructor, change the entry in row $14$ by inserting your surname prior to

the text, Web Services.

Enter the table title Assumptions in cell A$22.$ Enter the assumptions in Table $3-9$ on page

EX $198$ in the range A$23$:B$27.$ Use format symbols when entering the numbers. Change the

font size of the table title in cell A$22$ to $14-$point Aharoni and underline it$.$

Select the range B$4$:I$19$ and then tap or click the Number Format Dialog Box Launcher

$($HOME tab I Number group$)$ to display the Format Cells dialog box. Use the Number

category $($Format Cells dialog box$)$ to assign the Number style with no decimal places and

negative numbers enclosed in parentheses to the range B$4$:I$19.$

Complete the following entries:

a$.$ Year $1$ Sales $=$ Units Sold in Prior Year $*($Unit Cost Margin