Discover the answers to your questions at Westonci.ca, where experts share their knowledge and insights with you. Get the answers you need quickly and accurately from a dedicated community of experts on our Q&A platform. Experience the convenience of finding accurate answers to your questions from knowledgeable experts on our platform.

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

Thank you for choosing our platform. We're dedicated to providing the best answers for all your questions. Visit us again. Thank you for your visit. We're dedicated to helping you find the information you need, whenever you need it. Westonci.ca is here to provide the answers you seek. Return often for more expert solutions.