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

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

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

Microsoft Excel

содержание презентации «Microsoft Excel.ppt»
Сл Текст Сл Текст
1Exploring Microsoft Excel. Chapter 1 Introduction to 14surrounded by a heavy black border entries are made into the
Microsoft Excel: What is a Spreadsheet? By Robert T. Grauer active cell Formula bar displays the contents of the active cell
Maryann Barber. Exploring Microsoft Excel 2002 Chapter 1. located near the top of the worksheet Status bar keeps you
2Objectives (1 of 2). Describe what a spreadsheet is and informed of what is happening as you work located at the bottom
potential applications Explain how the rows and columns of a of the worksheet. Exploring Microsoft Excel 2002 Chapter 1. 14.
spreadsheet are identified, and how its cells are labeled. 15Excel Features and Commands (2 of 2). Toolbars contain icons
Distinguish between a formula and a constant Open, save, print a that perform common commands ScreenTips give helpful hints
workbook; insert and delete rows and columns. Exploring appear when you hold the mouse over an icon or a commented cell
Microsoft Excel 2002 Chapter 1. 2. File Type compatible with Excel 2000 and Excel 97 Save as
3Objectives (2 of 2). Describe the three-dimensional nature Command save as a different file name save as a different file
of a workbook; distinguish between a workbook and a worksheet type (Excel 95 or another spreadsheet program). Exploring
Print worksheet with values or formulas Copy and/or move cells Microsoft Excel 2002 Chapter 1. 15.
within a worksheet Differentiate between relative, absolute, and 16Getting around the Worksheet. A rectangular group of cells
mixed references Use Page Setup to print worksheet and preview is a range Copy duplicates contents of a cell from a source
before printing Format a worksheet to include changing the font range to a destination range Move transfer contents of a cell
or appearance, borders, and alignment. Exploring Microsoft Excel from one location to another. Exploring Microsoft Excel 2002
2002 Chapter 1. 3. Chapter 1. 16.
4Overview. Introduction to spreadsheets and Excel Show wide 17Cell Referencing. Absolute reference: remains constant
diversity of spreadsheet applications Fundamentals of throughout a copy operation Specified with a dollar sign before
spreadsheets using Excel Worksheet recalculates automatically the column and row, i.e. $B$4 Relative reference: adjusts during
after changes. Exploring Microsoft Excel 2002 Chapter 1. 4. a copy operation Specified without dollar signs, i.e. B4 Mixed
5Introduction to Spreadsheets. Spreadsheet is a computerized reference: either the row or the column is absolute; the other
ledger Divided into rows and columns Columns identified with is relative Specified with a dollar sign before the absolute
alphabetic headings Rows identified with numeric headings Cell part of the reference, i.e. B$4. Exploring Microsoft Excel 2002
references Constants--entries that do not change Chapter 1. 17.
Formulas--combination of constants and functions. Exploring 18Hands-On Exercise 3. Objective: to create a new worksheet;
Microsoft Excel 2002 Chapter 1. 5. to copy formulas containing relative and absolute references
6Introduction to Excel. Common user interface on all Office Start Excel Save the workbook Enter student data and literal
applications Menus and toolbars are similar to Word and Power information Compute the student semester average Copy the
Point Worksheet is an Excel spreadsheet Workbook contains one or semester average Compute class averages What If? Change exam
more worksheets Toolbars--Standard and Formatting File weights. Exploring Microsoft Excel 2002 Chapter 1. 18.
menu--Save, Save As, Open and Print commands. Exploring 19Excel XP Formatting. Column widths Row Heights Numeric
Microsoft Excel 2002 Chapter 1. 6. Format Alignment Fonts Borders, Patterns, and Shading. Exploring
7Excel XP. Exploring Microsoft Excel 2002 Chapter 1. 7. Microsoft Excel 2002 Chapter 1. 19.
8Excel XP Worksheet. Exploring Microsoft Excel 2002 Chapter 20Types of Numeric Formats. General Number Currency Accounting
1. 8. Date Time. Percentage Fraction Scientific Text Special Custom.
9Hands-On Exercise 1. Objective: To start Microsoft Excel, to Exploring Microsoft Excel 2002 Chapter 1. 20.
open, modify, and save an existing workbook Welcome to Windows 21Format Cells Command. Exploring Microsoft Excel 2002 Chapter
Obtain the practice files Start Microsoft Excel Open the 1. 21.
workbook The Save As command The Active Cell, Formula Bar and 22Hands-On Exercise 4. Objective: to format a worksheet using
Worksheet tabs Experiment (What If?) The Office Assistant. boldface, italics, shading, and borders; to change the font
Exploring Microsoft Excel 2002 Chapter 1. 9. and/or alignment of an entry. Center the title across selection
10Modifying the Worksheet. Insert command can be used to add Format the exam weights Format the class averages Borders and
individual rows, columns, or cells. Exploring Microsoft Excel color Print the workbook Use the Page Setup command to modify
2002 Chapter 1. 10. the appearance of the printed workbook Print the cell formulas.
11Modifying the Worksheet. Delete command can be used to Exploring Microsoft Excel 2002 Chapter 1. 22.
delete individual rows, columns, or cells. Exploring Microsoft 23Summary (1 of 2). Spreadsheet is computerized accountant’s
Excel 2002 Chapter 1. 11. ledger Spreadsheet is generic term; worksheet is an Excel term
12Modifying the Worksheet. Page Setup command and dialog box A Cells contain formulas or constants A formula always begins with
dialog box lets you give information to Excel. Exploring an equal sign Formulas can be copied or moved anywhere within
Microsoft Excel 2002 Chapter 1. 12. the worksheet. Make sure you understand absolute, relative, and
13Hands-On Exercise 2. Objective: To open an existing mixed cell referencing and when to use each!! Exploring
workbook; to insert and delete rows and columns;to modify the Microsoft Excel 2002 Chapter 1. 23.
appearance of a printed workbook. Open the workbook Delete a row 24Summary (2 or 2). Page Setup gives you control over the
Insert a row Use the AutoComplete feature Insert a column appearance of the printed worksheet Formatting is done by
Display the cell formulas The Page Setup command The Print selecting the cell(s) you want to format, then applying the
Preview command Insert and Delete a worksheet. Exploring format you want Use the Ctrl key to select non-contiguous cells
Microsoft Excel 2002 Chapter 1. 13. or ranges of cells Print worksheets with displayed values and
14Excel Features and Commands (1 of 2). Active cell cell is formulas. Exploring Microsoft Excel 2002 Chapter 1. 24.
«Microsoft Excel» | Microsoft Excel.ppt
http://900igr.net/kartinki/informatika/Microsoft-Excel/Microsoft-Excel.html
cсылка на страницу

