Welcome to Westonci.ca, your go-to destination for finding answers to all your questions. Join our expert community today! Explore thousands of questions and answers from knowledgeable experts in various fields on our Q&A platform. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A 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