Question

Q. 18
Define the following:
a) Create Or Change A Cell Reference
b) Using "What If” Scenarios​

Answer 1

Answer:

create are change a cell reference.

Explanation:

mark as brainlist.please.

Answer 2

Answer:

set up the Excel Scenarios Worksheet

Although Excel scenarios can be complex, a simple example is used here.

Delete all sheets except Sheet1

Rename Sheet1 as Budget

On the Budget sheet, enter the Marketing budget, as shown below

Name the following cells (there are Naming instructions here: Name a Range). Naming the cells is not required, but will make it easier to manage the scenarios, and read the reports:

Name cell B1 as Dept

Name cell B3 as Sales

Name cell B4 as Expenses

Name cell B6 as Profit

In cell B6, enter the following formula:

=Sales - Expenses