RECALCULATING A TABLE

1. Open the file: Recalculating a Table
2. The figures in the Expenses column have changed. Change the table so that the figures in the Expenses column are the same as the table below.

1. Click once in cell D3 (the cell right below Net Profit). Press the F9 key (this key is in the top row of the keyboard). This will recalculate the cells.
2. Click once in cell D4. Press F9.
3. Click once in cell D5. Press F9.
4. Click once in cell D6. Press F9.
5. The figures in the Net Profit column have be recalculated as shown in the table below.

Print the table.

Working with Columns and Breaks

1. Start a new document.
2. Type the following heading: TOP 20 BOYS AND GIRLS NAMES
3. Bold and Center the heading
4. Press Enter 2 times
5. Click on the Align Left button in the Formatting Tool Bar. Turn off Bold in the Formatting Tool Bar.
6. Click on Insert. Click on Break. Click on Continuous. Click OK. (You just added a Continuous break).
7. Click on Format in the menu bar. Click on columns. Click on two. Click OK. (You just added two columns to your page.
8. Click on Insert. Click on Break. Select Column Break. Click OK. (You just added a Column Break).
9. Type the list of names in the columns below. Put all the boys’ names in the left hand column and put all the girls names in the right hand column. Use the mouse to click back and forth from the left column to right column. Type only one name on each line. Press return after you type each name.

Jacob Emily Madison Michael Hannah Joshua Matthew Ethan

Joseph Emma Alexis Ashley Andrew Abigail Sarah Christopher

Daniel Nicholas Samantha William Anthony Megan Elizabeth David

Tyler Alyssa Lauren Alexander Isabella Ryan Grace Jessica

John Brianna James Zachary Taylor Kayla Brandon Anna

Working With Columns and Breaks Part 2

1. Type the memo on the next page.
2. After you type the first paragraph, you have to put in a Continuous Break and insert 2 columns by doing the following:
3. Click on Insert, then click on Break, then click on Continuous.
4. Click on the Columns button in the Standard Toolbar and select 2 columns.
5. After you type the last item in the first column, insert a Column Break. Click on Insert, then Break, then Column Break.
6. Type the 2nd column.
7. At the end of the 2nd column, Insert a Continuous Break. Click on Insert, then Break, then Continuous Break.
8. Remove the 2 columns by clicking on the Columns button in the Standard Toolbar and select 1 column.
9. Finish typing the memo.
10. Add your name to the bottom, save the memo, then print 2 copies.

DATE: August 20,2001

TO: Intermediate Students

FROM: Bryon Rodan, Principal

SUBJECT: Supply List

The supplies need for all students in the intermediate grades are listed below. Please try to have the supplies on hand by the first day of school. Our first day of school is on

Monday, August 28.

• Loose- leaf paper (at least 3 packages)
• 4 single-subject spiral notebooks (70pages, collage ruled)
• Plastic expandable folder with at least 7-12 dividers OR binder with 6, 3-hole punched folders (Many Prefer the zipper nylon binder)
• Zipper pencil pouch to fit in binder
• No. 2 pencils (dozen)
• Blue, Black, and Red pens (package of each)
• Ruler
• Calculator - Texas Instrument – TI-30x-II’s
• Scissors
• Glue stick
• 2 boxes of Kleenex (200 count )
• Highlighter
• Clear Protractor
• Colored pencils or markers
• Compass
• 2 Packages of Index Cards (4x6)

For students who will be using a backpack, please remember that all backpacks are to be stored in your locker. Backpacks are not allowed in the classrooms.

Have a great school year!

Using Columns, Breaks, and Page Setup

1. Start a new document.
2. Click on the File Menu, then select Page Setup.
3. Set the left and right margins to .8
4. Click OK
5. Type the title of the page. Center, Boldface, Underline it. Increase the font size to 14.
   10 Largest Cities According to the 2000 Census.
6. Press Enter twice
7. Select Insert Break, then select Continuous. Click OK.
8. Click on the Columns button in the Standard Toolbar. Select 3 columns
9. Click on the Format Menu and select Columns.
10. Select the box next to Equal Column Width
11. Change the width of Column 1 to 2.2.
12. Click OKClick on the Insert Menu, then click on Break, select Column Break.
13. Click OK
14. Click on Insert Menu, then Click on Break, select Column Break.
15. Click OK
16. Click in the first column
17. Click on the Center Button in the Formatting Toolbar.
18. Type the chart on the next page. Double space between each line.

CITY AND STATE

New York, New York

Los Angeles, California

Chicago, Illinois

Houston, Texas

Philadelphia, Pennsylvania

Phoenix, Arizona

San Diego, California

Dallas, Texas

San Antonio, Texas

Detroit, MichiganPOPULATION

2000 CENSUS

8,008,278

3,694,820

2,896,016

1,953,631

1,517,550

1,321,045

1,223,400

1,188,580

1,144,646

951,270INCREASE/DECREASE

FROM 1990

685,714

209,422

112,290

323,078

–68,027

337,642

112,851

181,703

208,713

–76,704