User Account

All Pages

Calculate total sales using the sum function

Assignment Help Other Subject
Reference no: EM132323347

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.

Submit your assignment.

Used with permission from Microsoft

Attachment:- Sales analysis spreadsheet.rar

Reference no: EM132323347

Questions Cloud

Examine potential changes in it related : Examine potential changes in IT related to innovation and organizational processes.
What would be the reason the given may occur : As we concluded the mood disorders we addressed suicidal behavior. This topic and the general topic of self-abusive behavior is often of interest and concern.
Define how you became afraid of heights : Write a 700 word paper describing an informal learning experience you have had. You may describe, for example, how you became afraid of heights.
Analyse the feasibility of your product and business idea : FC010 - Business Enterprise-Kaplan International College London-Analyse the feasibility of your product and business idea from the perspectives of production.
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.
Describe how you would do a needs assessment : Describe how you would do a needs assessment to determine the need for such a program. Would you use quantitative or qualitative tools? Why?
What were the patterns of crime and punishment : In the period just before the American Civil War those in the U.S. criminal justice system were focused on the ability to handle those who had been deemed.
Write definition of domestic terrorism : Post your definition of domestic terrorism. Describe two examples of domestic terrorism during the Civil War. Explain how these examples relate to domestic.
Define what we perceive to be reality : Neo wakes up and asks Morpheus why his eyes are hurting, to which Morpheus answers that his eyes hurt because he has never used them before.

Reviews

Write a Review

Other Subject Questions & Answers

  What are the lessons learned

Read about the Measure and Pivot or (Persevere)" chapters from the Lean Startup" book for Eric Ries. You need to write with your style your own brief summary.

  Explain the concept of parens patriae

Give an overview of the early history of juvenile justice and how it came to be formed in the United States.  Explain the concept of "parens patriae." Compare and contrast the four models devised by the juvenile justice system to deal with youth crim..

  How did the american court system develop

How did the American court system develop. What is the dual-court system. Why do we have a dual-court system in America

  Does power corrupt automatically

Does power corrupt automatically? Apply this famous expression to the events and characters in Macbeth.

  Describe the teens and risky behaviors

HSC4021/PHE4055 Conduct an analysis on the basis of research and readings you have done during the course on the following topics that clearly depicts.

  Explain what is meant by safe system of work

Explain what is meant by safe system of work (ii) What are the factors to be considered when developing a safe system of work? (iii) What are the benefits of doing a Job Safety Analysis? (iv) List the factors to be considered when setting a ..

  Did ralston have a valid claim

Ralston was injured when she fell down a church stairway. Matthew, agent for the company that insured the church, promised Ralston that the insurance company.

  Discuss community justice and criminal justice

Community Justice is a relatively new philosophy of justice that differs significantly in some respects to criminal justice

  How might your weaknesses interfere with the helping process

In this unit's studies, you took several self-assessment inventories presented in readings from Issues and Ethics in the Helping Professions.

  What is the purpose of a surveillance system

What is the purpose of a surveillance system and Provide two examples of surveillance systems (from your residential state) Georgia

  Define the roles and responsibilities of any department

One of the first tasks in the development of any department is to define the roles and responsibilities of the members of the department. This information will be vital to the staffing and assignment of tasks within the department once it is up an..

  According to demographers what factors lead to a decline

all countries have moved through all 4 phases of the demographic transition.you are a consultant for a developing

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd