IT 100 Milestone Two Guidelines
IT 100 Milestone Two Guidelines and Rubric
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 final project scenario.
Specifically, the following critical elements must be addressed:
II. 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.
1. Select a consistent font and font size.
2. Format the spreadsheet with row and column spacing, row and column alignments, and cell formatting.
3. 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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
