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

Spreadsheet Applications 10%

Instructions for Assignment

Create a cover page on the first sheet of your Excel file. Your cover page should include the following:

Your name and student number

/2

The name of your company

/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

Titles and Headings formatted properly

/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

Profs Comments:

Sample Assignment: DO NOT COPY

Prof. Amy A Kranz

Purchase answer to see full

attachment

Tags:

economics

User generated content is uploaded by users for the purposes of learning and should be used following FENTYESSAYS.COM ESSAY’s honor code & terms of service.