Question

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?

Answer 1

='[Finance.xlsx]Fall2018'!$D$20

Step-by-step explanation:

The formula that will correctly links to cell D20 in the Fall 2018 worksheet within the Finance workbook is given as:

='[Finance.xlsx]Fall2018'!$D$20

This will perform the operation and produce the required output.