Excel Скачатьпрезентацию <<  MS Excel Информатика Excel  >>
 Exploring Microsoft Excel Objectives (1 of 2) Objectives (2 of 2) Overview Introduction to Spreadsheets Introduction to Excel Excel XP Excel XP Worksheet Hands-On Exercise 1 Modifying the Worksheet Modifying the Worksheet Modifying the Worksheet Hands-On Exercise 2 Excel Features and Commands (1 of 2) Excel Features and Commands (2 of 2) Getting around the Worksheet Cell Referencing Hands-On Exercise 3 Excel XP Formatting Types of Numeric Formats Format Cells Command Hands-On Exercise 4 Summary (1 of 2) Summary (2 or 2)
Слайды из презентации «Microsoft Excel» к уроку информатики на тему «Excel»

Автор: Robert T. Grauer and Maryann Barber. Чтобы увеличить слайд, нажмите на его эскиз. Чтобы использовать презентацию на уроке, скачайте файл «Microsoft Excel.ppt» бесплатно в zip-архиве размером 629 КБ.

Скачать презентацию

## Microsoft Excel

содержание презентации «Microsoft Excel.ppt»
СлайдТекст
1

### Exploring Microsoft Excel

Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet? By Robert T. Grauer Maryann Barber

Exploring Microsoft Excel 2002 Chapter 1

2

### Objectives (1 of 2)

Describe what a spreadsheet is and potential applications Explain how the rows and columns of a spreadsheet are identified, and how its cells are labeled. Distinguish between a formula and a constant Open, save, print a workbook; insert and delete rows and columns

Exploring Microsoft Excel 2002 Chapter 1

2

3

### Objectives (2 of 2)

Describe the three-dimensional nature of a workbook; distinguish between a workbook and a worksheet Print worksheet with values or formulas Copy and/or move cells within a worksheet Differentiate between relative, absolute, and mixed references Use Page Setup to print worksheet and preview before printing Format a worksheet to include changing the font or appearance, borders, and alignment

Exploring Microsoft Excel 2002 Chapter 1

3

4

### Overview

Introduction to spreadsheets and Excel Show wide diversity of spreadsheet applications Fundamentals of spreadsheets using Excel Worksheet recalculates automatically after changes

Exploring Microsoft Excel 2002 Chapter 1

4

5

Spreadsheet is a computerized ledger Divided into rows and columns Columns identified with alphabetic headings Rows identified with numeric headings Cell references Constants--entries that do not change Formulas--combination of constants and functions

Exploring Microsoft Excel 2002 Chapter 1

5

6

### Introduction to Excel

Common user interface on all Office applications Menus and toolbars are similar to Word and Power Point Worksheet is an Excel spreadsheet Workbook contains one or more worksheets Toolbars--Standard and Formatting File menu--Save, Save As, Open and Print commands

Exploring Microsoft Excel 2002 Chapter 1

6

7

### Excel XP

Exploring Microsoft Excel 2002 Chapter 1

7

8

### Excel XP Worksheet

Exploring Microsoft Excel 2002 Chapter 1

8

9

### Hands-On Exercise 1

Objective: To start Microsoft Excel, to open, modify, and save an existing workbook Welcome to Windows Obtain the practice files Start Microsoft Excel Open the workbook The Save As command The Active Cell, Formula Bar and Worksheet tabs Experiment (What If?) The Office Assistant

Exploring Microsoft Excel 2002 Chapter 1

9

10

### Modifying the Worksheet

Insert command can be used to add individual rows, columns, or cells

Exploring Microsoft Excel 2002 Chapter 1

10

11

### Modifying the Worksheet

Delete command can be used to delete individual rows, columns, or cells

Exploring Microsoft Excel 2002 Chapter 1

11

12

### Modifying the Worksheet

Page Setup command and dialog box A dialog box lets you give information to Excel

Exploring Microsoft Excel 2002 Chapter 1

