Welcome to Westonci.ca, where curiosity meets expertise. Ask any question and receive fast, accurate answers from our knowledgeable community. Explore in-depth answers to your questions from a knowledgeable community of experts across different fields. Connect with a community of professionals ready to help you find accurate solutions to your questions quickly and efficiently.

Which external reference is formatted correctly?

=[My_Sales.xlsx]!Quarter1:C12

O ='(My_Sales.xlsx)!Quarter1':C12

O ="[My_Sales.xlsx]Quarter1'!$C$12

O =(My_Sales.xlsx)!Quarter1:$C$12


C on edge.


Sagot :

Answer:

= '[My_Sales.xlsx]quarter1'!C12

Explanation:

The formula gets the value of the cell C12 in the quarter worksheet of the  My_Sales.xlsx workbook.

Answer:

C

Explanation:

got it right on edge