1 / 11

Excel

Excel. BCSII-5 : The student will utilize spreadsheet software. a) Identify uses of spreadsheet software and careers related to spreadsheet. b) Identify and explain spreadsheet terminology .

jada
Télécharger la présentation

Excel

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

  2. BCSII-5: The student will utilize spreadsheet software a) Identify uses of spreadsheet software and careers related to spreadsheet. b) Identify and explain spreadsheet terminology. c) Create and save basic spreadsheets and apply formulas related to business and computer science careers. d) Retrieve, edit, manipulate, and print various spreadsheets. e) Create various charts/graphs from spreadsheets.

  3. A spreadsheet is a program that process information that is set up in tables. • Spreadsheets can be used to: • Place numbers and text in easy to read rows and columns • Calculate numbers and show the results • Calculate new results when the numbers are changed • Create charts to display data

  4. Did you know? • A spreadsheet can hold a great deal of information. Microsoft Excel can hold: • 256 columns • 65,536 rows • As many worksheets as your computer’s memory can keep open. • If you fill every column and row on just one worksheet, you would have filled 16,777,216 cells

  5. Identify careers related to spreadsheets. • Accountants- they use spreadsheets in their jobs to work out formulas quickly and to keep records • Teachers- use spreadsheets to keep track of children's progress and. • You can use spreadsheets in almost any job. • http://www.ehow.com/list_7467450_careers-use-spreadsheets_.html

  6. How can spreadsheets be used at home? • Many people use spreadsheets at home to track monthly income and expenses. They can set up a worksheet to show regular monthly costs. Then, they only need to paste it on other blank worksheets to create budgets for other months.

  7. You could use Excel to organize and process information about: • Your class schedule • Your grades • Your friends’ addresses and phone numbers • Or your personal budget

  8. Terminology • Column- information arranged vertically, represented by a letter (example A) • Row- information arranged horizontally, represented by a number (example 2) • Formula- In excel, the relationship between cells, such as adding or dividing the contents of cells in an arithmetic equation. • Function- an automatic formula in an arithmetic equation

  9. Terminology • Worksheet- a table of data that is organized into rows and columns • Workbook- an excel file that holds your worksheets. It can be one worksheet or hundreds of worksheets • Autofit- Excel feature that can automatically change the width of a column to fit the longest entry or change the height of a row to fit the font. • Autosum- In excel, a function that adds a column of numbers above or a row of numbers to the left.

  10. We will now get started by completing a Pre test over the parts of a spreadsheet.

  11. Items we need: • Pretest • Worksheet 5B • http://glencoe.mcgraw-hill.com/sites/dl/free/0078612357/271275/369PT3_WKST_8612365b.pdf • Worksheet 5C • http://glencoe.mcgraw-hill.com/sites/dl/free/0078612357/271275/370PT3_WKST_8612365c.pdf

More Related