1 / 46

Spreadsheet Applications

Spreadsheet Applications. BTA Jefferson Davis High School Montgomery, AL . Introduction. Part I Part II. New Terms. Active cell Cell Cell reference Column letter Date Gridlines Label Name box . Row number Spreadsheet Time Value Workbook Worksheet .

tameka
Download Presentation

Spreadsheet Applications

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 Applications BTA Jefferson Davis High School Montgomery, AL

  2. Introduction Part I Part II

  3. New Terms • Active cell • Cell • Cell reference • Column letter • Date • Gridlines • Label • Name box • Row number • Spreadsheet • Time • Value • Workbook • Worksheet Look out for these terms as you read. You will define them later.

  4. What is a Spreadsheet? • A spreadsheet is data displayed in rows and columns. • The spreadsheet application in Microsoft Office is Excel. • Excel files are called workbooks, each workbook contains three worksheets. The default file name for an Excel workbook is Book1. • When saved, Excel files have an extension of .xlsx

  5. Basic Parts • The cell is the intersection of a row and column where data is stored. • Columns are named by Letter (A, B, C, D) • Rows are named by Number (1, 2, 3, 4) • A cell reference (or the name of a cell) is the column letter and row number where that cell is located. The Name Box displays the cell reference of the active cell. The formula bar displays the contents of the active cell. Cell Reference Column Letter Row Number

  6. Entering Data • Data can only be entered into the active cell. The active cell has a darker border than the other cells. Data will be displayed on screen in the active cell and in the formula bar. To enter data, select the cell and begin typing. • What can be entered? • Labels: text that canned be used in calculations. • Values: numbers that can be used in calculations • Dates/times: times or dates that may be used in some calculations.

  7. Entering Data • Once data has been entered into a cell: • Pressing the Enter key selects the next cell in the column • Pressing an arrow key selects the next cell in the direction of the arrow key pressed. • Pressing the Esc key cancels data entry and restores the original contents of the cell. • Pressing the tab key when entering information is the most efficient method of entering data across a row. • Excel will recognize a pattern and return to the beginning of a row when you press Enter.

  8. The Excel Window Use the next slide to label your Excel Window handout.

  9. Name Box Formula Bar Column Letter Active Cell Row Number Scroll Bars Sheet Tabs

  10. Uses and Benefits

  11. Uses and Benefits • Benefits of using a spreadsheet include, but are not limited to: • Perform calculations easily • Automatically recalculate values when data changes are made • provide an organized way of tracking and presenting information. • Essential tool for the “real world”

  12. Real World Applications Math • Estimations - then make actual calculations and/or graph; • Make predictions based on initial data gathered; • Statistical surveys from any subject area; • Metric (or English) measurements of the body, objects of various sizes, perimeters, areas; • Equations, functions, relations; and • Time needed to accomplish various tasks

  13. Real World Applications Science • Sizes of the planets, density, distance from Earth, atmospheric composition; • Temperature, humidity, rainfall over time, overcast-amount of sun-visibility; • Growth of plant or animal under different experimental conditions; • Distance, velocity, acceleration; • Falling objects, gravity, wind resistance; and • Animal population, growth and decline rates.

  14. Real World Applications Health • Vitamins, minerals, or other composition comparisons; • Calories versus weight for various foods; • Fast food nutritional, saturated versus unsaturated fats; and • Heart rate over time, varying according to activity.

  15. Real World Applications Social Studies • Size comparison for cities, states, or countries or their growth rates; • Size composition (farm land, mountains, lakes, etc.); • Population composition (cities, rural areas, small towns, etc.) or (percent literate versus decade) or ethnic backgrounds; • Economic growth (crops or mining or shipping or roads, (industrial, farming, services); • Buying power or cost of living comparisons versus different areas • Projected growth rates.

  16. Real World Applications Language Arts • Number frequency in ciphering codes; and • Number of books read by different classes/students Physical Education • Scores versus time of specific track and field events; and • Number of push-ups, sit-ups, etc. one can do on a sequence of days.

  17. Using Excel Header and Footer Saving Previewing and Printing

  18. Header and Footer • Tab: Insert • Group: Text • Button/Command: Header & Footer • Always include a footer in printed assignments!

  19. Saving • Filenames will follow the same scheme we have been using. • Assignmentname_FirstLast-x

  20. Previewing and Printing Be sure to use the Quick Access Toolbar to Preview before Printing. • On the Page Layout Tab, Page Setup Group, you will find options for printing your work. • Because Spreadsheets are VERY large, be sure to set your print area before pressing print. Highlight your work area, click the print area command, click Set print area. • You may choose to print column titles on all pages of a multi-page worksheet.

  21. Vocabulary Define in the Vocabulary Section of your BTA notebook.

  22. Spreadsheet Vocabulary • Active Cell – the selected cell displayed with a bold outline. Data can only be entered into an active cell. • Cell – the intersection of a row and column. Each cell can store a single item of data. • Cell reference – the column letter and row number used to identify a cell. • Column letter – letter at the top of the worksheet used to identify individual columns. • Date – data in the form of a calendar date. • Gridlines – solid lines that mark off the rows and columns in a worksheet • Label – text stored in a cell that cannot be used in calculations • Name box – located near the top of the worksheet window. Displays the cell reference of the active cell.

  23. Spreadsheet Vocabulary • Row number – the number down the left side of the worksheet used to identify individual rows • Sheet Tabs – used to identify the three worksheets in the workbook. • Spreadsheet – data displayed in rows and columns. • Time – data in the form of a time. • Value - numeric data that is stored in a cell that can be used in calculations. • Workbook – an excel spreadsheet file • Worksheet – Sheets in an Excel workbook used to present data in an organized format.

  24. Formatting Numeric Data

  25. Formatting values • Cells storing numeric data (values) should be properly formatted to reflect the type of value stored. • From the ribbon • Tab: Home • Group: Number

  26. Formatting Values • Click on the category drop-down menu for your choices.

  27. Choose the Number Group Dialog box launcher Choose your category, decimal places, etc.

  28. Common Numeric Formats • Number formats the active cell to display values with two decimal places. • Currency formats the active cell to display values with a dollar sign and two decimal places. • Accounting is similar to Currency except the dollar sign aligns itself at the left edge of the cell. • Percentage formats the active cell to display values as percentage with two decimal places. • Scientific formats the active cell to display values in scientific notation with two decimal places.

  29. Options: • There are three options associated with numeric formats: • Decimal places • Comma separator • Negative numbers

  30. Formatting Numbers (Values) • Formatting a cell does not change the value that is stored in the cell, only how that value is displayed • Number signs (######) are displayed if a cell is not wide enough to display the formatted number. • There are also different options for Dates & Times.

  31. Date Options Time Options

  32. Using Formulas to Perform Calculations

  33. Formulas in Excel • One benefit of using a worksheet is its ability to perform calculations using formulas. • Formulas are mathematical statements used to calculate values. • Always begin with an equal (=) sign.

  34. Formulas in Excel • Mathematic operators used in formulas: • Exponentiation ^ • Multiplication * • Division / • Addition + • Subtraction - • Excel evaluates a mathematical expression using a specific order of operations. • Please Excuse My Dear Aunt Sally • Parenthesis, Exponents, Multiply, Divide, Add, Subtract

  35. Practice 4 Complete practice 4 from your packet. You will practice entering labels and formulas into Excel.

  36. Using Cell References in Formulas

  37. Using Cell References • Generally, cell references will be used in formulas instead of numbers. • A cell reference is used in a formula so that the value stored in the cell is used in the calculation of the formula. • Excel uses the cell reference to locate the value needed for the calculation.

  38. Using Cell References • Formulas that contain cell references are automatically recalculated when the value in a references cell changes. • A formulas cannot reference the cell it is stored in, this is called a circular reference.

  39. Practice 5 Complete practice 5 from your packet. You will practice entering labels and formulas using cell references into Excel.

  40. Using Functions to Perform Calculations

  41. Using Functions • Excel contains built-in functions that can be included in a formula for performing common calculations. • A function performs a calculation that results in a single value. • A function has two parts, the function name, and the argument. =SUM(G1:G3) • Functions are useful because they make a formula shorter and less error-prone. function argument

  42. Practice 6 Complete practice 6 from your packet. You will practice entering labels and functions into Excel.

  43. Pointing

  44. Entering Formulas - Pointing • When typing a formula, cell references can be entered by pointing. • Pointing is a technique where a formula is typed up to where a cell references should appear and then a cell is clicked, which places its reference in the formula. • Pointing is the best method for entering cell references into a formula because typing errors are avoided.

  45. Additional Vocabulary

  46. Additional Vocabulary • Add the following Vocabulary terms and definitions to your Excel vocabulary list: • Adjacent cells – cells that are next to each other • Argument – data required by a function to perform calculations. • Formula – mathematical statement used to calculate a value. • Function – performs a calculation that result sin a single value • Pointing – clicking a cell to place its reference in a formula • Range – selection of two or more cells • Formula bar – area near the top of the worksheet window that displays the contents of the active cell.

More Related