In recent years, new “smart” technologies have appeared: smart phones, smart homes, refrigerators, phone cases, televisions, etc. Spreadsheets are no exception. Excel spreadsheets have been introduced since 2010.
The concept of smart tables
The Excel workbook itself is a huge spreadsheet. However, this table requires constant adjustment: drawing out formulas, sorting, design, if this table needs to be presented in any document or presentation.
Microsoft Corporation, which created Excel, proposed calling smart tables tables, and what was previously called tables is a range. However, in our country, these ideas did not take root, so the tables remained tables, and the innovation was called smart tables.
, , .
Excel
, Excel. , "" , "", " ".
, - , .
, , , (""), " ".
"" Enter.
.
, Excel.
.
, .
, , "", " " " ".
" " "".
"". , .
. .
, " ", " " " ". , , .
, Excel .
, , , , . . .
Excel.
, , , . .
Excel ? , .
"", " ". , " " .
, .
, , " ".
Excel 2010 , Excel 2007 .
. "", " ", / : " ", " ", " ", " ".
Excel . , .
, , , . [@[{ }]] .
{ } - , , ", .", - , Excel , , , @ - , .
Excel, , .
Enter .
"" " " " ", , .
, , , . , - , .
, Excel , , , , . , , "", "", "", " " . . .
, , . . , "" "", . , , . , "" , .
Excel , ( "1" . .).
, , "", "" " ", , "1" , , Enter.
, , .
, . , , 1229- . - , K1, 1229, L1 =(K1;1 ( );1). 1 - , . L1 . . . №1229 (, , ).
Excel . , C 1- 21- , , Excel = (C1:C21). , , , ", .", "". , : = ([, .]).
, :
- «=[# ]» .
- «=[#]» , .
- «=[#]» , .
- «=[#]» ( ).
- «=[#]» , .
, , =([#]).
""
, .
Excel 2010 . , . "", "", " ", ( ), . , Ctrl.
Excel
, , , , , .
Excel . , "", "", " ".
, Enter. .
, , . , , . , .