1 / 15

Spreadsheet Basics

Spreadsheet Basics. Letters are used for columns Numbers are used for rows Cells are identified by a combination of letters and numbers ex. B4. There are 3 main types of values that can be entered into a cell. Numbers. Text. Formulas.

alden-mcmahon
Télécharger la présentation

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

  2. Letters are used for columns • Numbers are used for rows • Cells are identified by a combination of letters and numbers ex. B4

  3. There are 3 main types of values that can be entered into a cell Numbers Text Formulas

  4. Information can be put in a cell by clicking on the cell and entering the value in the formula bar or by double clicking on a cell and entering the information directly into the cell.

  5. If you are entering the same value many times you can automatically fill in that value. Use your mouse to grab the bottom left hand corner of the cell and drag down or across.

  6. If a formula is copied using AutoFill the formula will automatically adjust.

  7. Formula Basics

  8. Cell references are often used in formulas • The value in A3 will be calculated by adding 1 to the value in A2 • The result will be stored as a number in A3

  9. A combination of multiple cell references and mathematical operations can be used

  10. All spreadsheet programs contain many frequently used and complex functions A menu of these functions can be found under the Insert menu

  11. The functions are grouped by application and then alphabetically

  12. Once you have selected the appropriate function a window will appear the will guide through the rest of the process

  13. As you fill in the necessary information you will get a preview of the function at work

  14. Once you have inserted the function the calculated value will appear in the actual cell. The formula will show in the formula bar.

More Related