Chapter 1, Part A- Key Points
- A cell is the intersection of a row and column - it is referred to by using the column first (a letter for the first 26 columns, then two letters for the next 26X26=676 columns, 3 letters for more columns - the last column is XFD for a total of 16,384 columns) followed by the row (a number) - e.g. a3 (pp. 61)
- When you click on a cell, the cell reference is displayed in the Name Box. Pressing Enter moves the active cell to the one below. You can make a cell the active cell by typing the cell reference in the Name Box and pressing Enter.
- Left alignment is the default for text values.
- AutoComplete can help you enter alphabetic values.
- Cell references and function names aren't case sensitive; thus a3 or A3 can be used interchangeably, as can sum() and SUM().
- A cell contains either a constant value (text or numbers) or a formula.
- A formula begins with an equal (=) sign
- A formula should almost always reference cells rather the literal that is currently in the cell, thus a3 rather than 10; this means the formula will work when the cell contents change
- A formula can use mathematical notation, e.g. + for addition, or Excel functions, such as the sum function
- A range is often used in an Excel function, specifying the beginning and ending cells of cells which are adjacent to each other, e.g. SUM(B3:B7)
- Formulas can be copied from one cell to another, either by using the Fill Handle or by CtrlC to copy, CtrlV to paste
- When a formula is copied to a new location, the cells referenced in the new location will have the same relative position to the original cells as the location of the new formula to the old formula
- Data displayed in a cell is the displayed value; data that displays in the Formula Bar is the underlying value. Calculations on the cell contents will always performed on the underlying value.
- There are several number formats, e.g. Accounting Number Format and Comma Style.
- When doing an Excel chart, one generally does not select cells in a Total row or column.
- The choice of chart type should be made on what comparison will be the most meaningful to the reader; using the Switch Row/Column command moves data charted on the vertical axis to the horizontal axis, and vice versa.
- Workbook themes are predefined sets of colors, fonts, lines, and fill effects. Cell styles are predefined combinations of font, font size, and color. Chart styles are predefined combinations for charts.
Revised: September 14, 2021