D. This section lets you toggle whether the automatic grids appear for working on the sheet and for printing it, along with the row and column headings (A, B, C, 1, 2, 3, etc).
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.
Conditional formatting is a bit more complex. Use the drop_down menu to select from a range of options, like inserting helpful visual icons to represent status or completion, or changing the color of different rows. Most important are the conditional rules, which are created with a simple logic. For example, lets say you have a column with data in A1 through A3, and A4 holds the sum of these three cells. You could place formatting on A4 with a rule that says “if A4 > 0, then highlight A4 green.” Then, you could add another rule that says “if A4 < 0, then highlight A4 red.” Now you have a quick visual reference where green = a positive number and red = a negative number, which will change based on what you enter into A1, A2, and A3.
Sort & Filter tools let you choose what to display, and in what order. At the base level, this tool sorts cells containing text from A to Z, and cells containing numbers from lowest to highest. It can also sort by color or icon. Sorting and filtering helps surface only the data you need.