Excel Crash Course Exam from
Wall Street Prep - Wall Street
Prep Questions And Answers
Updated 2026- 2027
,recommend you analyze thisdata with the aid of a pivot table. You
may also benefit from adding some extra calculation columns to the
dataset.
Answers for numerical data should be rounded to the nearest 1decimal,
comma separating 000s, NOT written in currency format. So if the answer
is $10,500.658, you would input 10,500.7.
1. Over the entire analysis period, which sales rep sold the
highestcumulative quantity of a single item?
, Rob Stewart
2. In the last question you determined the sales person who sold the
highest cumulative quantity of a single item. What is the item code
ofthat item?
16
3. Over the entire analysis period, what is the highest selling item
codeby quantity? 16
4. Over the entire analysis period, what is the second highest
sellingitem code by quantity? 39
5. Only considering postal codes 93372, 93403 and 93434, which
postal code had the highest total profit during the month of
March?93372
6. In the last question you determined the postal code that had
thehighest total profit during the month of March. What was the
profit? 13691.4
7. During the month of April, which postal code bought the most of
item13 by quantity? 93558
8. In the last question, you determined the postal code that bought the
most of item 13 by quantity for the month of April. What was that
quantity?
24
9. What is the total of Amy Adam’s sales over the analysis
period?492,153.8
10. In the previous question, you determined the the total of Amy’s
salesover the analysis period. What was her total profit?
255,548.1
Wall Street Prep - Wall Street
Prep Questions And Answers
Updated 2026- 2027
,recommend you analyze thisdata with the aid of a pivot table. You
may also benefit from adding some extra calculation columns to the
dataset.
Answers for numerical data should be rounded to the nearest 1decimal,
comma separating 000s, NOT written in currency format. So if the answer
is $10,500.658, you would input 10,500.7.
1. Over the entire analysis period, which sales rep sold the
highestcumulative quantity of a single item?
, Rob Stewart
2. In the last question you determined the sales person who sold the
highest cumulative quantity of a single item. What is the item code
ofthat item?
16
3. Over the entire analysis period, what is the highest selling item
codeby quantity? 16
4. Over the entire analysis period, what is the second highest
sellingitem code by quantity? 39
5. Only considering postal codes 93372, 93403 and 93434, which
postal code had the highest total profit during the month of
March?93372
6. In the last question you determined the postal code that had
thehighest total profit during the month of March. What was the
profit? 13691.4
7. During the month of April, which postal code bought the most of
item13 by quantity? 93558
8. In the last question, you determined the postal code that bought the
most of item 13 by quantity for the month of April. What was that
quantity?
24
9. What is the total of Amy Adam’s sales over the analysis
period?492,153.8
10. In the previous question, you determined the the total of Amy’s
salesover the analysis period. What was her total profit?
255,548.1
