tives Excel $365/2021|$ Module $1$:SAM Project la

CENGAC

bula Insurance Agency

R AND UPDATE COMPANY DATA

ETTING STARTED

Save the file NP$\_$EX$365\_2021\_1$a$\_$FirstLastName$\_1.$xIsx as NP$\_$EX$365\_2021\_1$a$\_$FirstLastName$\_2.$xIsX

Edit the file name by changing $"1"$ to $"2".$

If you do not see the $.$xIsx file extension, do not type it$.$ The file extension will be added for you automatically.

With the file NP$\_$EX$365\_2021\_1$a$\_$FirstLastName$\_2.$xIsx open, ensure that your first and last name is displayed in cell B$6$ of the Documentation worksheet.

If cell B$6$ does not display your name, delete the file and download a new copy.

OJECT 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.

Begin on the Personnel worksheet by cutting the contents of the range $B1$:$B2$ and pasting them into the range A$1$:A$2.$

Adjust the width of column A using AutoFit.

Change the width of column B to $16\mathrm{.}00.$

Enter the values shown in Table $1$ into the corresponding cells in the range $B14$:$C16.$

ble $1$: Data for the Range B$14-$C$16$