What is the correct answer?


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

Correct Answer :

A. sheet3!A10

Related Questions

You can check the conditions against __________ when applying conditional… Which of the following is not true about Find and Replace in Excel Which of the following methods can not be used to edit the contents of… Tab scrolling button Which elements of worksheet can be protected from accidental modification How can you update the values of formula cells if Auto Calculate mode… How can you find specific information in a list? Which of the following is the latest version of Excel When a range is selected, how can you activate the previous cell? What is the short cut key to highlight the entire column? Each excel file is called a workbook because How do you wrap the text in a cell? A numeric value can be treated as label value if ...... precedes it. Which area in an Excel window allows entering values and formulas? How can you delete a record? If you need to remove only the formatting done in a range (numbers and… A circular reference is You can convert existing excel worksheet data an charts to an HTML document… Which area in an excel window allows entering values and formulas Comments can be added to cells using You can move a sheet from one workbook into new book by Which of following is Not one of Excels what-if function? The command Edit >> Fill Across Worksheet is active only when Which of the cell pointer indicate that you can move the content to other… Which of the following you can paste selectively using Paste Special command? Which setting you must modify to print a worksheet using letterhead? Comments put in cells are called You can merge the main document with data source in Excel. In mail merge… You want to track the progress of the stock market on a daily basis. Which… To edit in an embedded excel worksheet object in a word document