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$\_$Excel$\_$Ch$09\_$Cap$\_$Assessment$\_$Rates.xlsx workbook. Go back to the Exp$\_$Excel$\_$Ch$09\_$Cap$\_$Assessment$\_$Tips.xlsx workbook. In cell F$5$ of the Week worksheet, insert a link to the Beverage Worker Tip Rate $($cell C$4$ in tlit Rates workbook$)$ and multiply the rate by the Monday Drinks $($cell C$5).$ Copy the formula to the range F$6$:F$9.$