Question

josiah needs to create an internal link to cell a4 on a worksheet, named sales data within the same workbook that he is presently working in. what is the correct syntax for this scenario? ○ =a4 ○ =sales!a4 ○ =a4!sales! ○ =a4sales!

Explanation:

To create an internal link to a cell in another worksheet (named "Sales Data" here, but the option uses "Sales" as the sheet name) within the same workbook, the syntax is =SheetName!CellReference. So for linking to cell A4 in the "Sales" worksheet, the correct syntax is =Sales!A4. The other options either miss the sheet name (like =A4 which would reference the same sheet) or have incorrect order/format.

Answer:

B. =Sales!A4