Set up the structure for the spreadsheet with labels and appropriate column

headings as illustrated below.

Create a second sheet that will document any abbreviations used, definitions

needed, and so forth.

Format each cell appropriately, for money use Currency with $2$ decimal places;

For Words use text.

Create an If Function to determine which providers $"$In$-$network" Maximum you

pay for services is more than $$6,500.$ Place IF Function two rows after initial

table.

Shade the Kaiser Permanente Senior Column Light Green

Enter the appropriate formulas and$/$or functions.

For the Plan Features Row create a check box for each of the plan features.

Create a $5$ th Column that will calculate a $3\%$ cost increas$$ in each plan for $2023.$

Use proper formulas.

Use Fill handle to copy the formula down the column.

On a new worksheet create a Pie Chart comparing the Maximum you Pay for

health services for each company. Label the worksheet Pie Chart