The ________ Excel formula accurately displays the use of a cell from another worksheet.
A) =B6
B) =!B6
C) =May!B6
D) =B6!May

Question

Quizplus · Accepted Answer

The syntax for referencing a cell in another worksheet is "=SheetName!CellAddress", so the correct formula for referencing cell B6 in the worksheet named "May" would be "=May!B6". Option A is a valid reference to a cell on the same worksheet. Option B is not a valid formula syntax in Excel. Option D has the sheet name and cell address in the wrong order.

The ________ Excel Formula Accurately Displays the Use of a Cell