Register
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.
129k views
16 votes
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.

User Harsha Limaye
by
3.5k points

2 Answers

13 votes

Answer:

C

Step-by-step explanation:

got it right on edge

User Plazgoth
by
3.9k points
2 votes

Answer:

= '[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.

User Haris Krajina
by
3.8k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

3.4m questions

4.4m answers

Other Questions

Assume you have created a mechanical arm that can hold a pen. The arm can perform the following tasks: • Lower the pen to a piece of paper. • Raise the pen from the paper. • Move the pen 1 inch along a
Drag each connector name to match the connector type shown.
What problem does chlorofluorocarbon (CFC) create? a. it causes lead poisoning b.it causes great damage to the ozone layer c. it leaks into food as it cools the air and refrigerators d. it is responsible
Does anyone have game design in connections
What do customers typically notice during virtual interactions?
Link Copied!