Microsoft Excel Performed: Kerimbayeva Dana Group: 145. - презентация

1 Microsoft Excel Performed: Kerimbayeva Dana Group: 145

2 Quite often we have to present processed information in the form of tables. Spreadsheet is a program designed to automate table calculations. The program Microsoft Excel is part of Microsoft Office, is running Microsoft Windows, and was created in 1987.

3 Download application, open and save documents as standard Document MS Excel-file with extension *. xls, document without name is called Book 1, book2... The file of MS Excel icon looks like The file of MS Excel

4 The workbook consists of sheets, Sheet1, Sheet2,..., Sheet 255, whose tags are located at the bottom of the window From the Tools-Options-General menu, you can specify the number of sheets in the new workbook (three by default) The book of MS Excel

5 It is convenient to add, rename, delete sheets, using a context menu of a label Sheets of MS Excel

6 A sheet is a table consisting of 256 rows and rows. The columns are called Latin letters(А,В,С, …, АА,АВ,…). The rows are denoted by natural numbers (1,2, …, 65536). A sheet of MS Excel

7 A cell is the primary spreadsheet object at the intersection of a column and row. The cell address is composed of the column number and row number: The cell

8 Current cell One of these table cells is always current. The current (active, working) cell is always highlighted, its address is highlighted in the Name field, and the contents are displayed in the Line of formulas.

9 The Line of formulas The Window elements

10 The line of formulas Current cell name/function list

11 The line of formulas Cancellation (Esc)

12 The line of formulas Input (Enter)

13 The line of formulas insert of functions

14 The line of formulas Line of formulas

15 Buttons A, B, …, AA, …, Нeadings of columns

16 Headings of lines Buttons 1, 2, …,

17 Movement according to the table Use the following keys to navigate the table: 3. Enter 3. Enter 2.Shift+Tab 4.Shift+Enter Using cursor keys and clicking does not always allow you to navigate to another cell 1. Tab

18 Сolumn width To change the width of a column: 1. Drag border; 2. Double-click the boundary; 3. Select Format-Column-Width from the menu. The column width is measured in characters.

19 Select Row Select a column Select a column Selection Methods

20 Select Adjacent Diaposone А1:D3 Non-contiguous diaposone isolation A1; В3

21 Selection Methods Allocation of all table

22 Тypes of the mouse pointer allocation text copying autocompletion movement change of width of a column