1
AssignmentMultiple Choice

Working with Multiple Worksheets and Workbooks

Question 1 • Computer Applications I-Sem A -CA- 39901A

Which external reference is formatted correctly?

Answer
A
=[My_Sales.xlsx]!Quarter1:C12
B
=‘(My_Sales.xlsx)!Quarter1’:C12
C
=‘[My_Sales.xlsx]Quarter1’!$C$12
D
=(My_Sales.xlsx)!Quarter1:$C$12

Explanation

An external Excel reference puts the workbook name in square brackets, followed by the worksheet name, and then an exclamation mark before the cell reference. Choice C follows that pattern: ='[My_Sales.xlsx]Quarter1'!$C$12. The dollar signs make the cell reference absolute; they are valid here.

AI-written and checked against the verified answer.

Next