A data table depends on values and formulas used in a worksheet, and must appear ____ that contains this data.
A) on the same worksheet
B) in the same file
C) in the same table
D) in the same row

Question

Quizplus · Accepted Answer

A data table is typically based on values and formulas in a worksheet. Therefore, it must appear on the same worksheet that contains this data. Choices B, C and D are not appropriate because they do not accurately reflect the relationship between a data table and the underlying worksheet.

A Data Table Depends on Values and Formulas Used in a Worksheet