10. Jane uses scenario manager in Excel to view the different scenarios of her m...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

10. Jane uses scenario manager in Excel to view the different scenarios of her monthly budget. When creating the scenario below, Income and Food were set as the Changing cells value for a single scenario. Mathematical calculations were used to calculate the Total Expenses and Income Left. Which of the following values will change each time a new scenario is displayed?

C3 and B9

0%

B3, B9, B14 and B15

0%

C3, B10, B9, B14, B16

0%

A3 and A9

0%

C3, B9, B14 and C15

100%

Want instant access to all verified answers on learn2025.ukzn.ac.za?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome