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 recruits 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.$

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

Use AutoFill 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 B$7$ by the value in cell $B6$ and then adds the value in $B7.$ In this formula, use a mixed reference for cell $B6$ by including an absolute reference to row $6.$ Copy the formula from cell $B8$ to the range $B9$:$B11$ and then copy the formulas from the range $B8$:$B11$ to the range $CB$:$H11.$

Switch to the Cost Estimates worksheet. In cell A$9,$ create a formula using the AVERAGE function that calculates the average of the values in the range $A5$:$A7,$ then copy your formula to cell D$9.$

In cell A$10,$ create a formula using the MAX function that identifies the maximum value in the range $A5$:$A7$ and then copy your formula to cell D$10.$

In cell A$11,$ create a formula using the MIN function that identifies the minimum value in the range $A5$:$A7$ and then copy your formula to cell D$11.$

In cell B$13,$ create a formula using the VLOOKUP function that looks up the value from cell $A11$ in the range $A5$:$B7,$ returns the value in column $2,$ and specifies an exact match. Copy the formula to cell E$13.$

Switch to the Profit Projections worksheet. In cell H$5,$ use the TODAY function to insert the current date.