"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

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

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.