How does a reference to a range appear in the Consolidate dialog box?
A. SheetName!B3:D7
B. SheetName!B3!:D7!
C. SheetName!$B$3:$D$7
D. SheetName$B3$:D7
Answer:C
How does a reference to a range appear in the Consolidate dialog box?
A. SheetName!B3:D7 B. SheetName!B3!:D7! C. SheetName!$B$3:$D$7 D. SheetName$B3$:D7