(Solved): a) Cell B2 is a formula cell. b) Cell B3 is a data cell. c) Cell B6 is a formula cell. d) Cell B8 i ...

a) Cell B2 is a formula cell.

b) Cell B3 is a data cell.

c) Cell B6 is a formula cell.

d) Cell B8 is a formula cell.

e) All of the answers choices are false

a) range names.

b) auditing tools.

c) relative references.

d) absolute references.

e) All of the answer choices are correct.

After pressing Ctrl+ ${}^{?}$ to toggle Excel to view formulas, an analyst reviews the spreadsheet shown below. Which of the following is FALSE? A 1 Monthly 2 Monthly Income 3600 3 Living Expenses 2500 4 Entertainment 500 5 Savings 250 6 Surplus/Deficit $=$ Monthly_Income-Living_Expenses-Entertainment- 7 8 Annual Surplus $=12?$ Surplus_Deficit B ple of