When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?
A) structured reference
B) absolute reference
C) 3-D reference
D) mixed reference

Question

Quizplus · Accepted Answer

The formula is using a 3-D reference, which refers to the same cell or range of cells on multiple worksheets in a workbook. In this case, the range is from the Chicago worksheet to the San Francisco worksheet.

When You Enter a Formula Such as =SUM('Chicago:San Francisco'!A6), Which