Question
hi could you plz explain this question and helpe with the answer Data download: LP2.2AssignmentDataFile.xlsx Background Information: For this assignment, we are going to complete
hi could you plz explain this question and helpe with the answer
Data download: LP2.2AssignmentDataFile.xlsx Background Information: For this assignment, we are going to complete some advanced sorting and filtering based on 3 salespeople in 3 regions. The workbook that you need to download contains 1 worksheet. You will need to work with this data in three different worksheets. Complete the following with each of the worksheets (10 pts each). The end solution is provided. Make sure to match what is shown: Worksheet 1 (Conditional Formatting-Sorting)
Conditionally format the bottom 10% of the sales units. (2 salespeople).
Sort based on these bottom 10% at the top
Worksheet 2 (Cell Attribute-Filter)
Conditionally format the sales units that are greater than 1000. (5 salespeople).
Filter by the format that you applied in #1.
Worksheet 3 (Number-Filter)
Conditionally format the sales units by the top 10 items. (10 salespeople).
Filter by the top 5 items.
Save your work and upload all 3 worksheets in the dropbox.
Instructions:
Reflect on one of these concepts addressed in this module:
Identify nonverbal clues the customer gives that indicate a potential problem exists and calm the customer with nonverbal action
Identify nonverbal cultural differences and use these differences to enhance communication
Match body language to oral communication
Share a concept or an activity that stood out to you and explain why.
Please post a 3-4 sentence response on the Discussion forum and respond constructively to at least two other posts. Please avoid responding to your classmates' posts to thank them for posting; instead, comment on a specific point they made, share your perspective or ask a question in response.
This graded discussion is worth 2.5% of the final grade in this course. It will be graded using this grading rubric.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started