While referencing cells on a worksheet in other workbook, if the worksheet name contains spaces, _____.
A)single quotation mark appears to the right of the first square bracket and after the sheet name
B)double quotation mark appears to the left of the first square bracket and after the sheet name
C)single quotation mark appears to the left of the first square bracket and after the sheet name
D)double quotation mark appears to the right of the first square bracket and after the sheet name

Question

While referencing cells on a worksheet in other workbook, if the worksheet name contains spaces, _____. ​
A)single quotation mark appears to the right of the first square bracket and after the sheet name
B)double quotation mark appears to the left of the first square bracket and after the sheet name
C)single quotation mark appears to the left of the first square bracket and after the sheet name
D)double quotation mark appears to the right of the first square bracket and after the sheet name

Quizplus · Accepted Answer

When referencing cells on a worksheet in another workbook, if the worksheet name contains spaces, Excel requires that the entire path, workbook, and sheet name be enclosed in single quotation marks. This includes a single quotation mark to the left of the first square bracket and after the sheet name, ensuring that Excel correctly interprets the reference.

While Referencing Cells on a Worksheet in Other Workbook, If