\begin{tabular}{|c|c|} \hline 6 & \begin{tabular}{l} Management thinks an average of 85 guests a day would be a realistic average. Use Goal \\ Seek to find out what the price would need to be to come out exactly even with 85 guests per \\ day and $0 in Net Income. \end{tabular} \\ \hline 7 & \begin{tabular}{l} A data table with conditional formatting will help to better visualize the expenses, revenues, \\ and net income of the business. \\ Fill in the Expenses, Revenue, and Net Income cells (range G4:14) and the complete the data \\ table using the range F4:119. \end{tabular} \\ \hline 8 & Format the range G5:119 as Currency. \\ \hline 9 & \begin{tabular}{l} Copy the information in range A3:D18 from the Break-Even Analysis worksheet and paste it in \\ range A4:D19 on the worksheet PriceAndGuest. Keep the source column widths. \end{tabular} \\ \hline 10 & \begin{tabular}{l} Create a data table in the range F5:N22. The price (row 6) needs to start at \$4 and increase to \\ $11 in $1 increments, and the number of guests (column F) needs to start at 35 and increase \\ in increments of 5 . Be sure to add a reference to cell D19 in cell F6. \end{tabular} \\ \hline 11 & \begin{tabular}{l} Format the data in the data table so any net profit under $5,000 has a light red background \\ and dark red text, data that is above or equal to $5,000 and below $5,000 will have a light \\ yellow background and dark yellow text, and anything greater than $5,000 will have a light \\ green background and dark green text. \end{tabular} \\ \hline 12 & Format cell F6 to hide the result of the formula (ii) in the cell including, if the result was \\ \hline \end{tabular} Revenue \begin{tabular}{|c|c|} \hline 6 & \begin{tabular}{l} Management thinks an average of 85 guests a day would be a realistic average. Use Goal \\ Seek to find out what the price would need to be to come out exactly even with 85 guests per \\ day and $0 in Net Income. \end{tabular} \\ \hline 7 & \begin{tabular}{l} A data table with conditional formatting will help to better visualize the expenses, revenues, \\ and net income of the business. \\ Fill in the Expenses, Revenue, and Net Income cells (range G4:14) and the complete the data \\ table using the range F4:119. \end{tabular} \\ \hline 8 & Format the range G5:119 as Currency. \\ \hline 9 & \begin{tabular}{l} Copy the information in range A3:D18 from the Break-Even Analysis worksheet and paste it in \\ range A4:D19 on the worksheet PriceAndGuest. Keep the source column widths. \end{tabular} \\ \hline 10 & \begin{tabular}{l} Create a data table in the range F5:N22. The price (row 6) needs to start at \$4 and increase to \\ $11 in $1 increments, and the number of guests (column F) needs to start at 35 and increase \\ in increments of 5 . Be sure to add a reference to cell D19 in cell F6. \end{tabular} \\ \hline 11 & \begin{tabular}{l} Format the data in the data table so any net profit under $5,000 has a light red background \\ and dark red text, data that is above or equal to $5,000 and below $5,000 will have a light \\ yellow background and dark yellow text, and anything greater than $5,000 will have a light \\ green background and dark green text. \end{tabular} \\ \hline 12 & Format cell F6 to hide the result of the formula (ii) in the cell including, if the result was \\ \hline \end{tabular} Revenue