Complete Exercise $1,$ then enter your formula from cell C$11,$ starting with $=$

Avoid unnecessary spaces and parentheses so the auto$-$grading works.

Flag question: Question $2$

Question $21$ pts

For Exercise $1,$ if the meal cost in C$8$ were changed from $$10\mathrm{.}50$ to $$10\mathrm{.}90,$ would you need to modify your formulas to calculate the monthly cost for the new meal cost?

Group of answer choices

No$.$ When a new amount is entered into C$8,$ the monthly costs update because the cell is referenced instead of using the cost per meal inside each formula.

Yes, you would need to re$-$enter the formula in C$8$ and copy it down again to calculate the new monthly cost.

Flag question: Question $3$

Question $31$ pts

What is a correct formula $($starting with $=)$ for Exercise $2$ from cell D$28?$ Please follow the suggested form$/$order$,$ Meals$/$Month$*$Cost per Meal$*(1+$ tax rate$),$ so the auto$-$grading works. Avoid unnecessary spaces and parentheses so the auto$-$grading works. Do not "hard code" the value, $5\mathrm{.}5\%$ in your formula $-$ instead, reference C$25$ so your result would be correct if the rate in C$25$ changed.

Flag question: Question $4$

Question $41$ pts

For Exercise $3,$ what type of reference is necessary for each of the costs, i$.$e$.$ for cells B$43,$ C$43,$ and D$43?$

Group of answer choices

Neither absolute row nor absolute column references, i$.$e$.$ a relative reference

Abolute row and absolute columan references

Absolute column reference

Absolute row reference

Flag question: Question $5$

Question $51$ pts

For Exercise $4,$ what is your formula in C$70($starting with $=)?$

Group of answer choices

$=$$B$70*$C$$69$

$=$B$70*$C$69$

$=$B$$70*$$C$69$

$=$$B$$70*$$C$$69$

Flag question: Question $6$

Question $61$ pts

For Exercise $5,$ which cell references must have both absolute column and absolute row references? Select all that apply.

Group of answer choices

Cost per adult on each date

Cost per bag

# of adults

# of children

# of bags

Cost per child

Flag question: Question $7$

Question $71$ pts

For Exercise $5,$ how should your formula in E$87$ reference the number of adults in cell B$87?$

Group of answer choices

$B$87$

$B$$87$

B$$87$

B$87$

Flag question: Question $8$

Question $81$ pts

For Exercise $5,$ how should your formula in E$87$ reference the cost per adult on each date in cell E$84?$

Group of answer choices

$E$$84$

E$$84$

$E$84$

E$84$