The purpose of this hands-on project is to give students an opportunity to create an electronic spreadsheet and a chart (CLO 4, MLO 4.1)

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

The purpose of this hands-on project is to give students an opportunity to create an electronic spreadsheet and a chart (CLO 4, MLO 4.1), and apply formulas and functions to an electronic spreadsheet (CLO 4, MLO 4.2). To do this, use the Technology for Success textbook, along with the video tutorial(s), to complete the Excel Project.

1. Complete Excel Module 1: Creating a Worksheet and a Chart, pages EX 1-1 - EX 1-65. Turn in a single screenshot of the worksheet and chart, each on a single page. 2. Complete Excel

Module 1: Apply Your Knowledge, Changing the Values in a Worksheet (Delton Discount), pages EX 1-66 - EX 1-67. Be sure to follow the instructions as directed and turn in a single screenshot of the worksheet and chart, each on a single page. 3. Complete Excel Module 2: Formulas, Functions, and Formatting, pages EX 2-1 - EX 2-49. Turn in 3 screenshots (worksheet, worksheet section, worksheet formulas, each on a single page). 4. Complete Excel Module 2: Apply Your Knowledge, Cost Analysis Worksheet (Prontix Courier Service), pages EX 2-50 - EX 2-51. Be sure to follow the instructions as directed and turn in 2 screenshots in worksheet and worksheet formulas view, each on a single page. 5. Attach and submit your completed project (which should be a single Word document with word processing and/or screenshots of all assignment components, labeled and in order) by the assigned due date. Customizations: Module 1: Change "Frangold" to your last name Module 1, Apply your Knowledge: Change "Delton" to your first name

Module 2: Change "Klapore" to the last name of a president Module 2, Apply your knowledge: Change "Prontix" to the name of your favorite place to visit Excel Project Assessment Assignment Components Possible Points Excel Module 1 Spreadsheet formatted correctly Appropriate use of formulas All totals are accurate Chart formatted correctly One page each 25 Excel Module 1, Apply Your Knowledge Spreadsheet formatted correctly Appropriate use of formulas All totals are accurate Chart formatted correctly One page total 25 Excel Module 2 Spreadsheet formatted correctly Appropriate use of formulas All totals are accurate Worksheet, section, formulas views included, one page each 25 Excel Module 2, Apply Your Knowledge Spreadsheet formatted correctly Appropriate use of formulas All totals are accurate Worksheet and formulas views included, one page each 25 Total Points Possible 100

 

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of