G. Row and Column Formatting Tools: The Insert drop_down menu puts cells, rows, or columns before or after a selected area on the sheet, and Delete removes them. The Format drop_down lets you change the height of rows and the width of columns. It also has options for hiding and unhiding certain sections.
Excel also has close tie_ins with Microsoft Access, a database program, which can add power. In general, Excel integrates best with databases and any dataset requiring many calculations per workbook.
Unique Features of Excel _ With over 400 functions, Excel is more or less the most comprehensive spreadsheet option when it comes to pure calculations. It also has strong visualization abilities, including conditional formatting, Pivot Tables, SmartArt, graphs, and charts. Home and business users alike can create powerful spreadsheets and reports to track data and inform their decisions.
B. This section lets you insert visual elements, like picture files, pre_built shapes, and SmartArt. You can add shapes and resize, recolor, and reposition them to create intuitive data sets and reports. SmartArt objects are prebuilt diagrams that you can insert text and information into. Theyre great for representing what the data says in another place on your workbook.