12

13

### Hands-On Exercise 2

Objective: To open an existing workbook; to insert and delete rows and columns;to modify the appearance of a printed workbook. Open the workbook Delete a row Insert a row Use the AutoComplete feature Insert a column Display the cell formulas The Page Setup command The Print Preview command Insert and Delete a worksheet

Exploring Microsoft Excel 2002 Chapter 1

13

14

### Excel Features and Commands (1 of 2)

Active cell cell is surrounded by a heavy black border entries are made into the active cell Formula bar displays the contents of the active cell located near the top of the worksheet Status bar keeps you informed of what is happening as you work located at the bottom of the worksheet

Exploring Microsoft Excel 2002 Chapter 1

14

15

### Excel Features and Commands (2 of 2)

Toolbars contain icons that perform common commands ScreenTips give helpful hints appear when you hold the mouse over an icon or a commented cell File Type compatible with Excel 2000 and Excel 97 Save as Command save as a different file name save as a different file type (Excel 95 or another spreadsheet program)

Exploring Microsoft Excel 2002 Chapter 1

15

16

### Getting around the Worksheet

A rectangular group of cells is a range Copy duplicates contents of a cell from a source range to a destination range Move transfer contents of a cell from one location to another

Exploring Microsoft Excel 2002 Chapter 1

16

17

### Cell Referencing

Absolute reference: remains constant throughout a copy operation Specified with a dollar sign before the column and row, i.e. \$B\$4 Relative reference: adjusts during a copy operation Specified without dollar signs, i.e. B4 Mixed reference: either the row or the column is absolute; the other is relative Specified with a dollar sign before the absolute part of the reference, i.e. B\$4

Exploring Microsoft Excel 2002 Chapter 1

17

18

### Hands-On Exercise 3

Objective: to create a new worksheet; to copy formulas containing relative and absolute references Start Excel Save the workbook Enter student data and literal information Compute the student semester average Copy the semester average Compute class averages What If? Change exam weights

Exploring Microsoft Excel 2002 Chapter 1

18

19

### Excel XP Formatting

Column widths Row Heights Numeric Format Alignment Fonts Borders, Patterns, and Shading

Exploring Microsoft Excel 2002 Chapter 1

19

20

### Types of Numeric Formats

General Number Currency Accounting Date Time

Percentage Fraction Scientific Text Special Custom

Exploring Microsoft Excel 2002 Chapter 1

20

21

### Format Cells Command

Exploring Microsoft Excel 2002 Chapter 1

21

22

### Hands-On Exercise 4

Objective: to format a worksheet using boldface, italics, shading, and borders; to change the font and/or alignment of an entry. Center the title across selection Format the exam weights Format the class averages Borders and color Print the workbook Use the Page Setup command to modify the appearance of the printed workbook Print the cell formulas

Exploring Microsoft Excel 2002 Chapter 1

22

23

### Summary (1 of 2)

Spreadsheet is computerized accountant’s ledger Spreadsheet is generic term; worksheet is an Excel term Cells contain formulas or constants A formula always begins with an equal sign Formulas can be copied or moved anywhere within the worksheet. Make sure you understand absolute, relative, and mixed cell referencing and when to use each!!

Exploring Microsoft Excel 2002 Chapter 1

23

24

### Summary (2 or 2)

Page Setup gives you control over the appearance of the printed worksheet Formatting is done by selecting the cell(s) you want to format, then applying the format you want Use the Ctrl key to select non-contiguous cells or ranges of cells Print worksheets with displayed values and formulas

Exploring Microsoft Excel 2002 Chapter 1

24

«Microsoft Excel»
http://900igr.net/prezentatsii/informatika/Microsoft-Excel/Microsoft-Excel.html
cсылка на страницу
Урок

## Информатика

126 тем
Слайды
Презентация: Microsoft Excel.ppt | Тема: Excel | Урок: Информатика | Вид: Слайды