1 / 29

Rock Out with Excel Basics

Rock Out with Excel Basics. Summer 2007 Janie Hardt jhardt@madison.k12.al.us. Spreadsheet. Computer equivalent of a paper ledger sheet Allows manipulation of data and number calculation Data entered Numbers Formulas Text. Components. Rows- horizontal lines Columns- vertical lines

galena
Download Presentation

Rock Out with Excel Basics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Rock Out with Excel Basics Summer 2007 Janie Hardt jhardt@madison.k12.al.us

  2. Spreadsheet • Computer equivalent of a paper ledger sheet • Allows manipulation of data and number calculation • Data entered • Numbers • Formulas • Text

  3. Components • Rows- horizontal lines • Columns- vertical lines • Grid rectangles are cells • Sheets

  4. Cursor Styles Highlight multiple cells or single cell Fill cell contents into cells below or to the right Drag contents of cell to any other cell Place the cursor into the Formula bar to edit an equation or function

  5. Movement • Enter- Down • Tab- Right • Shift Enter- Up • Shift Tab- Left

  6. Symbols • + Addition • - Subtraction • * Multiplication • / Division • = Used before an equation • : Separates first and last number in a range of numbers • , Separates nonadjacent numbers

  7. 4 5 5 Formatting 3 2 All text and numbers can be formatted using the formatting toolbar. • Resize • Change style of font • Change color of font • Change position of font • Format numbers

  8. Merge and Center Icon • Allows text to be centered on spreadsheet across several cells

  9. Format Numbers

  10. Select Format, Cells, Choose style

  11. Accounting • Dollar sign is placed on the left of the column • Underline for single line • Hold down Shift key and U for double line

  12. Row and Column Size • Increase or decrease by dragging • Increase or decrease by selecting Format from the toolbar and choosing Row or Column • Increase or decrease number

  13. Formulas • =A2+B2 • =SUM(A2:D2) • (A2 is start of a cell range and D2 its end). • Identifies the calculation needed to place the result in the cell it is contained within. • A cell containing a formula has two display components; • Formula itself • Calculated value. • Must always press Enter after formula or data is entered

  14. Formula Calculated Value

  15. Functions • A built in equation • Insert, Choose function • Choose function icon on formula bar

  16. Select your function from a list

  17. Add the cell range and click OK

  18. AutoSum • Allows the addition on several cells without entering a formula • Click empty cell below values then AutoSum icon. Sum will appear in that cell. • Select the cells including cell where sum to appear, click AutoSum icon ∑ on toolbar and sum will appear in the last cell selected

  19. Selected single cell then icon. Selected cells Then icon.

  20. Charts • Select data to be graphed and choose Chart Wizard icon. • Select chart.

  21. Web Sites http://www.forsythcountyschools.org/kadkins/abc.htm http://www.internet4classrooms.com/index.htm http://www.fi.edu/fellows/fellow4/may99/ss-procedure.html

More Related