When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.
A)source
B)destination
C)both a.and b.
D)neither a.nor b.

Question

When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.
A)source 
B)destination
C)both a.and b.
D)neither a.nor b.

Quizplus · Accepted Answer

When saving a workbook that contains external reference formulas, Excel stores the most recent results of those formulas in the destination file, which is the file that is being modified and saved. The source file is the file that contains the data that is being referenced.

When You Save a Workbook That Contains External Reference Formulas