Question

.Formula to refer a cell A3 in sheet named S1 is
(1 Point)
=S1A3
=S1.A3
=’S1′.A3
None of the above

Answer 1

Answer:

Ans. None of the Above

Explanation:

its because when whe we link a sheet to other sheet then was use a $ sign. So it should be   $'S1'.A3

Hope it helps.

Answer 2

Formula to refer a cell A3 in the sheet named S1 is None of the above

Referencing cells outside the worksheet

• Formula to refer a cell A3 in the sheet named S1 is =S1!A3
• Most spreadsheet systems allow us to refer to any cell on any worksheet, which is very useful when referencing a specific number from one worksheet to another.
• To accomplish this, simply start the cell reference precede with the worksheet name and then add an exclamation point (!).