Question

We can shift from one scenario to another by [1 mark]
A. None of the above
B. Find and Replace
C. Data Source
D. Navigator​

Answer 1

Answer:

Explanation:

A Scenario is a set of values that Excel saves and can substitute automatically on your worksheet. You can create and save different groups of values as scenarios and then switch between these scenarios to view the different results.

Answer 2

The shift from one scenario to another can be done by the Navigator option. Thus, option D is correct.

• From the name Navigator, we can understand that it refers to something that is used to go from one window to another. Thus, it is the option that is used to shift from one scenario to another in a computer.

• The Find and Replace option is used to find a particular word or sentence and replace it with another word or sentence. This option is mainly found in Microsoft Word and Microsoft Excel.

• Data source refers to the source folder from which a file or document has been derived. It is the folder in which the required file is stored.

• Thus, Navigator is the answer.

#SPJ2