Computer App2

Lesson 1 – Excel Basics - due Fri, Mar 28Building Keyboarding and 10-key pad Skills /Moving and Displaying Data for spreadsheet files;


· Cell Entries and Formatting Cells

· Working with Ranges

· Creating Formulas

· Copying and Pasting



Directions: Complete the following assignments, either have signed by teacher or print and attach to sheet.

______ (5) Lesson 16.1 Create an in-basket #16 in your server space. Get teacher’s stamp._________________

______ (10) Lesson 16.2 Numeric Review Learn 10 Key Basics 3. | 10 Key Basics 4 | 10 key basics 5 | | Screen shot your results: (print screen, past into word document LEVEL________ and your SCORE _____________


________(10) Lesson 16.3 Alphabetic review. Go online to the FreeTypingGames.net game and play. Print screen on the end of your game to record the score.


________(10) Lesson 16.4 Exercise 9 Techniques for Moving Data

· Inserting and Deleting Columns and Rows

· Cutting and Pasting Data

· Using Drag-in-Drop Editing

· Project 17 (Create it) Working With Columns and Rows in the Payroll Worksheet EProj17 Client Account Tracking Worksheet

· Project 18 (Apply It) Moving and Copying Data in the Payroll Worksheet EProj18

_______(10) Lesson 16.5 Exercise 10 Chart, Sheet, Display, and Print Operations

· Creating a Column Chart

· Deleting Unused Sheets in a Workbook

· Displaying Printing, and Hiding Formulas

· Previewing and Printing a Worksheet

· Project 19 (Create it) Adding a Chart in the Balance Sheet Worksheet EProj19 Starting the Instructor Performance Ratings Worksheet

· Project 20 (Apply it) Reviewing and Printing the Balance Sheet Worksheet EProj20

________(10) Lesson 16.6 Punctuation Rules 1: Use of the Punctuation Marks: The Period Edit the sentences to make them correct. Highlight your changes with the yellow highlighter.

________(10) Lesson 16.7 Punctuation Rules 2: The Question Mark and The Exclamation Mark: Edit the sentences to make them correct. Highlight your changes with the yellow highlighter.

Chapter Assessment: next


_______ (10) Timeliness _______(10) Professionalism _______(85) Total