1 / 14

Spreadsheet

Spreadsheet . Notes. 1. What is a spreadsheet?. A bunch of rows and columns of information. Used to organize and analyze information. Also called a worksheet. 2. Why is a spreadsheet helpful?. To quickly perform calculations Also, to easily create neat, organized charts of info.

Download Presentation

Spreadsheet

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. Spreadsheet Notes

  2. 1. What is a spreadsheet? • A bunch of rows and columns of information. • Used to organize and analyze information. • Also called a worksheet

  3. 2. Why is a spreadsheet helpful? • To quickly perform calculations • Also, to easily create neat, organized charts of info.

  4. 3. Parts of a spreadsheet: • Rows: they are identified by NUMBERS down the side • Columns: they are identified by LETTERS across the top • Cells: the boxes created where rows and columns intersect

  5. 4. Do cells have names? Yes! • They’re also called cell addresses. • Cells are named by their column letter first and row number second • Examples: A1 or J7

  6. 5. What can we put in a cell? • Labels: word, letters, or symbols that are NOT used in calculations • Values: numbers that are used in calculations. • Formulas: mathematical calculations.

  7. 6. Formatting of Cells • We can format cells the same way we format text in Word. • How? Right-click, choose Format Cells • Here are just some things we can change: • Font Size • Font Style • Alignment • Bold, Italics, Underline

  8. 7. We can change column widths if information in cells need more room. How? • Click and drag between number cells at side. • Double-click between cell • Right click on the column heading and pick width

  9. 8. What is a Cell Range? • A group of selected cells. • Examples: A1:C5 and F15:J22

  10. 9. How can we enter something into a cell? • Press Enter. • Click the green enter check mark in the Formula Bar. • Press an arrow key. • Click in a different cell.

  11. 10. Header and Footer • We can to two places to put our Header and Footer onto a Spreadsheet: Go to the insert ribbon, click on header or footer

  12. 12. Print Area • Always set a Print Area before you print to prevent wasting paper • First, highlight the cells you want to print • Then, go to the office button, click on print, and the set print area • You’ll see dashed lines around the area you set.

  13. 13. Cell formatting • After you key in info, you might want to change the way it looks by adding commas, the $ symbol, or changing the date format. • You can do this by right-clicking on the cell and choosing format cells • Or, highlight the cells and click on the shortcut keys.

  14. 14. Formulas • Always begin a formula with = • Use cell names in a formula, NOT the numbers in the cells. • Samples: • Addition: =A1+A2 • Subtraction: =D4-D3 • Multiplication: =E5*E3 • Division: =G2/G1

More Related