PROJECT STEPS

Yuki Lo is a financial manager for Youngwood Insurance, a national insurance company.

In an Excel workbook, he has been tracking income and expenses along with client data

for the office in Portland, Oregon. He has asked you to help him complete the workbook

and insert new charts.

Go to the Portland Office worksheet. In cell K$2,$ insert a formula using the TODAY

function to display today's date.

Fill the range D$5$:F$5$ with a series based on the value in cell C$5$ to provide the missing

month names.

Format the text in cell A$5$ as follows to make it readable and more meaningful:

a$.$ Merge and center the contents of the range A$5$:A$18.$

b$.$ Rotate the text in the merged cell up so it reads from bottom to top.

c$.$ Middle align the merged cell.

d$.$ Resize column A to a width of $5\mathrm{.}00.$

Use AutoFit to resize column B to its best fit to display all the text in the column.

Complete the calculations for the Revenue data as follows:

a$.$ In cell C$8,$ enter $64,500$ as the Life insurance income for January.

b$.$ In cell C$9,$ use the SUM function to total the January Income values $($the range

C$6$:C$8).$

c$.$ Copy the formula in cell C$9$ to the range D$9$:F$9$ and to cell H$9$ to complete the

totals.

Format the nonadjacent ranges C$14$:F$17$ and H$14$:H$17$ using the Comma Style format

and no decimal places to match the formatting of the Income data.