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

Overview It is important to understand yourself as a leader

  Overview It is important to understand yourself as a leader and how you fit into an organization. In this journal assignment, you will discuss your individual experience with organizational culture and how it has impacted communication and leadership within an organization you are familiar with. This could be an

Select your topic: Select a disorder/disability from the textbook which

   Select your      topic: Select a disorder/disability from the textbook which interests you      or with which you feel called to work.  Conduct      your research: Using resources at the Jerry Falwell Online Library select      at least 10 peer-reviewed/scholarly journal articles published within the      past 5 years. Choose resources that address the

Do you think governments should consider human rights when granting

  Do you think governments should consider human rights when granting preferential trading rights to countries? What are the arguments for and against taking such a position? Submission Instructions: Your initial post should be at least 200 words with at least 2 academic sources  Please post your initial response by 9:00

Week 2 Discussion 2 As you read this week’s assignments,

  Week 2 Discussion 2 As you read this week’s assignments, examine your own beliefs about the student–faculty relationship and discuss the effects that your beliefs and practices may have on the teaching-learning process, the academic performance of your students, and your students’ behavior. What are your beliefs about interactions

Assignments and Rubrics: Week 8: Assignment 2: Entrepreneurial Opportunities Plan

Assignments and Rubrics: Week 8: Assignment 2: Entrepreneurial Opportunities Plan Part 1 Instructions We’ve been discussing the impact of unscaling on the future economy and the many opportunities that one can take advantage of as an entrepreneur. The purpose of the Entrepreneurial Opportunities Plan is to pinpoint and identify some

You will be taking on the role of an associate

   You will be taking on the role of an associate director of a hospital who is considering the proposed opening of an urgent care clinic about 20 miles from your main campus. You have been charged with gathering demographic information that might affect the demand for the new clinic

Instruction for the CPT Paper – Working as Java Developer

Instruction for the CPT Paper – Working as Java Developer- Current Course: BUS ETHICS & SOCIAL RESPONSIBILITY The CPT paper is a minimum of 750 words in length, written in APA format including references and citations.  Select a concept or theory covered in one of your current courses.  Apply this

Middle Range Theory: Dorothy Johnson’s Behavior System Model Nursing Assignment Help

Middle Range Theory:Dorothy Johnson’s Behavior System Model on the Population of Substance UsersLeana Snyder, Emma Cuccurullo, Jenna Rosenfeld, and Charlyn Humes Adelphi University College of NursingNur 602-01 Frameworks for Advanced Nursing PracticeOctober 25, 20231AbstractNursing theories and models play a pivotal role in terms when it comes to a better understanding of nursing care. Dorothy Johnson developed

Week 5 Discussion Forum 1 – Addressing minority over-representation in

 Week 5 Discussion Forum 1 – Addressing minority over-representation in the Juvenile Justice System No unread replies. No replies. The minority over-representation in the juvenile justice system has challenged us to be creative in developing strategies to achieve proportional representation. What do you think is driving these numbers? What would

Assignment: Write a literary essay (1,000-1,200 words) based on the

PLEASE DO NOT USE OUTSIDE RESEARCH FOR THIS PAPER. I WANT YOUR IDEAS SUPPORTED WITH QUOTES FROM THE MEMOIR.   Develop a thesis that answers ONE of the following questions and APPLY ONE OF THE LENSES FROM THE” LENSES FOR READING LITERATURE” HANDOUT:   1) How does the author use

BUSINESS INTELLIGENCE – hard skills

Assignment (50% of module mark): Individual Assessment – This is an individual assignment which include developed Excel dashboard and 2000-word report. You have been appointed as a Business Analyst in charge of Newcastle United Football Club (FC) performance review. You are expected to submit a report that will critically appraise

Temporary vs. Permanent Employee Debate

 Write a discussion paper opposing the use of temporary employees in the workforce. The purpose is to argue the case against the use of temporary employees. You should consult some of the research regarding the impact of not using temporary employees in organizations. There is plenty of literature out there

Creating a project charter document

earning Connection: This assignment is directly linked to the following key learning outcomes from the course syllabus: Using real world examples of projects, demonstrate an ability to manage critical components of the Initiating process group by: a. Creating a project charter document b. Preparing a scope statement c. Evaluating why

Educating the Patient diagnosed with COPD

 In October 2014, the Centers for Medicare and Medicaid Services expanded readmission penalties to include those patients admitted with an exacerbation of COPD. Patient education is a key component in preventing readmission. Initial Discussion Post: What is a priority teaching intervention that the nurse must implement for these patients and

Patient Protection and Affordable Act Analysis Nursing Assignment Help

Locate a recent peer-reviewed article from a health care journal that reports on how well the Patient Protection and Affordable Care Act (PPACA) is working. You can use the CTU online library and course reading materials to locate sources of articles about the PPACA. Provide an analysis of whether or

You are reading Augustine, Anselm, Aquinas, et al. this week.

You are reading Augustine, Anselm, Aquinas, et al. this week. There is no bigger journey outside of ourselves than the search for something to believe in. Do some inward contemplation and questioning of what you believe (I won’t tell your grandma!). The purpose of this discussion is to share and not

Crisis in Theatre: Examining two of the core syllabus plays, discuss

1.Examining two of the core syllabus plays, discuss how contemporary playwrights have conveyed the urgency of current or impending social crises through formal experimentation and argue as to the effectiveness of their representational methods. 2.A number of the plays we are examining highlight the concern of mental health crisis. Drawing