Excel
<<  MS Excel Microsoft Excel  >>
Microsoft Excel
Microsoft Excel
The Basics
The Basics
The Title Bar is located at the very top of the screen
The Title Bar is located at the very top of the screen
The Title Bar is located at the very top of the screen
The Title Bar is located at the very top of the screen
Toolbars
Toolbars
Toolbars
Toolbars
Toolbars
Toolbars
Microsoft Excel consists of worksheets
Microsoft Excel consists of worksheets
CELLS
CELLS
Brief descriptions of format types can be seen at the bottom of the
Brief descriptions of format types can be seen at the bottom of the
Type a number into cell 1A, right click on the cell, and select
Type a number into cell 1A, right click on the cell, and select
Excel Help
Excel Help
Microsoft Excel
Microsoft Excel
Open the file called Staff
Open the file called Staff
Resize the columns so that you can see more of the data…
Resize the columns so that you can see more of the data…
Sorting data is sometimes necessary
Sorting data is sometimes necessary
Microsoft Excel
Microsoft Excel
Insert an additional worksheet inside this workbook
Insert an additional worksheet inside this workbook
You can rename the new sheet by right clicking on its tab at the
You can rename the new sheet by right clicking on its tab at the
Highlight and copy the data from cell B9 through E18
Highlight and copy the data from cell B9 through E18
Right click on the new worksheet, then select paste from the drop down
Right click on the new worksheet, then select paste from the drop down
The “Fill” Feature
The “Fill” Feature
Charts and Graphs
Charts and Graphs
You can also launch the Chart Wizard by selecting Insert/Chart
You can also launch the Chart Wizard by selecting Insert/Chart
Notice that the Chart toolbar appears when you insert a chart
Notice that the Chart toolbar appears when you insert a chart
Looking at cell I19, we can see that there are no special functions
Looking at cell I19, we can see that there are no special functions
In this case, you can simply click on the Autosum button while cell
In this case, you can simply click on the Autosum button while cell
The same can be done using a formula, instead of a function
The same can be done using a formula, instead of a function
A variety of functions are available
A variety of functions are available
Click on the small down arrow next to the function symbol (the
Click on the small down arrow next to the function symbol (the
One more thing about formulas and functions: You can utilize data from
One more thing about formulas and functions: You can utilize data from
Page Setup dialog box
Page Setup dialog box
To see all printing options, make sure you select print from the file
To see all printing options, make sure you select print from the file
Картинки из презентации «Microsoft Excel» к уроку информатики на тему «Excel»

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

Microsoft Excel

содержание презентации «Microsoft Excel.ppt»
Сл Текст Сл Текст
1Microsoft Excel. The Basics. 13data. Data can be separated using… Commas
2spreadsheet A type of application (.csv) Tabs or spaces (.txt).
program which manipulates numerical and 14Open the file called Staff.csv.
string data in rows and columns of cells. 15Resize the columns so that you can see
The value in a cell can be calculated from more of the data…
a formula which can involve other cells. A 16Sorting data is sometimes necessary.
value is recalculated automatically This data is currently in alphabetical
whenever a value on which it depends order by last name. Sort it by city
changes. Different cells may be displayed instead.
with different formats. The Free On-line 17
Dictionary of Computing, © 1993-2003 Denis 18Close all spreadsheets. Open the file
Howe. “sample5yr4cast.csv.”.
3Workbook A booklet containing problems 19Insert an additional worksheet inside
and exercises that a student may work this workbook. Click on Insert/Worksheet.
directly on the pages. 2. A manual 20You can rename the new sheet by right
containing operating instructions, as for clicking on its tab at the bottom, and
an appliance or machine. 3. A book in selecting “Rename” from the menu.
which a record is kept of work proposed or 21Highlight and copy the data from cell
accomplished. Worksheet A sheet of paper B9 through E18. Paste it on the new sheet.
with multiple columns; used by an 22Right click on the new worksheet, then
accountant to assemble figures for select paste from the drop down menu.
financial statements. A piece of paper 23The “Fill” Feature. You can quickly
recording work planned or done on a fill in several types of data series by
project. http://www.dictionary.com. selecting cells and dragging the fill
4The Basics. Open Excel. By default, handle or by using the Series command
Excel will open a blank workbook that (point to Fill on the Edit menu, and then
contains three worksheets (spreadsheets). click Series).
Each box, located in both a column and a 24Charts and Graphs. Highlight the data
row, is called a cell. you want to graphically represent. Then
5The Title Bar is located at the very click the chart wizard icon on your
top of the screen. On the Title bar, toolbar.
Microsoft Excel displays the name of the 25You can also launch the Chart Wizard
workbook you are currently using. At the by selecting Insert/Chart.
top of your screen, you should see 26Notice that the Chart toolbar appears
"Microsoft Excel - Book1" or a when you insert a chart. You can edit the
similar name. The Menu Bar is directly charts properties at any time.
below the Title bar and displays the menu. 27Formulas and Functions. Formulas are
The menu begins with the word File and equations that perform calculations on
continues with the following: Edit, View, values in your worksheet. A formula starts
Insert, Format, Tools, Data, Window, and with an equal sign (=). For example, the
Help. You use the menu to give following formula multiplies 2 by 3 and
instructions to the software. Point with then adds 5 to the result. =5+2*3
your mouse to a menu option and click the Functions are predefined formulas that
left mouse button. A drop-down menu will perform calculations by using specific
appear. You can now use the left and right values, called arguments, in a particular
arrow keys on your keyboard to move left order, or structure. Functions can be used
and right across the Menu bar options. You to perform simple or complex calculations.
can use the up and down arrow keys to move 28Looking at cell I19, we can see that
up and down the drop-down menu. To select there are no special functions associated
an option, highlight the item on the with the data. Using a simple function can
drop-down menu and press Enter. help make regular updates to the data
6Toolbars. easier.
7Microsoft Excel consists of 29In this case, you can simply click on
worksheets. Each worksheet contains the Autosum button while cell I19 is
columns and rows. The columns are lettered selected, and Excel will identify the
A to IV; the rows are numbered 1 to 65536. which cells to include when calculating a
The combination of column and row total revenue figure for FY2005. Hit enter
coordinates make up a cell address. For to lock the sum in. Notice that the
example, the cell located in the upper function reads: =SUM(I12:I18).
left corner of the worksheet is cell A1, 30The same can be done using a formula,
meaning column A, row 1. Cell E10 is instead of a function.
located under column E on row 10. You =I12+I13+I14+I15+I16+I17+I18 This long
enter your data into the cells on the expression helps to show why functions are
worksheet. handy tools.
8CELLS. Cells can be formatted to help 31A variety of functions are available.
handle various types of data. Right click In cell L21, I can use the average
on a single cell, or a group of cells, and function to determine a yearly average for
select “Format Cells” from the drop down forecasted revenue. fx=AVERAGE(I19:K19) or
menu. fx=AVERAGE(I19, J19, K19) or
9Brief descriptions of format types can fx=(I19+J19+K19)/3.
be seen at the bottom of the dialog box. 32Click on the small down arrow next to
Take a moment to look through the various the function symbol (the epsilon). Select
formatting options. Click cancel when “More Functions.”.
you’re done. 33One more thing about formulas and
10Type a number into cell 1A, right functions: You can utilize data from other
click on the cell, and select “Format worksheets in order to populate cells. The
Cells.” Note that a sample format is shown figure in cell c16 is the sum of I19
on the top right of the dialog box. You through k19 on worksheet sample5yr4cast.
can adjust the number of decimal places =SUM(sample5yr4cast!I19:K19).
and any preceding symbols. 34Page Setup dialog box. Click on
11Excel Help. File/Page Setup.
12 35To see all printing options, make sure
13Working With Data. Data that is you select print from the file menu.
organized in columns or rows can utilize Clicking on the printer icon on your
various formatting methods. Microsoft toolbar will allow to print directly to
Excel can import these various types of your default printer with default options.
Microsoft Excel.ppt
http://900igr.net/kartinka/informatika/microsoft-excel-265208.html
cсылка на страницу

Microsoft Excel

другие презентации на тему «Microsoft Excel»

«Таблицы MS Excel» - Свойства ячеек. Столбец. Строка. Microsoft excel – электронные таблицы. «Удобные» возможности MS Excel. Столбец заголовков строк. Ввод формул. Ячейка. Ввести знак (+, -, *, /). Есть ли еще данные для вычислений? Возможности MS Excel: Ввод данных в ячейку: Выделить ячейку; Ввести данные; Зафиксировать ввод.

«Диаграммы в Excel» - Можно также объединять основные типы диаграмм. Сортировка записей в базе данных. Шаг 1: выбор типа диаграммы. Выполнил: студент гр. Проблемные вопросы: Только ли с числами можно работать в Excel? После выполнения данных действий таблица будет выглядеть таким образом. Диаграмма. Что такое Microsoft Excel?

«Построение графиков функций в Excel» - Критерий оценивания. Решить графически уравнение. Задать формулой функции. Цели урока. Построение графиков функций средствами MS EXCEL. I Повторение. В ходе урока набираются баллы за каждый этап урока и в итоге суммируются. Решение показательных уравнений и неравенств. Алгоритм построения Построить таблицу значений у от х. Значение у вычисляется по формуле.

«Microsoft Excel 2007» - Procedure header. Printing Macro Procedures. Comments. Debugging a Macro (cont.). Current Module button. Summary. Microsoft Excel 2007 - Illustrated. Writing VBA Code (cont.). Comments begin with apostrophes. Comment points out error in next line of the procedure. Creating a Main Procedure. Creating a Main Procedure (cont.).

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

«Excel» - Ярлычки рабочих листов. Строка. Переход к другому листу выполняется щелчком на ярлыке. Столбец. Кнопки прокрутки ярлычков. Удаление Копирование Вставка Выделение Форматирование. Основные и производные данные. Строка формул. Количество копий. Возможности EXCEL: Мастер создания диаграмм. Создание диаграмм.

Excel

26 презентаций об Excel
Урок

Информатика

130 тем
Картинки