Computer App2

Lesson 17 – Excel Basics due Friday, April 3

Building Keyboarding and 10-key pad Skills /Creating formulas for spreadsheet files;

  • Cell Entries and Formatting Cells
  • Working with Ranges
  • Creating Formulas
  • Using Excel Tables

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

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

______(10) Lesson 17.2 Numeric Review Learn the 10- key pad - Lessons 1 * Number pad – Lesson 1 Learn the numbers 1, 2, 3 (1-8 exercises)

______(10) Lesson 17.3 Alphabetic review. Go online to the FreeTypinggame.net game and play. Print screen on the end of your game to record the score.

_____(10) Chpt 17.4Exercise 13Working with the NOW Function and Named Ranges

  • Using the NOW Function to Display a System Date, Using Named Ranges
  • Lesson 13 Practice Add NOW function to add the system date and time to a cell using the skills you learned in this session.
  • Lesson 13 Apply It Add features to make your worksheet work faster, such as date updates, named ranges - Restoration Architecture

_____(10) Chpt 17.5Exercise 14Working with IF Functions

  • Understanding IF Functions, Nesting Functions, Using SUMIF and SUMIFs Functions, Using CountIF and CountIFs Functions and Using the AVERAGEIf Function
  • Lesson 14 Practice Use the IF Functions to perform calculations
  • Lesson 14 Apply - Various IF Functions and long with some new functions you have discovered. - Whole Grain Bread Store

______(20) Chpt 17.6Exercise 15Working with Text Functions

  • Using Functions Using the CONCATENATE Function, Using the UPPER and LOWER Functions, Using the LEFT, RIGHT, and MID Functions, Using the TRIM Functions
  • Lesson 15 Practice Using the Text Functions to reformat and manage text–Whole Grain Bread Store
  • Lesson 15 Apply It Use various Text Functions, to reformat worksheet - - Whole Grain Bread Store

_____(10) Chpt 17.7Exercise 16Using Frozen Labels and Panes

  • Freezing Labels While Scrolling, Splitting a Worksheet Into Panes
  • Lesson 16 Practice Freeze a row label. Stock Screener
  • Lesson 16 Apply It Freeze labels and divide the worksheet into panes – Voyager Travel Adventures

______(10) Lesson 16.6 Punctuation Rules 3: 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 4:The Question Mark and The Exclamation Mark: Edit the sentences to make them correct. Highlight your changes with the yellow highlighter.

______(10) Timeliness ______(10) Professionalism ______(95) Total