Westonci.ca is your go-to source for answers, with a community ready to provide accurate and timely information. Explore thousands of questions and answers from a knowledgeable community of experts ready to help you find solutions. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

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 service. We're dedicated to providing the best answers for all your questions. Visit us again. We hope this was helpful. Please come back whenever you need more information or answers to your queries. Discover more at Westonci.ca. Return for the latest expert answers and updates on various topics.