![]() The group contains utilities for managing the system of external relations Group with a utility icon for receiving data from external sources Table briefly describes the groups presented on the Data tab. The Data tab is used when processing data, including data obtained from external sources. Group with an icon for performing calculation settings The group is designed to work with named cells, ranges and formulasĪ group with utilities for tracking cell relationships and finding errors in formulas Group of command icons for accessing basic built-in Excel functions The utilities, which are accessed through the Formulas tab, are widely used to create documents with non-trivial functional dependencies between cells in worksheets. Groups of the Formulas tab are presented in the table. To work with formulas and procedures, the Formulas tab is intended. The formulas, in turn, use all sorts of built-in Excel functions. Group with icons of commands for managing graphic objects in a documentĮven the most straightforward Excel document usually contains formulas. Group with options for defining the parameters of worksheets (including when printing) The group contains fields for setting the scaling parameters when printing documents Group with icons of commands for setting page parameters Group with icons of commands for selecting and using themes (predefined types of formatting and highlighting data at the document level) The truth of this statement becomes more obvious if you look at the table below, which lists the groups of the Page Layout tab. Most of the utilities implemented on the Page Layout tab are directly or indirectly related to the settings for printing documents. Group with a single pictogram for inserting symbols and formulas Group with pictograms for working with text Group with an icon for creating hyperlinks Slicers (new in Excel 2010) visually filter data in PivotTables More precisely, small diagrams, one cell in size, compact and informativeĪ new group in Excel 2010 that contains a Slicer icon. Sparklines are a symbiosis of charts and icons. The group is formed by a separate pictogram, new in the versionĮxcel 2010. The group contains icons of commands for inserting diagrams and working with them Group with pictograms for working with images Group for working with tables (as logical elements of a document) The group is designed to delete and insert rows and columns, select the height and width of cells, copy and delete worksheets,Īs well as performing a number of related operationsĪ group for sorting and grouping data, clearing the contents of cells and resetting formats, canceling comments, inserting functions, searching for data, etc. Group for performing customization of number formatsĪ group for creating styles and applying formats, including creating conditional formatting The group is intended for setting data alignment parameters in document cells The group contains icons for adjusting font parameters: type, size, color, selection, etc. ![]() Group with icons for performing operations with the clipboard: deleting, copying and pasting data
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |