NEED A PERFECT PAPER? PLACE YOUR FIRST ORDER AND SAVE 15% USING COUPON:

4.8/5

Rogers State University Wang Mobile Concepts Yearly Sales Worksheet

Rogers State University Wang Mobile Concepts Yearly Sales Worksheet.

Need help with my Computer Science question – I’m studying for my class.

All you need to do is follow the instruction below

This lab assumes you are using MS Excel 13 or above. You may use a higher version; however, be aware that there may be slight changes in the different versions. If your submission does not work in MS Excel 13 or above, it is considered non-functioning and you will receive a zero.

Grading Rubric

TOTAL: 20 points

  • Part A: 18 points
    • (1 pt) Cell A2: contains “<Last Name> Mobile Concepts” and cell A3 contains “Yearly Sales”       
    • (1 pt) Cells B4, C4, D4 and E4, contain the product titles
    • (1 pt) Cells A5, A6, A6, and A8 contain states 
    • (1 pt) Sales Figures entered into the  correct location
    • (1 pt) “Total” in cell F4 and A9
    • (1 pt) Formulas use the SUM function to determine the total revenue for each state 
    • (1 pt) Formulas use the SUM function to determine total revenue for each of the four packages
    • (1 pt) Calculates  grand total for the entire company.     
    • (1 pt) Title in cell A2 and subtitle in cell A3 formatted as requested
    • (1 pt) Name in cell A11
    • (1 pt) Cell A12 contains the formula: =cell(“filename”)    
    • (1 pt) Product names formatted with Heading 2 cell style and centered
    • (1 pt) Range A5:F8 formatted with with the 20% – Accent6 cell style
    • (1 pt) B5:F5 and B9:F9 formatted with the accounting number format.
    • (1 pt) B6:F8 formatted with the comma style format.
    • (1 pt) A9:F9 formatted with the Total cell style.
    • (1 pt) Changed the name of the sheet1 tab to “Yearly Sales”
    • (1 pt) Applied the Orange color to the sheet tab. 
  • Part B: 2 points
    • Follows requested project submission format

Guidelines and Policies

Getting Help

If you have a question, please post on Piazza, and we will answer as quickly as possible. We will try to answer questions and provide help within 24 hours of your request. If you do not receive a response in 24 hours, please send the request again.

Although we will answer questions, provide clarification, and give general help where possible up until the deadline, we will not help you with your submission within 24 hours of the deadline. We will not provide any help after the deadline.

Guidelines

This is an individual lab assignment. You must do the vast majority of the work on your own. It is permissible to consult with classmates to ask general questions about the assignment, to help discover and fix specific bugs, and to talk about high level approaches in general terms. It is not permissible to give or receive answers or solution details from fellow students.

You may research online for additional resources; however, you may not use material that was written specifically to solve the problem you have been given, and you may not have anyone else help you write the material or solve the problem. You may use resources found online, providing that they are appropriately and clearly cited, within your submission.

By submitting this assignment, you agree that you have followed the above guidelines regarding collaboration and research.

In this lab, you will learn to:

  • Work with the MS Excel
  • Create a Spreadsheet

Creating a Spreadsheet
(Derived from Excel Workbook, Module 1, Exercises 55&56)

  1. Create a blank Microsoft Excel spreadsheet
  2. In cell A2, enter “<Last Name> Mobile Concepts”
    1. Replace <Last Name> with your last name  
  3. In cell A3, enter “Yearly Sales”       
  4. In cells B4, C4, D4 and E4, enter the product titles:
    1. Alarm
    2. Audio
    3. Light
    4. Ultimate
  5. In cells A5, A6, A7, and A8, enter the regions (states): 
    1. California
    2. Nevada
    3. Oregon
    4. New York       
  6. Fill in the sales figures by copying (or cut and pasting) from the following table:

Alarm

Audio

Light

Ultimate

California

860,358.71

431,758.35

375,708.22

786,253.39

Nevada

345,024.13

863,814.87

500,255.40

272,220.20

Oregon

396,157.67

326,159.07

247,826.28

511,277.11

New York

395,428.36

804,908.29

383,514.73

342,965.38

  1. Add the title “Total” in cell F4, and create formulas using the SUM function to determine the total revenue for each state. 
  2. Add the title “Total” in cell A9, and create formulas using the SUM function to determine total revenue for each of the four packages, as well as a grand total for the entire company.       
  3. Format the Title in cell A2 and subtitle in cell A3 as follows:
    • Merge cells A2:F2 and A3:F3 and center the result 
    • Apply the Title cell style
    • Format as 18-point Arial Black.
    • Format with Green, Accent 6 font color. 
  4. Type your name in cell A11
  5. In cell A12, type the text: =cell(“filename”)    
  6. Format the product names in B4:F4 with the Heading 2 cell style and center the text in the cells.
  7. Make the following changes to the data:
    • Format the range A5:F8 with the 20% – Accent6 cell style
    • Format cells B5:F5 and B9:F9 with the accounting number format.
    • Format cells B6:F8 with the Comma style format.
    • Format the range A9:F9 with the Total cell style.
      1. If necessary, resize all columns to fit the data.
  8. Change the name of the sheet1 tab to “Yearly Sales”
  9. Apply the Orange color to the sheet tab.
  10. Save the Spreadsheet using the file name, “Lab 3-<Last Name>.xlsx.
    • Replace <Last Name> with your last name 

Submission

  • Required code naming and organization:
    • Lab3-lastname.xlsx

Every lab will have required submission guidelines. Please read submission requirements carefully. Any deviations from specifications on future labs or projects will result in significant point deductions or incomplete grades.

Submit this file on MyCourses. To do so, go to:

  • CS-105 > Assignment Submission > Lab 3
  • Attach your file and submit
  • You may submit as many times as you like until the deadline. We will only review your final submission.

Rogers State University Wang Mobile Concepts Yearly Sales Worksheet

Solution:

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.

WhatsApp us for help!
%d bloggers like this: