Hankins Aerospace

DEVELOPING AN ANNUAL REPORT

GETTING STARTED

Save the file IL$\_$WD$365\_2021\_$CS$4-7$a$\_$FirstLastName$\_1.$docx as IL$\_$WD$365\_2021\_$CS$4-7$a$\_$FirstLastName$\_2.$docx

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

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

To complete this Project, you will also need the following files:

Support$\_$WD$365\_2021\_$CS$4-7$a$\_$Data.png

o Support$\_$WD$365\_2021\_$CS$4-7$a$\_$Founder.docx

Support$\_$WD$365\_2021\_$CS$4-7$a$\_$List.docx

Support$\_$WD$365\_2021\_$CS$4-7$a$\_$Table.docx

With the file IL$\_$WD$365\_2021\_$CS$4-7$a$\_$FirstLastName$\_2.$docx open, ensure that your first and last name is displayed in the footer.

If the footer does not display your name, delete the file and download a new copy.

Insert and format a table in the "Net Sales $($Millions$)-$ Past Five Years" section as follows:

a$.$ Sort the seven paragraphs in the "Net Sales $($Millions$)-$ Past Five Years" section in ascending order.

b$.$ Convert the seven paragraphs into a table using tabs to separate the columns and a fixed column width.

c$.$ Move row $7$ in the table so that it becomes row $1$ and provides headings for each column in the table.

d$.$ Apply the Grid Table $2-$ Accent $2$ table style and shade the header row using Brown, Accent $2$ to match the formatting of the "Financial Highlights" table.

e$.$ Remove the First Column special formatting to follow the design of the "Financial Highlights ${?}^n$ table.

f$.$ Change the height of all rows to ${0\mathrm{.}25}^{\text{'}\text{'}}.$ Change the width of column $B$ to ${1\mathrm{.}65}^{\text{'}\text{'}}.$

Insert a new row at the end of the table and type Total in the first cell of the new row.

h$.$ In the second cell of the new row, insert a formula that sums the values above the cell.