Description

SpreadSheet Assignment, based on Lecture 6.1 Calculating Market Share Lecture 6.2 Calculating Rate of Change Lecture 6.3 Calculating Trend Lecture 6.4 Sum and Average FunctionsInstructionHello my spreadsheet rubric is attached it is based on the units below for college math SpreadSheet Assignment, based on Lecture 6.1 Calculating Market Share Lecture 6.2 Calculating Rate of Change Lecture 6.3 Calculating Trend Lecture 6.4 Sum and Average Functions

1 attachmentsSlide 1 of 1attachment_1attachment_1.slider-slide > img { width: 100%; display: block; }
.slider-slide > img:focus { margin: auto; }

Unformatted Attachment Preview

OAGN124  Financial Records
Instructions for Assignment
Create a cover page on the first sheet of your Excel file. Your cover page should include the following:
/2
/2
Sheet should be labeled Cover Page
/2
Cover page should match theme of rest of assignment
/2
/8
Add a second sheet to the assignment and recreate the following table exactly:
/10
Create a company and the products/services to sell. Come up with sales figures for 2016 and 2017
(remember to be reasonable with your figures as well as add both ups and downs in your sales from
2016  2017).
/10
Use the appropriate Excel formula to find the Total Sales for 2016 and 2017.
/6
Use the appropriate Excel formula to find the Rate of Change from 2016 to 2017.
/6
Use the appropriate Excel formula to find the Projected Sales for 2018.
/6
Use the appropriate Excel formula to find the Projected Sales for 2019.
/6
Use the appropriate Excel formula to find the Total Sales for 2018 and 2019.
/6
Use the appropriate Excel formula to find the Average Sales from 2016-2019.
/6
Use the appropriate Excel formula to find the Total Sales for each product from 2016-2019
/6
Use the appropriate Excel formula to find the Market Share for 2017.
/6
/48
Prof. Amy A Kranz
OAGN124  Financial Records
Formatting and Mechanics
Ensure each type of number is formatted correctly (eg. currency, per cents, etc.)
/3
/2
Table is aesthetically pleasing (designed nicely)
/2
No spelling or grammar errors
/2
File is saved as CompanyName_OAGN124_SectionNumber
/5
/14
Total: _____ / 90