"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.

solution:

the auto-correct option of the auto-correct tool enables you to add and delete words that do not follow abbreviation rules because:

it is a feature that allows outlook to correct common spelling and typing errors and to replace characters with symbols. we can also can use auto-correct as a shortcut, which means we can type a small string of characters and have those characters replaced by a longer string.