Excel's INDIRECT function turns a text string into a reference ... because we want Excel to look up Tom's value in the range we named "week_1," and return the corresponding value in the second ...