Excel Data Extraction
Not what you're looking for?
b. Filter the list and start the results in cell H6. You are to display sales which were greater than fifty-five units and whose per-unit price was no larger than $3.15 during 2005. Display in the body of the table the total sales for each salesperson.
c. Filter the list and copy to v2 to display those 2012 return were greater than the 2011 return and less than the 2013 return or in the top 20 % of 2014 returns.
Purchase this Solution
Solution Summary
The excel filtering feature and sub-totalling is demonstrated using three examples.
First solution shows, filtering a data list and to display sales which were greater than fifty-five units and whose per-unit price was no larger than $3.15 during 2005. Second slution displays the total sales for each salesperson.
Third soltuon shows the filtering the list to display those 2012 return were greater than the 2011 return and less than the 2013 return or in the top 20 % of 2014 returns.
Solution Preview
Dear Student,
Please find the solutions attached.
b. Solution is POST623096_Problem3_Solution.xlsx
By using the Filter feature, Data based on the criteria was selected.
Solution: POST623096_Problem3_Solution.xlsx
To Sub-total based on ...
Education
- BSc (Hons), University of Colombo - Sri Lanka
- MEngSc, University of Melbourne
- Certificate IV in Training & Assessment , Australian Business Council
Recent Feedback
- "Thank you!"
- "Thank you."
- "Thanks a lot for you help and support"
- "Sorry about the late payment but the assignment was sufficient and appreciated. Good work"
- "Great description! Thank you for your quick response."
Purchase this Solution
Free BrainMass Quizzes
C# variables and classes
This quiz contains questions about C# classes and variables.
Javscript Basics
Quiz on basics of javascript programming language.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic Networking Questions
This quiz consists of some basic networking questions.