Question 5 Instructions: Questions 5-19 use the data table on tab Q5-19 in the Exam Workbook. We strongly recommend you analyze this data 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 1 decimal, comma separating 000s, NOT written in currency format. So if the answer is $10,500.658, you would input 10,500.7. Over the entire analysis period, which sales rep sold the highest cumulative quantity of a single item?
Added by Joseph G.
Close
Step 1
Open the Excel workbook and navigate to the tab labeled "Q5-19". Show more…
Show all steps
Your feedback will help us improve your experience
Supreeta N and 82 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Make the following calculations in each of the two worksheets without grouping the sheets: • In cell B4, enter a function to sum the Quantity in Stock data and then apply Comma Style with zero decimal places to the result. • In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format.
Akash M.
Refer to Figure 1. What formula should be entered in cell E4 to compute total profitability? A) =SUMPRODUCT(B5:C5,B2:C2) B) =SUM(B3:C3) C) =B2*B5 + C2*C5 D) =SUMPRODUCT(B5:C5,E8:E10) E) =B3*B5 + C3*C5 Use this information to answer the following questions.
T. L.
When using a Pivot table with a variable that has "ordinal measurement," you may have problems. The Pivot Table sorts values from smallest to largest counts. The Pivot Table will sort labels alphabetically. You cannot display % of Row or Column Total with ordinal variables. You cannot use Filters with ordinal variables.
Md.Daniyal A.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD