Spreed Sheet Assigment

Week # 2 - Chapter # 1 Assignment

This week we cover the Level 1 and 2 of Chapter One of your textbook. Before you start on the Excel exercises be sure to read and make sure you understand the Chapter Introduction and VERY IMPORTANT, the Case Scenario on page 23. You have three sources of information:

a) The Book b) The Videos with the learning part of the Level-Chapter c) The Presentation that is available WATCH THE VIDEOS-- WATCH THE VIDEOS -- WATCH THE VIDEOS.

Let us get started: ==========================================================================================

Week # 2 - Chapter # 1 Assignment

Level 1: Objectives

• Define common Excel error messages • Correct basic formatting problems in a worksheet • Correct errors in formulas • Understand precision vs. display of cell values

LEARNING

Starting on 23 of your textbook. You should read the learning material covered on pages 23-41 and the video tutorial for this level.

PRACTICE & Apply

Using the Week # 2 - Chapter 1 – Exercises.pdf Make the Exercise 1-1: Level 1 – Purchasing a Computer for Durban & Associates

Post your completed file to Blackboard for review and grading. The file Name should be 1-1-Computer-Purchase-YourName.xlsx. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (40 POINTS)

==================================================================

Week # 2 - Chapter # 1 Assignment

Level 2: Objectives

• Work with multiple worksheets • Calculate total, average, minimum, and maximum values with functions • Understand how functions work: syntax, arguments, and algorithms • Use the AutoSum feature to perform calculations quickly • Calculate the number of values using both COUNT and COUNTA

LEARNING

Open CH01 Level 2 Figures.xlsx This file is the same as the figures in your textbook for Level 2 Starting on 43 of your textbook. You should read the learning material covered on pages 43-51 and the video tutorial for this level.

PRACTICE & Apply

Using the Week # 2 - Chapter 1 – Exercises.pdf Make the 1-2-Job-Analysis2-Your-Name.xlsx

Post your completed file to Blackboard for review and grading. The file Name should be 1-2-Job-Analysis2-Your-Name.xlsx. POST A COPY OF YOUR WORK TO BLACKBOARD FOR REVIEW AND GRADING (40 POINTS)

Week # 2 - Chapter # 1 Assignment

Let me know if there is anything you don't understand -- the earlier the better. ALWAYS attach a copy of yours excel file clearly indicating where you have a problem.

The solution files that you need to attach are: 1-1-Computer-Purchase-YourName.xlsx 1-2-Job-Analysis2-Your-Name.xlsx

After you understand the material and complete the exercises: Answer the questions in the Practical Test – Chapter# 1 (20 POINTS)