Offset and Indirect Assessment

This is the file needed to answer this assessment question: Offset and Indirect Question 1

From the file above put the diagonal elements of the blue area in a single column.

This is the file needed to answer this assessment question: Offset and Indirect Question 2

In the file above, use MATCH and OFFSET functions to write formulas in cells H5:J5 that return the correct statistics for the QB selected in cell G5.

This is the file needed to answer this assessment question: Offset and Indirect Question 3

In the file above, sheets 1-10 give sales of candy and ice cream. Efficiently place this data in Sheet1.