Start Excel and open Tutorial $3\_$LaSala.xlsx$.$

Save the spreadsheet as Tutorial$-3\_$Last Name$\_$LaSala.xlsx$.($Replace $$Last Name$$ with your last name.$)$

Use the TODAY function to enter the current date in cell A$2.$

Use the fill handle to complete the months of the year from February to June.

Select the range B$4$:G$10,$ use the Quick Analysis tool to enter the SUM function to calculate the total for each month, and then widen the columns so the totals are visible.

In cell H$4,$ use the SUM function to calculate the total revenue for January through June$$s revenue for Chicago, and then copy the formula for the other restaurant locations and for the total in row $11.$

Format the range H$4$:H$11$ with the Accounting Number format and verify that the total is $$816,479\mathrm{.}00.$

In cell B$14,$ enter the correct function for calculating the average for January through June$$s revenue based on the values in the range H$4$:H$10.$

In cell B$15,$ enter the correct function for calculating the minimum amount listed for January through June$$s revenue based on the values in the range H$4$:H$10.$

In cell B$16,$ enter the correct function for calculating the maximum amount listed for January through June$$s revenue based on the values in the range H$4$:H$10.$

Revise the formula in cell I$4$ to make cell B$17$ an absolute reference, and then copy the formula for the remaining cities and for the total row.

Change the value in cell B$17$ to $15\%$; widen columns as needed.

In cell J$4,$ enter the formula to add cells H$4$ and I$4,$ copy the formula to cell J$11,$ and then apply the Accounting Number format and widen the column.

In cell K$4,$ use the VLOOKUP function to enter a ranking for the total incell J$4.$ Use the table in the range D$14$:E$18$ as the array. Note that you must make the cell addresses in the table absolute by pressing the F$4$ function key. Verify that the Function Arguments dialog box appears as shown below:

Copy the VLOOKUP formula to cell K$10.$

In cell L$4,$ use the IF function to enter $$Yes$$ if the value in cell J$4$ is greater than or equal to $$100,000$ and $$No$$ if the value is less than $$100,000.$

In cell H$11,$ use Goal Seek toset the value in cell H$11$ to $900,000$ by changing the value in cell B$4($the January sales for Chicago$).$

Widen columns as needed.

Enter the new sales for Chicago in January in cell B$18.$ Remember to enter the cell address, not the value.

Format the worksheet in Landscape orientation and select options to ensure the worksheet prints on one page.

Save your file and submit it to your instructor.