Chapter 2 Key Points

Project 2A

  1. To insert multiple columns (or rows), if you select the same number of columns (rows), then when you do an insert, that number of columns or rows is inserted, rather than just inserting one column or row
  2. Flash Fill can be used to split a column of information; thus if you have a column consisting of first and last names, you can split this into one column with first names and another with last names, which usually is preferable, e.g. it permits sorting by the last name..
  3. SUM, AVERAGE, MEDIAN, MIN, MAX statistical functions
  4. A series of # symbols in a column indicates that the cell width is too narrow to display the entire number; this can be fixed by double-clicking the right boundary of the column to AutoFit the column to display the widest entry.
  5. Pressing F4 repeats the last action, e.g. you can insert a row and then hit F4 twice to insert two more rows.
  6. The COUNT function counts the number of cells in a range that contain numbers. The COUNTIF function counts the number of cells in a range that meets a condition you specify - the first argument specifies the range, the second argument specifies the condition.
  7. The IF function has three arguments (condition, value if true, value if false) - the condition can use the comparison operators of =, >, <, >=, <=, and <> (not equal to)
  8. A conditional format changes the appearance of a cell based on a condition; if the condition is true, the formatting is applied, otherwise not.
  9. A data bar provides a visual cue about the value of a cell relative to other cells; the length of the data bar represents the value in the cell.
  10. The NOW() function recalculates each time a workbook opens.
  11. View>Window Group>Freeze Panes allows you to select one or more rows or columns and freeze them so they will not move when you scroll. You can freeze both rows and columns at the same time by clicking a cell and then clicking the Freeze Panes command. This is useful if the rows or columns contain header information you want to be always visible.
  12. Within a Worksheet, you can convert a range of cells to an Excel table which allows you to manage this data independently from the data in other rows and columns in the worksheet. Click in the Worksheet, and then choose Insert>Table (in the Tables group). You will usually want to select the "My Table has headers" check box. You can sort an Excel table by clicking on the arrows in the header row of the table. If you sort on one column in the table, and then sort on another, the sort by the first category is maintained within each category of the second sort.
  13. You can filter Excel tables, so that only the data that matches the criteria you specify. You can apply multiple filters.
  14. You can split the window horizontally and vertically so as to see distant parts of your worksheet at the same time. Click in the workbook where you want the split to occur, and then on the View tab, in the Window group, click Split.
  15. When printing a worksheet that will result in several pages, in the Page Setup group, click Print Titles, and then click in the Rows to repeat at top box. Alternatively in the Print Preview area, at the bottom of the Settings group, click the No Scaling arrow and then point to Fit All Columns on One Page.

revised: 9/14/2021. Comments to Bill Pegram, wpegram@nvcc.edu