A range that spans two or more worksheets in a workbook is called a ____ range.
A) 1-D
B) 2-D
C) 3-D
D) 4-D

Question

Quizplus · Accepted Answer

A 3-D range can span multiple worksheets in a workbook, as well as multiple rows and columns within those worksheets, making it the best choice for a range that spans two or more worksheets. A 1-D range only spans a single row or column, while a 2-D range spans multiple rows and columns within a single worksheet. A 4-D range would involve multiple workbooks or multiple versions of the same worksheet, which is not relevant to this question.

A Range That Spans Two or More Worksheets in a Workbook