Examveda
Examveda

What is the correct way to refer the cell A10 on sheet3 from sheet1?

A. Sheet3!A10

B. Sheet1!A10

C. Sheet3.A10

D. A10

Answer: Option A

Solution(By Examveda Team)

First we use the name of sheet, then put an exclamation mark, at the end give the cell reference.
It would be look like =Sheet3!A10

This Question Belongs to Computer Fundamentals >> MS Excel

Join The Discussion

Comments ( 5 )

  1. Gaurav Bishwokarma
    Gaurav Bishwokarma :
    11 months ago

    This answer is wrong answer must be B

  2. Shakar Navid
    Shakar Navid :
    2 years ago

    Right ans is option B

  3. Kp Pokharel
    Kp Pokharel :
    3 years ago

    It is wrong answer. Right ans is option B

  4. Balaram Chapai
    Balaram Chapai :
    6 years ago

    ans should be B.

  5. Rahul Singla
    Rahul Singla :
    6 years ago

    option should be B cause we are referencing cell from sheet 1 to sheet 3. So and before give answer A first try practical and use = sign before sheet1!a10 command.

Related Questions on MS Excel