Excel

другие презентации об Excel

«Построение графиков функций в Excel» - В). Показательная и логарифмическая функции. 1 а. Б). В, д. А). В ходе урока набираются баллы за каждый этап урока и в итоге суммируются. Г). 11 класс. 5.12.08.

«Таблица диаграмма» - Задание 5. Графики придают наглядность числовым зависимостям. Задание 4. Введите количество предметов. Сравните полученные результаты. Отформатируйте таблицу. Графическая обработка данных в табличном процессоре MS EXCEL. Постройте график функции y=cos(3x+4), задав значения аргумента х из промежутка [-3,14;3,14] с шагом 0,5.

«Функции Excel» - Способы оценки. Правила ввода формул. ВЫВОД: Освоение MS Excel позволит библиотекарю. Вставка, функция. Примеры использование диаграмм: наглядное представление структуры библиотечного фонда. А10, 2. Дидактические материалы по теме «Функции в приложении MS Excel». Некоторые функции Excel: Использование статистических функций для анализа данных.

«Excel» - Мастер создания диаграмм. Возможности EXCEL: Пакет делопроизводства Microsoft Office. Работа с несколькими рабочими листами. Создание и использование простых формул. 4. Структура документа Excel. 2. Печать готового документа. Ячейка. Электронные таблицы MS EXCEL. Ярлычки рабочих листов. Номер текущей ячейки.

«Линейное программирование» - 2. Введем формулу вычисления значений целевой функции Например, в ячейку А8. Впервые симплексный метод был предложен американским ученым Дж. Один из создателей линейного программирования. Срс. Ответы: Решение задач линейного программирования в MS Excel. 1. Данцигом в 1949 г. На рисунке: оптимальное решение находится в одной из вершин многоугольника решений А, В, С, D.

«Решение уравнений в Excel» - Практическая работа. Х3 – 2х2 + 4х – 12 = 0. Х5 –4х4 –18х3 +40х2 +113х+ 60 = 0. Применение MS Excel. Х = 1, 13- 12- 4·1+ 4= 0, Самостоятельная работа. 2х 3 – х 2 – 20х + 15 = 0. х 3- х2- 4х +4 = ( х - 1)( х2 - 4), х - 1= 0, х2 – 4 = 0. х1=1, х2= 2, х3= - 2. Ответ: х1=1, х2= 2, х3= - 2. Интегрированный урок математики и информатики.

Урок

Информатика

126 тем
Картинки
Презентация: Microsoft Excel | Тема: Excel | Урок: Информатика | Вид: Картинки