Question

"HotelExp” is a 3-D range name applied to the workbook shown.

Which cells does the name "HotelExp” apply to?

cells B2:B4 in the Jan worksheet only
all cells in the B column in the Jan worksheet
cells B2:B4 in any worksheets in this workbook
all cells in the B column of any worksheet in this workbook

Answer 1

all cells in the B column of any worksheet in this workbook

Step-by-step explanation:

It seems each worksheet covers total expenses for each month, and hence workbook must have 12 such with one month for each worksheet. Also, the 3D range is a special option in Excel to reference all cells or a selected group of cells for all the worksheets. However, it should be all B cells as B2: B4 apart from this, others in B column also has expenses. And hence, the above option is the correct one.