Excel Crash Course EXAM QUESTIONS WITH 100% CORRECT ANSWERS/NEWEST UPDATE/GRADE A+ ASSURED.
Instructions: See question 7. Your answer for this question should be rounded to the nearest 1 decimal, comma separating 000s, NOT written in
currency format. So if the answer is $10,500.658, you would input 10,500.7.
In the previous question, you determined the total of Amy's sales over the analysis period. What was her total profit? ✔️255,548.1
During the three-month period of January through March, what was the quantity of item 23 sold while Fred Rubble was the Manager on duty?
✔️784
During the month of May, how many postal codes bought more than 700 products by quantity? ✔️4
Over the entire analysis period, which sales rep gave the most discounts by dollar amount? Enter the name as: Firstname Lastname. ✔️Oliver
Winslow
Instructions: See question 7.
In the previous question, you determined which sales rep gave the most discounts by dollar amount. What was that amount? ✔️17,439.6
Instructions: See question 7.
Over the entire analysis period, which item code did postal code 93930 spend the greatest dollars on (using Sales Price Per Unit)? ✔️16
Instructions: See question 7.
Which item number had the highest average sales price per unit (use a simple average for calculation)? ✔️3
Instructions: See question 7.
For that item number, what was the average unit sales price? Please enter your answer with numbers only, to one decimal place. Use a simple
average for calculation. ✔️74.6
Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple average for calculation. ✔️Amy Adams
Instructions: See question 7.
What was that average sales price? Please enter your answer to one decimal place. Do not include any symbols. Use a simple average for
calculation. ✔️30.7
Instructions: See question 7.
Which item number had the greatest contribution to overall gross profit? Please enter your answer as a whole number only. ✔️5
Instructions: See question 7.
, What percentage of total gross profit did this item comprise? Enter as percentage as a number with one decimal place (e.g., 18.1% is entered as
18.1). ✔️8.3%
Instructions: Questions 28-30 use the data table on tab Q28-30 in the Exam Workbook(opens in a new tab).
How many companies in the S&P 500 list have a Market Cap of at least $20Bn AND Revenue of at least $15Bn? ✔️145
Instructions: See question 28.
How many constituents of the S&P 500 have a Market Cap of at least $30Bn OR Revenue of at least $17Bn? ✔️311
Instructions: See question 28.
How many constituents of the S&P 500 are listed on the New York Stock Exchange? Please enter your answer as a whole number only. ✔️386
Instructions: Questions 31-32 use the comp set on tab Q31-32 in the Exam Workbook(opens in a new tab). Answers should be rounded to the
nearest 1 decimal followed by an x to designate that it's a multiple. So if the answer is 14.765 you would input 14.8x.
What are the mean and median Next 12 Months PE Ratios of the group? Enter your answer as the mean multiple followed by the median
multiple, comma separated with no spaces. For example: 25.5x,15.8x ✔️19.9x
Question 32 ✔️10.7x
Instructions: Questions 33-37 use the data table on tab Q33-37 in the Exam Workbook(opens in a new tab). You will be asked to determine the
"Number of Items," and "Total Cost" for item classes. Total cost SHOULD be in currency format, rounded to the nearest whole dollar amount, so
if the answer is $500.78, you should input $501.
Enter the number of items and total cost for class "Buildings." Enter your answer as the number of items followed by total cost, comma
separated with no spaces. ✔️37,$184,800
Instructions: See Question 33.
Enter the number of items and total cost for class "Computers." Enter your answer as the number of items followed by total cost, comma
separated with no spaces. For example: 10,$200,000 ✔️36,$192,371
Instructions: See Question 33.
Enter the number of items and total cost for class "Equipment." Enter your answer as the number of items followed by total cost, comma
separated with no spaces. For example: 10,$200,000 ✔️30,$190,715
Instructions: See Question 33.
Enter the number of items and total cost for class "Tools." Enter your answer as the number of items followed by total cost, comma separated
with no spaces. For example: 10,$200,000 ✔️35,$255,113
Instructions: See Question 33.
Enter the number of items and total cost for class "Vehicles." Enter your answer as the number of items followed by total cost, comma
separated with no spaces. For example: 10,$200,000 ✔️22,$176,600
Instructions: See question 7. Your answer for this question should be rounded to the nearest 1 decimal, comma separating 000s, NOT written in
currency format. So if the answer is $10,500.658, you would input 10,500.7.
In the previous question, you determined the total of Amy's sales over the analysis period. What was her total profit? ✔️255,548.1
During the three-month period of January through March, what was the quantity of item 23 sold while Fred Rubble was the Manager on duty?
✔️784
During the month of May, how many postal codes bought more than 700 products by quantity? ✔️4
Over the entire analysis period, which sales rep gave the most discounts by dollar amount? Enter the name as: Firstname Lastname. ✔️Oliver
Winslow
Instructions: See question 7.
In the previous question, you determined which sales rep gave the most discounts by dollar amount. What was that amount? ✔️17,439.6
Instructions: See question 7.
Over the entire analysis period, which item code did postal code 93930 spend the greatest dollars on (using Sales Price Per Unit)? ✔️16
Instructions: See question 7.
Which item number had the highest average sales price per unit (use a simple average for calculation)? ✔️3
Instructions: See question 7.
For that item number, what was the average unit sales price? Please enter your answer with numbers only, to one decimal place. Use a simple
average for calculation. ✔️74.6
Instructions: See question 7.
Which sales rep had the lowest average sales price / unit? Use a simple average for calculation. ✔️Amy Adams
Instructions: See question 7.
What was that average sales price? Please enter your answer to one decimal place. Do not include any symbols. Use a simple average for
calculation. ✔️30.7
Instructions: See question 7.
Which item number had the greatest contribution to overall gross profit? Please enter your answer as a whole number only. ✔️5
Instructions: See question 7.
, What percentage of total gross profit did this item comprise? Enter as percentage as a number with one decimal place (e.g., 18.1% is entered as
18.1). ✔️8.3%
Instructions: Questions 28-30 use the data table on tab Q28-30 in the Exam Workbook(opens in a new tab).
How many companies in the S&P 500 list have a Market Cap of at least $20Bn AND Revenue of at least $15Bn? ✔️145
Instructions: See question 28.
How many constituents of the S&P 500 have a Market Cap of at least $30Bn OR Revenue of at least $17Bn? ✔️311
Instructions: See question 28.
How many constituents of the S&P 500 are listed on the New York Stock Exchange? Please enter your answer as a whole number only. ✔️386
Instructions: Questions 31-32 use the comp set on tab Q31-32 in the Exam Workbook(opens in a new tab). Answers should be rounded to the
nearest 1 decimal followed by an x to designate that it's a multiple. So if the answer is 14.765 you would input 14.8x.
What are the mean and median Next 12 Months PE Ratios of the group? Enter your answer as the mean multiple followed by the median
multiple, comma separated with no spaces. For example: 25.5x,15.8x ✔️19.9x
Question 32 ✔️10.7x
Instructions: Questions 33-37 use the data table on tab Q33-37 in the Exam Workbook(opens in a new tab). You will be asked to determine the
"Number of Items," and "Total Cost" for item classes. Total cost SHOULD be in currency format, rounded to the nearest whole dollar amount, so
if the answer is $500.78, you should input $501.
Enter the number of items and total cost for class "Buildings." Enter your answer as the number of items followed by total cost, comma
separated with no spaces. ✔️37,$184,800
Instructions: See Question 33.
Enter the number of items and total cost for class "Computers." Enter your answer as the number of items followed by total cost, comma
separated with no spaces. For example: 10,$200,000 ✔️36,$192,371
Instructions: See Question 33.
Enter the number of items and total cost for class "Equipment." Enter your answer as the number of items followed by total cost, comma
separated with no spaces. For example: 10,$200,000 ✔️30,$190,715
Instructions: See Question 33.
Enter the number of items and total cost for class "Tools." Enter your answer as the number of items followed by total cost, comma separated
with no spaces. For example: 10,$200,000 ✔️35,$255,113
Instructions: See Question 33.
Enter the number of items and total cost for class "Vehicles." Enter your answer as the number of items followed by total cost, comma
separated with no spaces. For example: 10,$200,000 ✔️22,$176,600
