Question

What is the correct way to refer the cell A10 on sheet 3 from sheet 1? *
1 point
a. Sheet3!A10
b. Sheet1!A10
c. Sheet3.A10
d. A10

Answer 1

Explanation:

First we use the name of sheet, then put an exclamation mark, at the end give the cell reference.

Answer 2

The correct way to refer the cell A10 on sheet 3 from sheet 1 is Sheet3!A10

• a. Sheet3!A10 is the correct option
• Excel enables one to refer to any cell on any worksheet, which can be particularly useful if one wants to reference a certain value from one worksheet to another.
• For doing this, one will simply need to start the cell reference with the worksheet name which should be followed by an exclamation point (!).
• In the given example, if one wanted to reference cell A10 on Sheet3, its cell reference would be Sheet3!A10.
• Note that if a worksheet name includes a space then one will require to include single quotation marks (' ') around the name.

#SPJ2