F. Table or Sheet Formatting: Format as Table and Cell Styles allow you to use presets or customize tables (for example, with alternating row colors and highlighted header bars). Select your data range and choose a style to standardize formatting.
H. Miscellaneous Tools: Starting at the top left, theres AutoSum, which allows you to select a swath of cells and place the sum in the cell located right below or directly to the right of the last selected data point. You can use the drop_down to change the function to calculate the average, display the maximum, minimum, or the count of numbers selected.
B. Ribbon:This grey area is called the Ribbon, and contains tools for entering, manipulating, and visualizing data. There are also tabs that focus on specific features. Home is selected by default; click on the Insert, Page Layout, Formulas, Data, Review, or View tab to reveal a set of tools unique to each tab. Well cover this more in the “Navigating the Ribbon” section later on.
One powerful Excel feature is Macro, little scripts and recordings you can create to make the program perform different actions automatically. While no other spreadsheet program has this type of feature, it is complex and can pose difficulty for beginners.