for this assignment you will create several spreadsheets in an excel workbook and demonstrate different functions read all the instructions in this module item and view the required tutorials before you begin if you are familiar with functions used in #1 Essay Answers

for this assignment you will create several spreadsheets in an excel workbook and demonstrate different functions read all the instructions in this module item and view the required tutorials before you begin if you are familiar with functions used in #1 Essay Answers  – #1 Essay Answers 

To prepare, use the directions as follows:

• Read Excel Formulas and Functions (PDF).
• View the videos # 1, 3-10, and 13-16 in the playlist Microsoft Excel 2016 (YouTube). (Links to an external site.)
  • Viewing other titles is optional.
• Need Excel? Go to the Productivity Software page.

Your workbook requirements are as follows:

• Label all values and name the worksheet tabs.
• Apply formatting such as bold text, colors, etc. as appropriate.
• Save your workbook in .xlsx format.
• • 1. Create a new spreadsheet that contains three separate data sets. Place each dataset onto its own worksheet. Example lists of datasets are the following:
       1. Temperature of your city for the past 5-10 days
       2. Scored points per game of your favorite sports team for their past 5-10 games
       3. Amount you paid for gas for the past few months
       4. Miles flown/driven per day/trip etc. for the past month
       5. Most anything else you can tabulate or can track
    2. Use at least four different functions (e.g. SUM, MAX, AVERAGE, MIN, COUNT, etc.) to summarize each data set. You choose which to use, but be sure each worksheet has at least four. It is acceptable if the functions are common between the three sheets.

    Rubric

    CSCI 109 Module 4 Assignment Rubric

    CSCI 109 Module 4 Assignment Rubric

    Criteria	Ratings	Pts
    This criterion is linked to a Learning Outcome Part 1: Three separate data sets	10.0 pts Proficient 7.0 pts Competent 5.0 pts Developing	10.0 pts
    This criterion is linked to a Learning Outcome Part 1: Each data set on its own worksheet	10.0 pts Proficient 7.0 pts Competent 5.0 pts Developing	10.0 pts
    This criterion is linked to a Learning Outcome Part 1: Four different functions used with each data set (example: SUM; AVERAGE; MAX; MIN)	20.0 pts Proficient 14.0 pts Competent 10.0 pts Developing	20.0 pts
    This criterion is linked to a Learning Outcome Part 1: All values labeled	10.0 pts Proficient 7.0 pts Competent 5.0 pts Developing	10.0 pts
    This criterion is linked to a Learning Outcome Part 2: Correct function used: PMT	20.0 pts Proficient 14.0 pts Competent 10.0 pts Developing	20.0 pts
    This criterion is linked to a Learning Outcome Part 2: Interest and term correctly represented	20.0 pts Proficient 14.0 pts Competent 10.0 pts Developing	20.0 pts
    This criterion is linked to a Learning Outcome Part 2: Use of cell references in calculation	10.0 pts Proficient 7.0 pts Competent 5.0 pts Developing	10.0 pts

• • On another sheet of the same file, create a worksheet that contains data and a calculation determining monthly payments for a proposed purchase. Include the following:
  • Identify your dream vehicle (plane, automobile, boat, etc.) and estimate its cost and the interest rate if you financed its purchase.
  • Enter data (loan amount, interest rate, term, etc.) onto the spreadsheet and use the PMT function and cell references to determine the monthly payments.

  • Important! The spreadsheets must be original (student created) for this assignment; recycled files and templates are not permitted. Start with a new worksheet and create from scratch.

  Rubric

  CSCI 109 Module 4 Assignment Rubric

  CSCI 109 Module 4 Assignment Rubric

  Criteria	Ratings	Pts
  This criterion is linked to a Learning Outcome Part 1: Three separate data sets	10.0 pts Proficient 7.0 pts Competent 5.0 pts Developing	10.0 pts
  This criterion is linked to a Learning Outcome Part 1: Each data set on its own worksheet	10.0 pts Proficient 7.0 pts Competent 5.0 pts Developing	10.0 pts
  This criterion is linked to a Learning Outcome Part 1: Four different functions used with each data set (example: SUM; AVERAGE; MAX; MIN)	20.0 pts Proficient 14.0 pts Competent 10.0 pts Developing	20.0 pts
  This criterion is linked to a Learning Outcome Part 1: All values labeled	10.0 pts Proficient 7.0 pts Competent 5.0 pts Developing	10.0 pts
  This criterion is linked to a Learning Outcome Part 2: Correct function used: PMT	20.0 pts Proficient 14.0 pts Competent 10.0 pts Developing	20.0 pts
  This criterion is linked to a Learning Outcome Part 2: Interest and term correctly represented	20.0 pts Proficient 14.0 pts Competent 10.0 pts Developing	20.0 pts
  This criterion is linked to a Learning Outcome Part 2: Use of cell references in calculation	10.0 pts Proficient 7.0 pts Competent 5.0 pts Developing	10.0 pts
  Total Points: 100.0

Place Order Now 

We have a team of Assignment experts who are the leading assignment help providers in the worldwide platform. We have university assignment expert who help the students in the best possible manner. At Google, there are many service providers as well that might not be reliable and do not guarantee money-back. But our assignment help service company is legal and reliable and provides plagiarism-free work without any cheating. Each company has its formats of submitting the assignments and placing the order. The assignment's subject, topic, and deadline need to be provided to the service providers. Based on the following documents, the price is quoted and approved. The experts are often called academic writers who all possess extensive knowledge and experts in the field. The services of academic writings include custom help in essay writing, term paper, coursework, homework assignments, research writings, dissertation, and many more.

Step-by-step solutions. Top grades guaranteed.