$\backslash$table$[[,\backslash$table$[[$The servers are required to share a portion of their tips with the Beverage Worker and$],[$Assistants$.$ The rates are stored in another file.$],[$Open the Exp$22\_$Excel$\_$Ch$09\_$CumulativeAssessment$\_$Rates.xIsx workbook. Go back to the$],[$Exp$22\_$Excel$\_$Ch $09\_$CumulativeAssessment$\_$Tips.xlsx workbook. In cell F$5$ of the Week$],[$worksheet$,$ insert a link to the Beverage Worker Tip Rate $($cell C$4$ in the Rates workbook$)$ and$],[$multiply the rate by the Monday Drinks $($cell C$5).$ Copy the formula, select the range F$6$:F$9,],[$and then use Paste Formulas.$]],],[,\backslash$table$[[$Next$,$ you will calculate the tips for the assistant.$],[$In cell G$5$ in the Tips workbook, insert a link to the Assistant Tip Rate $($cell C$5$ in the Rates$],[$workbook$)$ and multiply the rate by the Monday Subtotal $($cell D$5).$ Copy the formula, select the$],[$range G$6$:G$9,$ and then use Paste Formulas. Close the Rates workbook.$],[$Note: The tip is a monetary value in the Week worksheet. It should be formatted for$],[$Accounting Number Format.$]],],[17,\backslash$table$[[$You noticed a circular error when you first opened the Tips workbook. Now you will find and$],[$correct it$.],[$On the Week worksheet, check for errors and correct the formula with the circular reference.$]],5],[18,\backslash$table$[[$You want to consolidate the daily averages on the Week worksheet.$],[$On the Week worksheet, click cell J$4.$ Use the Consolidate tool to consolidate data from the$],[$daily worksheets. Select and add the range $H4$:$18$ in each of the daily worksheets. Use the top$],[$row and left column labels when consolidating data. After consolidating the data, use Cut and$],[$Insert Cut Cells to cut the weekday column labels and data to arrange them in order, starting$],[$with Monday.$]],10]]$