Aim: How do we create Excel formulas?

Aim: How do we create Excel formulas? Do Now: Complete Excel Basic Spreadsheet Skills (Activity 1)

1

Label the Parts

2

Working with columns

3

Working with Rows

4

Working with Cells

5

Activity 1 1. Open Practice File 1 2. Complete all steps

6

Double click between 2 columns or 2 rows to open to the widest entry

Roll over the colors slowly for fonts or fill to see the name.

Single or Double Underline

Merge and Center

Highlight where you want to center information. Across which cells.

Click Merge and Center

Insert a new Row or Column by Highlighting the Entire Row or Column

Right Click and Insert

Format Cells by Right Click

Change Number Format

Change percents % to decimals: • 50% •.50 • 8.75% •.0875 • 5% •.05 • 100% •1.00

Activity 1. Open and complete Practice file 1

16