Examine the Apartment worksheet, and apply appropriate

Examine the Apartment worksheet, and apply appropriate names to cells D17:D20.

2. Set up the structure of a one-variable data table on the Analysis worksheet that shows the apartment rental price, electricity charge, pet food expense, and projected housing expense given changes in the average price of pet food from $1.50 to $3.10 by increments of $0.20.

3. Instruct Excel to complete the one-variable data table.

HINT: In order to complete the one-variable data table successfully, be sure to select the correct data table range. If you instruct Excel to complete an incorrect range, you cannot just delete any “extra” results that might have appeared at the bottom or right of the intended data table area. When you try to do so, you will receive the “Cannot change part of a data table” error message. You cannot delete only some results from a filled-in data table; you must delete all results values from a one-variable data table if you want to delete any results.