$1$ Chapter $2,$ Question $8$

Use the ROUND function to zero decimal places in the Guest Count Forecast columns, cells D$5$ through D$10($D$5$:D$10)$ and D$15$ through D$20($D$15$:D$20).$ Use the SUM function for the totals, cells D$11$ and D$21.$ Otherwise, your answers will not be correct.

$2$

Months January through June

$4$

$\backslash$table$[[,\backslash$table$[[$Guest$],[$Count Last$],[$Year$]],\backslash$table$[[$Guest Count$],[\%$ Increase$],[$Estimate$]],\backslash$table$[[$Guest$],[$Count$],[$Forecast$]],\backslash$table$[[$Original$],[$Check$],[$Average$]],\backslash$table$[[$Revenue$],[$Forecast$]]],[$January$,6,270,,,,],[$February$,6,798,,,,],[$March$,6,336,,,,],[$April$,6,400,,,,],[$May$,6,930,,,,],[$June$,6,864,,,,]]$