GEITING STARTED

Save the file NP EX$36520213$a FirstLastName$\_1.$xisx as

NP$\_$EX$365\_2021\_3$a$\_$FirstlastName$\_2.$xisx

a$.$ Edit the fie name by changing $"1"$ to $"2"$

a$.$ 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\_3$a$\_$FirstLastName$\_2.$xisx open, ensure that your first and last name is displayed in crell $B6$ of the Documentation worksheet.

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

PROJECT STEPS

Daniio Lewelien is an entrepreneur planning to manufacture and market an innovative hanaheid controlier for virtuai reality gaming. Danilo is building a business plan as he rectuits investors and plans logstics for the launch of his new company, Scrub day Peripherals, and wants to use Excel to summarize data and create projections

itch to the Sales Projectians workshept. Use the values in the range $86$:C$6$ no extend The incremented percentages to the range Db:HG$.$

Use the values in the range $A7$ : $AB$ to extend the list of years to the range $A9$:$A12.$

Use Autofall to fill the range A$9$:H$11$ with the formating from the range A$7$: $H8.$

In cel $BB,$ Greate a formula without using a function that multiplies the value in cell $B?$ by the vaiue in cell $86$ and then adds the value in $87.$ In this formula, use a mixed reference for cell B$6$ by including an absalisa reference to raw $6.$ Copy the formula from range Cl:H$11$

b$.$ Swhin to the Cost Estamares worksheet. In can A$9,$ create a formula uting the AVEMAGe funtion that calculates the averape of ithe yolues in the range AS$-$A$?,$ then copy your formula to cell D$?$

Ebcus

Wes canvo