Sound Advice Excel 2013: Applying Formulas and Functions 1. Readings Read Lesson 4 in your Intermediate Excel Guide, page 109-140. Watch the video. Project Use Named Ranges to create Lookup tables. Use a formula to lookup the best answer. Downloads Sales 2013.xlsx Student Records.xlsx 2. Practice Complete the Practice Activity on page 141. 3. Assessment Review the Test Yourself questions on page 142.
Use Named Ranges to create Lookup tables. Use a formula to lookup the best answer.
Sales 2013.xlsx
Student Records.xlsx
Complete the Practice Activity on page 141.
Review the Test Yourself questions on page 142.
