Start Excel. Open the downloaded file named Excel_Ch10_PS2_Float.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.	0
2	The company would like to determine the number of customers it should book per day in order to break even. They would like to analyze this using a break-even analysis. On the Break-Even Analysis worksheet, enter the correct formula to calculate the Gross Revenue in cell D7.	5
3	Enter the correct formula to calculate the Total Fixed Costs in D13.	5
4	In cell D17, enter the correct formula to calculate the Total Variable Costs based upon the average number of guests per day and the days of operations per year.	5
5	Enter the correct formula to calculate the Net Income in D18.	5
6	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.	10
7	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:I4) and the complete the data table using the range F4:I19.	10
8	Format the range G5:I19 as Currency.	5
9	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.	5
10	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.	10
11	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.	10
12	Format cell F6 to hide the result of the formula (;;;) in the cell including if the result was positive, negative, or zero.	5
13	Copy the information in range A3:D18 from the Break-Even Analysis sheet to the range A3:D18 on the sheet DaysAndPrice. Keep the source column widths.	5
14	Add a scroll bar to the right of the inserted cells in column F that will change the days of operations per year between the values of 225 and 275 one day at a time. Enter the text Days of Operations in cell F4 and center the text.	10
15	Add a scroll bar to the right or below of the first scroll bar in column I that will change the price between the values of $4 and $11 by $1 increments. Enter the text Price in cell I4.	10
16	Save and close Excel_Ch10_PS2_Float.xlsx. Exit Excel. Submit the file as directed.	0

Need help with these steps please! If you could please provide step-by-step instructions on how to complete each step that would awesome! I am new with excel and really need a detailed explanation please don't just repeat the instructions back. Thank you

\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & 1 & J \\ \hline 1 & \multicolumn{10}{|c|}{ Extreme H2O } \\ \hline 2 & \multicolumn{10}{|c|}{ Break-even Analysis for River Float Project } \\ \hline & & & & & & Number & & & Net & \\ \hline 3 & Revenue & & & & & & Expenses & Revenue & Income & \\ \hline 4 & & Average Number of Guests (per day) & & 75 & & Guests & & & & \\ \hline 5 & & Days of Operations per Year & & 225 & & 50 & & & & \\ \hline 6 & & Price & & & & 55 & & & & \\ \hline 7 & & Gross Revenue & & & & 60 & & & & \\ \hline 8 & Expenses & & & & & 65 & & & & \\ \hline 9 & Fixed Costs & & & & & 70 & & & & \\ \hline 10 & & Site Development & & $32,200 & & 75 & & & & \\ \hline 11 & & Equipment & & $3,450 & & 80 & & & & \\ \hline 12 & & Insurance & & $1,400 & & 85 & & & & \\ \hline 13 & Total Fixed Costs & & & & & 90 & & & & \\ \hline 14 & Variable Costs & & & & & 95 & & & & \\ \hline 15 & & Labor expense (per day) & & $275 & & 100 & & & & \\ \hline 16 & & Transportation (per guest) & & $0.85 & & 105 & & & & \\ \hline 17 & Total Variable Costs & & & & & 110 & & & & \\ \hline 18 & Net Income & & & & & 115 & & & & \\ \hline 19 & & & & & & 120 & & & & \\ \hline 20 & & & & & & & & & & \\ \hline 21 & & & & & & & & & & \\ \hline 22 & & & & & & & & & & \\ \hline 23 & & & & & & & & & & \\ \hline 24 & & & & & & & & & & \\ \hline 25 & & & & & & & & & & \\ \hline 26 & & & & & & & & & & \\ \hline 27 & & & & & & & & & & \\ \hline 28 & & & & & & & & & & \\ \hline 29 & & & & & & & & & & \\ \hline 30 & & & & & & & & & & \\ \hline 31 & & & & & & & & & & \\ \hline 32 & & & & & & & & & & \\ \hline 33 & & & & & & & & & & \\ \hline 34 & & & & & & & & & & \\ \hline 35 & & & & & & & & & & \\ \hline \end{tabular} Extreme H2O Break-even Analysis for River Float Project \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H & 1 & J \\ \hline 1 & \multicolumn{10}{|c|}{ Extreme H2O } \\ \hline 2 & \multicolumn{10}{|c|}{ Break-even Analysis for River Float Project } \\ \hline & & & & & & Number & & & Net & \\ \hline 3 & Revenue & & & & & & Expenses & Revenue & Income & \\ \hline 4 & & Average Number of Guests (per day) & & 75 & & Guests & & & & \\ \hline 5 & & Days of Operations per Year & & 225 & & 50 & & & & \\ \hline 6 & & Price & & & & 55 & & & & \\ \hline 7 & & Gross Revenue & & & & 60 & & & & \\ \hline 8 & Expenses & & & & & 65 & & & & \\ \hline 9 & Fixed Costs & & & & & 70 & & & & \\ \hline 10 & & Site Development & & $32,200 & & 75 & & & & \\ \hline 11 & & Equipment & & $3,450 & & 80 & & & & \\ \hline 12 & & Insurance & & $1,400 & & 85 & & & & \\ \hline 13 & Total Fixed Costs & & & & & 90 & & & & \\ \hline 14 & Variable Costs & & & & & 95 & & & & \\ \hline 15 & & Labor expense (per day) & & $275 & & 100 & & & & \\ \hline 16 & & Transportation (per guest) & & $0.85 & & 105 & & & & \\ \hline 17 & Total Variable Costs & & & & & 110 & & & & \\ \hline 18 & Net Income & & & & & 115 & & & & \\ \hline 19 & & & & & & 120 & & & & \\ \hline 20 & & & & & & & & & & \\ \hline 21 & & & & & & & & & & \\ \hline 22 & & & & & & & & & & \\ \hline 23 & & & & & & & & & & \\ \hline 24 & & & & & & & & & & \\ \hline 25 & & & & & & & & & & \\ \hline 26 & & & & & & & & & & \\ \hline 27 & & & & & & & & & & \\ \hline 28 & & & & & & & & & & \\ \hline 29 & & & & & & & & & & \\ \hline 30 & & & & & & & & & & \\ \hline 31 & & & & & & & & & & \\ \hline 32 & & & & & & & & & & \\ \hline 33 & & & & & & & & & & \\ \hline 34 & & & & & & & & & & \\ \hline 35 & & & & & & & & & & \\ \hline \end{tabular} Extreme H2O Break-even Analysis for River Float Project