1 / 10

Excel – Study Guide #2

Excel – Study Guide #2. Spreadsheet Terms. Input Collection of information Data to be typed into the spreadsheet. Output Worksheet results. #1 -- Types of information in Excel. Three types of information can be typed in an Excel spreadsheet – Labels, Values, and Formulas Labels Text

moanna
Download Presentation

Excel – Study Guide #2

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. Excel – Study Guide #2

  2. Spreadsheet Terms • Input • Collection of information • Data to be typed into the spreadsheet. • Output • Worksheet results

  3. #1 -- Types of information in Excel • Three types of information can be typed in an Excel spreadsheet – Labels, Values, and Formulas • Labels • Text • Left-aligned • Relate values in corresponding columns and rows • Type an apostrophe before a number to treat number like a label • Example: ‘523-87-7483 • Example: ‘544-2903

  4. #2 -- Types of information in Excel • Values • Numbers • To be used in calculations • Right-aligned • ##### - Size the cell larger • if #### appear the number is too large for the size of the cell

  5. Your Topic Goes Here #3 -- Types of information in Excel • Your subtopics go here • Formulas • Used to perform calculations • Begin with = sign • Next type the cell addresses that contain the values you want to calculate • Formula Example: =A5+A6+A7+A8 • The values in A5, A6, A7, and A8 are added together

  6. Your Topic Goes Here More about Formulas • Your subtopics go here • Operators • Mathematical operators are + (addition), - (subtraction), * (multiplication), / (division), and ^ (exponentiation) If a formula contains more than one operator at the same level of a precedence (example both addition and subtraction), the expression is calculated from left to right. • Operations in parenthesis calculated first • Example of Formula: =A3*B3 • The value in A3 is multiplied by the value in B3 • Use cell references • By using the cell address in the formula, you can use the powerful recalculation feature in Excel. If you change the contents of a cell that is included in a formula, the worksheet is automatically recalculated so that all values are current.

  7. Your Topic Goes Here Functions • Your subtopics go here • Built-in Formulas Formulas and Functions begin with = Use Insert Menu, fx on Formula bar, or Autosum button The value in A3 is multiplied by the value in B3 Can be typed in manually in the Formula bar • Example of Function =AVERAGE(B13:D13) Use range of cells (B13:D13) Colon means function includes cells B13 through D13

  8. Your Topic Goes Here Common Functions • Your subtopics go here • SUM • Calculates the sum of range of cells • MAX • Displays the largest value in a range of cells • MIN • Displays the smallest value in a range of cells • COUNT • Calculates the number of values in a range of cells • AVERAGE • Calculates the average of a range of cells

  9. Autosum Your Topic Goes Here • Built in sum function • Most commonly used function • Autosum sums values above the cell first • If no values are above, sums cells to the left • Your subtopics go here

  10. The End

More Related