Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions