1 / 14

Excel Vocabulary Lesson: Data Entry and Bar Graph Creation

Today's lesson covers important Excel vocabulary, spreadsheet navigation, data entry, creating bar graphs, and advanced chart styling. Learn Excel basics and graph design techniques. Access template, review clips, and enhance spreadsheet skills.

rose-harmon
Télécharger la présentation

Excel Vocabulary Lesson: Data Entry and Bar Graph Creation

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. Today we will- • Learn important Excel vocabulary words • Participate in a lesson on spreadsheet navigation & data entry • Vote for our favorite pets • Download and save our template • Enter data into an Excel spreadsheet • Watch review video clip • http://www.gcflearnfree.org/excel2010

  2. KWL & Think, Pair, Share What do I already know about bar graphs?

  3. Today we will- • Enter data into spreadsheet cells in order to create a bar graph. • We will format our bar graph • Eye Catching Titles • Colored Bars & Cells • Advanced: Themed Clip Art

  4. Charts and Graphs Microsoft Excel

  5. Cells • A cell is the location where a column and a row meet in a spreadsheet or database. A cell is identified by its column letter and a row number. Example: A1, B2, C3 • The cell address is the location of a cell in a spreadsheet or database. It is identified by the cell’s column/field letter and row/record number

  6. Column • A column consists of cells that run vertically across a spreadsheet or database and contain one type of information. Columns are identified by letters.

  7. Row • A row consists of cells that run horizontally across a spreadsheet or database and contain a complete record of data. Rows are identified by numbers.

  8. Spreadsheet • A spreadsheet is a table that organizes data in cells. In spreadsheets, formulas can be used to calculate numerical data. Microsoft Excel is a spreadsheet program.

  9. data

  10. Formula • A formula is an equation used to calculate numbers. • When using Microsoft Excel, formulas always begin with an equals sign = Example: = A1 + B3

  11. Trend • A trend is the general direction or tendency based on existing data.

  12. Navigating with Tools in a Spreadsheet • Use arrow (directional keys) • Double click, then use Enter & Tab keys • Zoom • Address Bar • Page Layout

  13. KWL & Think, Pair, Share What do I already know about Excel?

  14. 4-6th Grade Technology Class Report Technology ReportTeacher:_______________________________ Objective: Today we will learn to enter data correctly into a spreadsheet in Microsoft Excel. Cooperation 1 2 3 4 5 Assertiveness 1 2 3 4 5 Responsibility 1 2 3 4 5 Empathy 1 2 3 4 5 Self-Control 1 2 3 4 5 Our strengths: We need to work on:

More Related