Intro to Microsoft Excel Formatting Worksheet Inserting Rows

Intro to Microsoft Excel Formatting Worksheet Inserting Rows Editing Data

What is Excel? l spreadsheet program used to: • record data • manipulate data • calculating totals and averages • display data l l • graphs, charts, tables, etc… great at tracking numbers that change often sorts, calculates, and graphs

Some Microsoft Excel Terms l Worksheet – • work area in Excel • columns and rows l Cell – • Intersection of column and row

Some Microsoft Excel Terms l Workbook – l Sheet Tabs – • file containing worksheets • at bottom of workbook • displays name of worksheet

Launch Excel Title Bar Office Button Tabs Ribbon Name Box Cell Sheet Tabs Worksheets

Open Workbook l l Open existing file (Ctrl + O). • • • choose the Classes drive choose Comp Lit folder choose Excel folder choose the file named careers click Open Save document (Ctrl + S). • choose your directory, create excel folder Make sure careers is the file name. Click the Save button.

Autofit Columns l Columns A and B • double-click between A and B

Bold, Merge and Center l Cells A 1 and B 1: • • Bold Merge and Center

Percentage Format, Center l Format the Percentages l Center the Percentages

Column Headings l Format the Column Headings • • Underline Bold

Rename the Sheet l l Double click on Sheet 1 Rename it “Fastest Growing Occupations”

Inserting Rows l l l highlight rows 2 through 4 right-click Insert

Creating 4 -line Heading l l Who: What: When: By: • Fastest Growing Occupation Percentage Growth 2002 – 2012 by Firstname Lastname bold, merge and center each row

Editing a Cell using the formula bar l l select cell B 6 in formula bar • highlight "Between 2002 - 20012" hit Delete key hit Enter key

Editing a Cell using “Edit in Place” l l double-click cell B 6 double-click the word Change type the word Growth hit Enter