Comments

Editing

$\frac{?}{\text{b}\text{a}\text{r}}(\frac{?}{\text{b}\text{a}\text{r}}(Z))v$

F$$nt

Paragraph

Styles

Dictate

Sensitivity

Editor

Spelling and grammar errors aren't b$...$

Don't show again

Turn on proofin

$1+1$

$2$

$3$

$4$

$5$

$6$

$1$

$+1$

$|{)}_{?}$

$2$

$5$

$6$

$+1$

Excel $\frac{365}{2021}$

$|$ Module $12$:SAM Project la

Akio asks you to compare the results of the three scenarios. Compare the scenarios as follows:

a$.$ Create a Scenario Summary Report for result cells B$8$;B$10,$ F$13$:H$13.$

b$.$ On the Scenario Summary worksheet, delete column D to avoid repeating the data shown in column $E.$

c$.$ Delete the contents of the range $B16$:$B18$ to remove the notes.

Akio also wants to compare the scenario results. Create another scenario comparison as follows:

a$.$ Return to the Expense Report worksheet. Create a Scenario PivotTable Report for result cells B$8$;B$10,$ F$13$:H$13.$

b$.$ On the Scenario PivotTable worksheet, format all values using the Currency number format with $2$ decimal places and the $ symbol.

c$.$ Return to the Expensert Report worksheet and show the results of the Unit Sales Decrease $3\%$ scenario.

Akio also wants to determine how increasing or decreasing the number of Basel smart watches will affect gross profit. Go to the Profit Analysis worksheet, and then create a one$-$variable data table as follows:

a$.$ In cell G$7,$ enter a formula that references the gross profit for Basel smart watches $($cell B$13).$

b$.$ Create a one$-$variable data table based on the Basel sales data in the range F$7$:G$12.$

c$.$ Use the number of Basel units sold $($cell B$12)$ as the column input cell.

d$.$ Format the range G$8$:G$12$ using the Currency number format with $0$ decimal places and the $ symbol to match the formatting of cell G$7.$

$5.$ Akio projects that sales of Basel smart watches will increase by $3$ percent in the coming year and associated expenses will rise by $2$ percent. He wants to see the result in profit if sales and expenses change at different rates. Determine the changes in profit as follows:

$1$ of $8,1381$ words.

Focus

$118\%$