G. Viewability Options: The left icon is Normal which shows the worksheet as it appears in the image above, and the right icon is Page Layout, which divides your worksheet into pages resembling how it would look when printed, with the option to add headers. The slider with the “_” and “+” on it is for scale or zoom_level. Drag the slider left or right to zoom in or out.
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.
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.
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).