EXCEL SPREADSHEETS Created by Diane Hankins What is

EXCEL SPREADSHEETS Created by: Diane Hankins

What is Excel? • The spreadsheet application of the Microsoft® Office programs Microsoft® Excel

What is a Spreadsheet? • A grid of rows and columns • Solves number problems • Worksheets • Workbook

The Spreadsheet

Why use an Electronic Spreadsheet • • • Larger than paper Faster Multiple Operations “What If” Graphs and charts Easy integration

Columns, Rows and Cells Columns (ABC) Rows are 1, 2, 3

The Cell • Intersection of column and row – IS THE ACTIVE CELL • Home, End, Ctrl Home, Ctrl End

Finding your location Name or reference FIND Cell

Moving Around • Just click in different cells and watch how the cell reference changes and where the active cell is • GO TO Command – On the Home ribbon

Scrolling and Changing Pages • You can scroll by using the scrolling arrows • You can use the arrow keys located on the keyboard to move from cell to cell • To change pages use Page Up and Page Down keys on the keyboard

Entering Data • Four basic types of data can be entered into an Excel® spreadsheet – Labels – Values – Formulas – Numeric

Selecting a Range of Cells

E-1 • Changed column widths • Make sure all font is Arial 10 pt – Select the range of the entire worksheet and change font and size on the home ribbon

How do you change width of a column • Place cursor between column, click and drag • Right click between columns and go to column width • Default of column width is 8. 43

Printing your work!! • • • Turn orientation to Lanscape Go to Insert Header At the left put your name At center put your project name E-1 At right put your class period. Always print preview and then print.

E 2&E 3 • Selecting adjacent cells • Changing number formats • Making a cell italics – Select cell and click on the icon I • Make cells bold – Select cell and click on the icon B

Selecting Adjacent Cells • Click on the first cell • Hold down on the CTRL button • Then Select the other cells

Changing Number Format • Home ribbon, number group drop down arrow

Upon dropping down arrow you will see this dialog box. Choose the correct formatting you want. ,

To Sort Data • Select the data you want sorted • On your home ribbon press the Sort & Filter Button • Click Sort

E-4 • Shading cells • Using the average formula • Custom Header

Shading cells • On the home ribbon • The font group • Paint bucket – For a specific % point to the color and it will say what % of color it is such as 25%

Functions • • Sum – adds a range Average – takes the average of a range Min – finds the lowest number Max- finds the largest number

Sum, Average, Min & Max • Sum button is located in the editing group on the home tab. • Other functions

Functions • Place your cursor in the cell you want your answer • Click on the sum button or drop down the sum button for other functions • It will select a range of cells. If this is not the range you want then click and drag through the correct cells. • Then hit enter

Headers and Footer • To create a header in a spreadsheet • Go to insert tab • Go to the text group and click on header or footer • It can be changed to any font size or font you would like

Formulas • ALL FORMULAS MUST START WITH AN = SIGN (=B 1/C 20) • Add (+) • Subtract (-) • Multiply (*) • Divide (/) • Exponent (^) Remember PEMDAS

The SUM Function • Probably the most useful • Totals a column or row of cells • Represented by

Formulas & Function • The equation used to calculate values in a cell is called a formula. • It always starts with an equal sign = • Operators – Additions + – Division / – Multiplication * – Subtraction -

Today we learned • Spreadsheets are great! • Can calculate • Desktop looks familiar

What do you think? Any questions!!!