PROJECT STEPS

As the office administrator, you use Excel to maintain personnel data and summarize cash flow. You are finalizing the Personnel and Cash Flow worksheets for the current week.

The Personnel worksheet needs cleaning up$.$ Start by moving the two cells of title information one column to the left. Resize the column to best fit the newly included information.

Change the width of the column containing salaries to match the width of the column containing commissions.

The salary and commission columns need to be completed. Enter the data shown in Table $1$ in the appropriate cells.