Excel Crash Course [Wall Street Prep] Exam | Questions & Answers (Graded A+) | Latest 2024 Version

30. Instructions: Questions 30-31 use the comp set on tab Q29- 30 in the Exam Workbook. 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, 16.1x 31. What is the mean Next 12 Months PE Ratio for companies shown who also have a Price/Book Value greater than 2.0x? • 10.7x 32. Instructions: Questions 32-36 use the data table on tab Q32-36 in the Exam Workbook. 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 32. 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 34. 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 35. 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 36. 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