In a new worksheet what is the correct formula to reference cell a1 from the alpha worksheet

QUESTION 3 / 15 In a new worksheet, whats the correct formula to reference Cell A1 from the ALPHA worksheet? =ALPHA?A1 =A1 =ALPHAA1 =ALPHA!A1 =ALPHAA1 QUESTION 3 / 15 In a new worksheet, what’s the correct formula to reference Cell A1 from the ALPHA worksheet? =ALPHA?A1 =A1 =”ALPHA”A1 =ALPHA!A1 =’ALPHA’A1

Answer:
The correct answer is the fourth option
=ALPHA!A1
The formula to reference Cell A1 from ALPHA worksheet is
=ALPHA!A1
i.e. the worksheet name followed by an exclamation point and
then the Cell Number.
Thus, the other options are incorrect.

Also Read :   What does 14k lp mean on a wedding band?

Leave a Comment