Cryopexy

-In cell C7, formula to subtract the copay and payout amounts from the fee. In cell C11, use a formula to calculate total costs. In cell C13, calculate the proceeds by subtracting costs from revenues.

-Build a one-variable data table by following these steps:

a.In cell B18, key 600. Key 650 in cell B19. Fill down to 1000 in cell B26.

b.In cell C17, key a reference to the total proceeds cell. In cell D17, key a reference to the total costs formula.

c.Select cells B17:D26 and one-variable data table where the column input is the charge from the physician.

-Create conditional formatting for B18:B26 that indicates if the cell value is equal to the charge from the physician. Also create conditional formatting for C18:C26 that indicates if the cell is equal to the total proceeds.

-Label your columns. Add formatting to the table of your choice, and make sure that all your values are formatted correctly.

-In cell C8, change the fee to $750.

Two-variable data table

Purchases by patients of some products in a 2020 Vision Care office are subject to sales tax. Although taxes are computed by their billing system, the offices would like to have a reference table for quick answers to patient questions. Each state has a different tax rate, so you can build a two-variable table for the $100-$125 range.

Taxes

-In cell C7, formula to determine a sample tax amount in dollars. (This should just be the tax amount, not the tax and total amount.)

-In cell B10, reference to this formula. Make the font in B10 white so that the formula or value do not show in the cell.

-Fill the amount range in column B so that it reaches $125.

- two-variable data table in B10:F36, where your row input references the tax rate, and your column input references the amount spent.

-Create conditional formatting for B11:B36 that indicates if the cell value is equal to the amount spent in your formula reference.

-Create conditional formatting for cells C11:F36 to indicate if the value is the same as the tax added in your reference formula.

-Label your columns. Add formatting to the table of your choice, and make sure that all your values are formatted correctly.

-Change the amount in cell C5 to $113 and the tax rate to 6.25%.