Reference no: EM132323195
Assignment Content
Purpose of Assignment
In this assignment, you apply Microsoft® Excel® formatting to a business example. You will use this skill to enter and analyze data using charts.
Assignment Steps
Read the following business scenario:
Your company has asked you to create a spreadsheet to analyze the following data. The data will be reviewed for top salespeople bonuses and commissions payments based on individual sales. Averages will be used to analyze month-over-month sales throughout the years.
Use the Sales Analysis Microsoft® Excel® spreadsheet and apply formatting to accomplish the following:
Calculate total sales using the SUM function.
Calculate total sales for each quarter. (March, June, and September each represent a quarter.). A quarter is three months.
Calculate average sales for each quarter to help determine 4th-quarter potential sales.
Highlight the top salesperson in each quarter.
Generate a Microsoft® Excel® chart or graph that displays the total sales by region to identify the highest and lowest selling regions.
Insert a hyperlink to the company's web page. (You can use any business web page for this example.)
Change your spreadsheet to a page or print layout view to be sure it fits well on a printed 8.5" x 11" sheet of paper.
Attachment:- sales analysis spreadsheet.rar
|
Cross-cultural research article submission
: Imagine you are asked to be on a panel as an expert cultural psychology consultant to discuss an international, credible news story
|
|
Consider if intervention may be unrealistic in your setting
: Consider if the intervention may be unrealistic in your setting, too costly, or there is a lack of appropriate training available to deliver the intervention.
|
|
How has emotional intelligence played part
: How has emotional intelligence played a part in your past when you might have lost your temper, cried, or showed other emotions you later regretted?
|
|
Describe and discuss the facility risk management program
: In this module you will discuss and critique the subject facility's Risk Management program. Describe and discuss the facility's Risk Management program.
|
|
Calculate total sales using the sum function
: Calculate total sales using the SUM function. Calculate average sales for each quarter to help determine 4th-quarter potential sales.
|
|
Identify two-three core strategies to retain these talented
: Identify the 2-3 core strategies to retain these talented and skilled high performers for years to come with your organization.
|
|
What defines public health as concept
: What defines public health as a concept, as well as a healthcare system operating in this country? What are the major goals for public health.
|
|
Several different levels-micro-mezzo and macro levels
: Social work practice occurs at several different levels: micro, mezzo, and macro levels. Support your assignment with at least three scholarly resources.
|
|
Description of recruitment or data selection strategies
: identification of your population sample and its required size, a description of recruitment or data selection strategies, and considerations of selection bias.
|