See if you got the correct answers to the assignment.
=INDIRECT("'"&F$1&"'!"&$L9)
=INDIRECT("'"&G$1&"'!"&$L2)
=INDIRECT("'"&G$1&"'!"&$L9)
=SUM(INDIRECT(H1&"!"&"B2:B13"))
It is the new range width
It represents the number of rows down from the reference point
It represents the height of the new dynamic range
It represents the number of columns over from the reference point
12964
19753
22975
27852
=if(left(F2,2)="10","10",left(F2,1))
=left(F2,1)
=if(find(F2,2,2)="10","10",left(F2,2))
=left(F2,2)
Wait!
Here's an interesting quiz for you.