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.
That said, other formulas that reference a cell will take into account the current value of a cell. If A4 = A3 + 1, then it would be equal to 4, because it stacks the formula of A3 (A1 + A2) with A4 = A3 + 1. Formulas can reference other formulas multiple times.
E. Search Bar: Simply type the value you want to find to highlight all cells containing that value. It doesnt have to be an exact match. For instance, if you searched for “o,” a cell labeled “Dogs” would appear among your search results.
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).