COMPUTER LITERACY ASSIGNMENTS

BEGIN EXCEL

Lesson 1 (Exercises 1-6)

DAY 1

Type the terms for Lesson 1 (Exercises 1-6)

Do Exercise 1 Excel Basics, Learn the Excel Window Screen Elements, Use the Menus and Toolbars, and Work with the Mouse and Keyboard.

Read and take notes over pages 183-185.

DAY 2

Do Exercise 2 Create a New Workbook, Make Simple Corrections, Work with Labels, Use the View Menu, and Save and close a Workbook. Staple OXL02 to the top of XL02.

Read and take notes over pages 187-189

Do not forget name, date, hour, and label (OXL02 & XL02). Also, write what it is on top. Ie. Monthly Sales Report and Monthly Expense Budget. In addition, be sure to write what you learned.

DAY 3

Do Exercise 3 Use the AutoComplete and Pick From List Features, Understand the AutoCorrect Feature, Work with Data in a Worksheet, Use Undo and Redo, and Check Spelling in a Worksheet. Staple OXL03 to the top of XL03.

Read and take notes over pages 191-193.

Do not forget name, date, hour, and label (OXL03 & XL03). Also, write what it is on top. Ie. Assignment and Projects Report and Billings Report. In addition, be sure to write on what functions you used.

DAY 4

Do Exercise 4 - Enter Numeric Labels and Values, Change Label Alignment, Use Column Width to Accommodate Data, and Work with Indents. Staple OXL04 to the top of XL04.

Read and take notes over pages 195-197.

Do not forget name, date, hour, and label (OXL04 & XL04). Also, write what it is on top. Ie. Inventory. In addition, be sure to write on what functions you used.

Do Exercise 5 - Integrate an Excel Worksheet and a Word Document and Work with Data from the Internet. Staple OXL05 to the top of XL05.

Read and take notes over pages 199 & 200.

Do not forget name, date, hour, and label (OXL05 & XL05). Also, write what it is on top. Ie. Memo with stock quotes, CD Wish List. In addition, be sure to write on what functions you used.

DAY 5

Exercise 6 - REVIEW LESSON (PRACTICE TEST)

Take notes on your notes. (Study for your Terms and Application test)

Terms and Application test over Lesson 1 tomorrow!

DAY 6

Terms and Application test over Lesson 1-EXCEL

BEGIN LESSON 2 EXCEL

Exercises 7-12

"Entering Formulas and Formatting a Spreadsheet"

DAY 7

Type the terms for Lesson 2 (Exercises 7-12)

Do Exercise 7 - Formula Basics- Reminder: cell references NOT cell values are entered into a formula. Within a formula (A5+B5)*C5 the addition within the parentheses will be calculated before the multiplication. In this example A5+B5*C5 the multiplication will be calculated before the addition.

Staple XL07 to the top of OXL07 and write what it is and what you learned and formulas used. Always..Name, Date, Hour. & File Name.

TIP:

+ = addition

- = subtraction

* = multiplication

/ = division

^ = exponentiation

Read and take notes over pages 205-207.

DAY 8

Do Exercise 8 - Open existing files, save and close a worksheet, use Excel's virus-checking features, and work with ranges

Staple XL08 to the top of OXL08 and write what it is and what you learned. Always..Name, Date, Hour. & File Name.

TIPS: Be sure to turn off the backup feature after completing the exercise.

Remember to click the column letter to select the entire column (all 65,536 rows).

Read and take notes over pages 205-207.

DAY 9

Do Exercise 9 - enhance data with different formats and work with fonts and font sizes

Staple XL09 to the top of OXL09 and write what it is and what you learned. Always..Name, Date, Hour, & File Name.

TIPS: When font size is increased and the column is too narrow to display the numbers, pound signs (####) display in the cell.

Once a cell or range of cells is selected, formatting changes can be applied.

To select columns b-f, drag the mouse across the column letters b through f to select all the cells in the columns.

Remember to use the "Select All" button so that the font change can be made for the entire worksheet (even cells not yet filled).

Read and take notes over pages 212-215.

DAY 10

Do Exercise 10 - Copy and paste data and formulas and printing an open worksheet.

Staple XL10 to the top of OXL10 and write what it is and what you learned. Always..Name, Date, Hour, & File Name.

TIPS: relative cell referencing is when a formula is copied from one cell to another, it automatically adjusts. For example, =B4+B5 in column B would become =C4+C5 when copied to column C.

An absolute cell reference is when the formula remains constant when it is copied. This is accomplished by adding a $ sign before both the column letter and row number. For example, =$B$4+$B$5 copied into column C would remain the same. The B's would not change do C's.

The FILL HANDLE is located in the bottom right corner of the cell.

The illustration displays the formula in H7, however your screen will display the answer.

In Office 2000, you can copy and collect up to 12 objects on the office clipboard. When you choose the Paste command, the last item copied to the Clipboard will be pasted in the destination cell. Use the Clipboard toolbar to choose a previous selection.

If your quantity, EXAMPLE: 30 turns into 30E-11 try this:

For some reason the custom text format was selected...... go back to the format and then go into format that cell or range..depending on where it is happening and redefine what type of format you want for those cells....the custom (special) format is good for certain things, but it always redefines cells when you don't want it to. I sure hope that this makes sense. Let me know!

Okay! Here it is. The column f should be formatted to a number instead of custom. Put it to zero decimal point. If you are in that cell and right click, you can format from there too. Set column e to a dollar amount and then multiplied out. Copy the formula down so now when you enter the rest of the information, it will calculate automatically and give you a total at the bottom.

Always do a print preview before printing!!!!! This reduces printing errors and wasted paper!

Read and take notes over pages 216-219.

DAY 11

Do Exercise 11 - Save a worksheet as a Webpage and View the Web page.

Staple XL11 to the top of OXL11 and write what it is and what you learned. Always..Name, Date, Hour, & File Name.

Read and take notes over pages 220-223.

DAY 12

Exercise 12 - REVIEW LESSON (PRACTICE TEST)

Take notes on your notes. (Study for your Terms and Application test)

Terms and Application test over Lesson 2 tomorrow!

DAY 13

Terms and Application test over Lesson 2-EXCEL COMPUTER LITERACY ASSIGNMENTS