Question

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.

Answer 1

C

Step-by-step explanation:

got it right on edge

Answer 2

= '[My_Sales.xlsx]quarter1'!C12

Step-by-step explanation:

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