A) (Sheet name) . (cell reference)
B) (Sheet name) = (cell reference)
C) (Sheet name), (cell reference)
D) (Sheet name) ! (cell reference)
E) (Sheet name) : (cell reference)
Correct Answer: D
Solution :
To refer a cell from a different worksheet, the format is: Sheet Name! Cell Address (Precede the cell address with the worksheet name, and follow it with an exclamation point). For worksheet names that include one or more spaces, you will need to enclose it in single quotation marks.
You need to login to perform this action.
You will be redirected in
3 sec
