Икт 600-675

*!Relation address and its example in Excel

• *second line of column F

• *a cell address, the containing constant 

• *the address containing circular references

• *the address to which it is impossible to refer in a formula

• *the address which doesn't change in case of relocation of formulas from one table in other table

*!The absolute address and its example in Excel 

• *a cell address, the containing constant

• *the address depending on data type in a cell

• *the address to which it is possible to refer in a formula

• *before the second line of a column F and a column F the dollar sign is written

• *the address which is adjusted in case of relocation of formulas from one into another

*!MSExcel. Copying of the selected cell

• *press CTRL+Y

• *press CTRL+C

• *home-insert cells

• *home-cells-insert

• *home-clipboard-insert

*!MSExcel. Possible variant of the date format 

• *32/08/2014

• *30/32/1996

• *14/13/1999

• *30/02/2015

• *05.12.1996

*!MSAccess. To load the application

• *Start-Accessories-MS Office-MS Office Access

• *Start-All programs-Accessories-MSOfficeAccess

• *Double click onMSOfficeAccessshortcut on desktop

• *Start-Servise-Application programs - MS Office Access

• *Context menu-Create-MSOfficeAccess 2007 Database

*!MS РowerРoint. Name tab:

• *table

• *home

• *illustration

• *formula

• *data tools

*!MS Access. In the database operation which are executed with the record

• *sortings

• *operation

• *search in a key

• *design

• *prediction

*!MS РowerРoint.Group of command of the animation tab  

• *background

• *subjects

• *monitors

• *viewing

• *parameters of pages

*!MS Power Point. Break presentation:

• *PLUS

• *ALT+TAB

• *SHIFT+ALT

• *CTRL+BREAK 

• *END CTRL+ALT

*!MS РowerРoint. List of tabs:

• *table

• *home

• *illustrations

• *page marking

• *operation with databases