At Westonci.ca, we make it easy to get the answers you need from a community of informed and experienced contributors. Experience the ease of finding quick and accurate answers to your questions from professionals on our platform. Explore comprehensive solutions to your questions from knowledgeable professionals across various fields 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