Scrub Jay Peripherals

PERFORMING CALCULATIONS WIIH FORMULAS AND FUNCTIONS

GEIING STARTED

Open the file NP$\_$Ex$19\_3$a$\_$FirsthastName$\_1$xisx, available for dowinload from the SAM website.

Save the file as NP$\_5619$ Firstiastivame$\_2$xisx by changing the $"1\text{'}$ to a $"2".$

If you do not see the $x$ lsx file extension in the Save As dialog box, do not type it$.$ The program will add the file extension for you automatically.

With the file RP$\_36193$a$\_$ Fistiastifame$\_2$xisx still open, ensure that your first and last name is displayed in cell $B6$ of the Documentation sheet.

If cell $86$ does not display your name, delete the file and download a new copy from the SAM website.

PROJECT SIEPS

Danilo Lewellen is an entrepreneur planning to manufacture and market an innovative handheld controller for virtual reality gaming. Danilo is building a business plan as he recrults investors and plans logistics for the launch of his new company, Scrub Jay Peripherals, and wants to use Excel to summarize data and create projections.

Switch to the Sales Projections worksheet. Use the values in the range B$6$:C$6$ to extend the incremented percentages to the range D$6$:H$6.$

$2$ Use the values in the range A$7$:AB to extend the list of years to the range A$9$:A$11.$

Use Autof$-$III to fill the range A$9$:H$11$ with the formatting from the range A$7$:H$8.$

In cell B$8,$ create a formula without using a function that multiplies the value in cell $B7$ by the value in cell $B6$ and then adds the value in $B7.$ In this formula, use a mixed reference for cell B$6$ by including an absolute reference to row $6.$ Copy the formula from Cell B$8$ to the range B$9$:B$11$ and then Copy the formulas from the range B$8$:B$11$ to the ranae C$3$:H$11.$

Mifons