For this assignment, you will manipulate an Excel worksheet to

 

For this assignment, you will manipulate an Excel worksheet to organize and display data about sales totals throughout a year.

Download this Excel workbook (Links to an external site.). It already contains the data you need. Follow the directions, then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum.

  1. Open the workbook. Save it to the Rowan folder on your desktop as BA132_LastName_SalesData.xlsx, replacing “LastName” with your own last name. (Example: BA132_Hywater_SalesData) It is a good idea to save your work periodically.
  2. Format the data as a table with the name of the months and sales total as headers. You may use any table style you like.
    A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales.
  3. Change the cell format so that all the sales totals display as currency with a dollar sign and two decimal places.
    A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers.
  4. Indicate that the data for June and October needs to be verified by applying a different cell style to those cells.
    A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray.
  5. AutoFit the column width.
    A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray. The auto fit column width has been applied.
  6. AutoSum the total sales for the year.A Microsoft Excel sheet is open with content in cells A1 through B13. Cell A is representing months while cell B is representing total sales. All of column B has been formatted with dollar signs next to all of the numbers. The data in cells B7 and B11 have been highlighted in gray. The auto fit column width has been applied. In cell B14 a new value has been opened displaying the total sales for the year.
  7. Save your work and submit the workbook to Canvas.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Formal Analysis of Painting

Formal Analysis For the first part of your paper you will conduct an analysis of the artwork based entirely on your own observations and experiences of the work. You will look at the visual elements and principles of design (see Artforms and course presentations) and describe how they work together

Keep going! Expand your research and analysis. Add to your

  Keep going!  Expand your research and analysis. Add to your business idea.  Be sure to look at current real world data. This assignment must include: Your financial forecast (Is your project feasible?). Your operational plan (Is your project operational?). Identification of your competitors. Identification of your customers. Your marketing plan

Instructions You are a Human Resources Manager at Fly Eagles

Instructions You are a Human Resources Manager at Fly Eagles Fly, Inc., a company that makes custom sports jerseys for domesticated parrots. Draft a 1 page memo to the CEO of the company addressing the following: 1. Describe a discrimination issue facing your workplace (you can focus on discrimination based

Assignment Content Personal Statement. The role of the personal statement

  Assignment Content Personal Statement. The role of the personal statement is to make you stand out from others. Countless students list many similar qualifications, experiences, and goals. Creating a personal statement that is notable for its content requires preparation and planning. Personal statements need to be meticulously organized, well-written and

Dr. Megan Zobb, a key researcher within the North Luna

 Dr. Megan Zobb, a key researcher within the North Luna University Medical Center, has been studying a new variant of a skin disease virus that seems to be surfacing among the North Luna University population. This variant (which has been tentatively named Painful Rash or PR), leads to the formation

SABER COLLEGE Bariatric Surgery Definition Thoughts and Nursing Assignment Help

Topic: Bariatric Surgery Title page (APA format) Define Bariatric Surgery. What are your personal thoughts regarding Bariatric Surgery. Would you personally do it? Conclusion Expert Solution Preview You are a medical professor in charge of creating college assignments and answers for medical college students. You design and conduct lectures, evaluate

Topic is “wrongful and heavy sentencing in criminal justice” Research:

Topic is “wrongful and heavy sentencing in criminal justice” Research: use at least 4 sources (I provided 2 below that i selected, please use them) https://www.washingtonpost.com/opinions/2019/04/09/more-studies-showing-racial-disparities-criminal-justice-system/ https://news.harvard.edu/gazette/story/2020/09/black-latinx-people-overrepresented-in-massachusetts-prisons-study-says/ Content: Create a PowerPoint presentation that contains between 12 to 18 slides Title Slide (1 slide) – includes your name and the presentation

Identify an issue such as process that is causing concern

Identify an issue such as process that is causing concern or an opportunity for a positive change in a healthcare organization.Define the problem by Identifying and carefully describing what it is you really want to improve?Choose a target for improvement, and then describe two approaches for quality improvement that can

Your task is to describe an ethical issue that is

   Your task is to describe an ethical issue that is relevant to your work situation (past or current). The paper should focus on individual issues that you may face as an employee or manager. Your task is to describe an ethical issue and how it is impacting the organization.

A. Summary of the Case In one or two paragraphs,

 A. Summary of the CaseIn one or two paragraphs, provide a general overview of the case that serves as a snapshot of what the case is about and how it ended up in your state high court. A summary is using your words to write a brief history of the

1. What is work specialization? Discuss its advantages and drawbacks.

1. What is work specialization? Discuss its advantages and drawbacks. 2. Describe the characteristics, advantages, and disadvantages of a virtual organization at least 1.5 – 2 pages in length, Times New Roman 12-pt font, double-spaced, 1 inch margins and utilizing at least one outside scholarly or professional source related to

You Need to find an article which discusses recent developments

 You Need to find an article which discusses recent developments in the foreign exchange market and post it on the course’s assignment box. You also need to post a short summary (a paragraph) of the article. Good sources for articles are business magazines and newspapers (for example, The Economist, Business

Health Information Exchange in the Kingdom Create a PowerPoint presentation

Health Information Exchange in the Kingdom  Create a PowerPoint presentation that reviews four articles written in the last five (5) years on sharing patient information in a cloud-based Health Information Exchange (HIE) in the Kingdom of Saudi Arabia.  Your presentation should cover the following concepts: Discuss how data creates information

Depending on the organization’s strategic objectives, some metrics may be

Depending on the organization’s strategic objectives, some metrics may be considered more important than others. 1)   Give your opinion on how an organization should connect metrics with goals.  2)   Which do your think is a more useful operational metric, and why:  a patient day or adjusted patient day? 3)   Why

Many people find managing their money a difficult task. Their

Many people find managing their money a difficult task. Their use of credit cards and loans early in their adult years can prevent them from acquiring financial health in their lifetime. It is tempting to spend money you have not yet acquired once you are no longer a student trying

Instructions Course Objectives: Students will become familiar with business theories

  Instructions Course Objectives: Students will become familiar with business theories and approaches relating to various business environments (Domestic, Global, Technological, Political-Legal, Socio-Cultural, and Economic). Students will evaluate the business environments and practices of selected companies. Students will evaluate the business environments of a company identified as a “worst” company

Distinguish between global and multi-domestic strategies. Under what industry conditions

  Distinguish between global and      multi-domestic strategies. Under      what industry conditions will      each be appropriate?  What      are the advantages and disadvantages of vertical integration for a firm? Explain      why the best-run companies continually evaluate their strategies, rather      than waiting for the end of the quarter or fiscal year to engage in