Assignment Goal: This exercise should allow students to set up a range and category table to use the VLOOKUP function to categorize approximate values.
Weekly Outcomes: At the completion of this week’s assignment, students will have a column categorizing the total monthly volume of shares traded as “minimal, low, medium, or high” for both years
Weekly Topics/Tasks: Categorize Volume using VLOOKUP Function
Add Volume Range and Category Table
Range should be every quarter-billion (0; 250,000,000; 500,000,000; 750,000,000) unless volume traded amount is higher overall
Corresponding categories should be minimal, low, medium, and high
Use the VLOOKUP function to use this table to categorize monthly volumes