Create a spreadsheet that clearly displays numerical data

Assignment Help Business Management

Reference no: EM133835047

Assignment: Business

Overview

As you prepare to communicate the next steps in the consulting partnership between your organization, Business Consultants, and your client, New Hampshire Business Products, you will prepare three deliverables using office productivity applications. For Milestone Two, you will prepare a draft of your second deliverable: a Microsoft Excel spreadsheet. You will create a dynamic spreadsheet that will allow you to organize and manipulate the given sales data with basic automatic calculation functions.

Prompt

Using Excel, create a spreadsheet that clearly and functionally displays the numerical data provided in the project scenario.

Specifically, the following critical elements must be addressed:

Spreadsheet: Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario.

A. For current sales, display sales by category and total.

B. For projected sales, display sales by category and total.

C. Apply formatting conventions appropriate for a business audience.

a. Select a consistent font and font size.
b. Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
c. Apply labels that identify the values contained in each row and column.

D. Apply formulas to calculate totals for current sales as well as projected sales.

E. Embed a bar chart that accurately displays the total sales for the current year.

F. Embed a bar chart that accurately displays the projected sales for the next five years.

G. Embed a line graph that accurately displays the projected sales growth over the next five years.

Reference no: EM133835047

Questions Cloud

Describe the equal protection clause : Describe the Equal Protection Clause of the 14th AmendExplain that this clause requires states to treat individuals in similar situations equally under the law.

How it supports the development of nursing knowledge : Discuss the components of the Conceptual-Theoretical-Empirical structure and how it supports the development of nursing knowledge. Provide references.

How do you rank the importance of each of four principles : Based on your worldview, how do you rank the importance of each of the four principles in order to protect the health and safety of diverse populations?

Spread misinformation about prison conditions : which could potentially incite unrest or spread misinformation about prison conditions.

Create a spreadsheet that clearly displays numerical data : Create a spreadsheet that clearly and functionally displays the numerical data provided in the scenario. For current sales, display sales by category and total.

Describe how your business will be structured : FDY3005 Becoming an Effective Leader, Arden University - Describe how your business will be structured and explain why this is the best structure

Strategies address both operational and legal risks : An inmate advocacy organization has threatened to file a lawsuit. How might these strategies address both operational and legal risks?

Draw a cause-and-effect diagram based on the problem of case : MGT 312- Discuss the problem with 5-Why analysis. Draw a cause-and-effect diagram based on the problem of the case?

Discuss five factors that influence what you eat : Explain what an enriched food, fortified food, and organic food is. Discuss five factors that influence what you eat. Explain the concept of kcalories.

User Account

All Pages