140 likes | 228 Views
Today we will-. Learn important Excel vocabulary words Participate in a lesson on spreadsheet navigation & data entry V ote for our favorite pets Download and save our template Enter data into an Excel spreadsheet Watch review video clip http:// www.gcflearnfree.org/excel2010.
E N D
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
KWL & Think, Pair, Share What do I already know about bar graphs?
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
Charts and Graphs Microsoft Excel
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
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.
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.
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.
Formula • A formula is an equation used to calculate numbers. • When using Microsoft Excel, formulas always begin with an equals sign = Example: = A1 + B3
Trend • A trend is the general direction or tendency based on existing data.
Navigating with Tools in a Spreadsheet • Use arrow (directional keys) • Double click, then use Enter & Tab keys • Zoom • Address Bar • Page Layout
KWL & Think, Pair, Share What do I already know about Excel?
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: