Question: Assignment 8: VLOOKUP Function Assignment Goal: This exercise should allow students to set up a range and category table to use the VLOOKUP function to


Assignment 8: VLOOKUP Function 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 2022 Trends for Pfizer, Inc
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
