MICROSOFT EXCEL MULTIPLE CHOICE:

1.) Cell B15 contains the formula =B14+B15. You created a:

3-D Formula

Circular Reference

Syntax Error

2.) You want to create a situation so that you can monitor the results of cell formulas on a different worksheet as you change data on another worksheet. You should create a:

Circular Reference Window

Data Validation Window

Watch Window

3.) You created several workbooks (Accounting, Finance, Management, and Marketing) in the same folder as the main workbook SchoolOfBusiness. What formula correctly links to cell D20 in the Fall 2018 worksheet within the finance workbook?

=[Finance.xlsx:Fall 2018]!$D$20

='[Finance.xlsx]Fall 2018'!$D$20

=[Finance]Fall 2018$D$20