Excel: Important Skills From Chapters 3, 4, and 5

Chapter3

• change the column width
• select a group of cells, including non-contiguous groups
• format cells: font, alignment, borders, patterns (shading), numbers (decimal point, currency, dates, etc.)
• merge and center
• toolbar buttons for formatting numbers
• format painter
• display format options (display formulas, turn gridlines off/on, turn row/col headers off/on)

Chapter 4

• basic built in functions: sum, average, count, min, max
• arguments for functions: list or range
• count function: counts cells with numbers (blank cells, cells with text not counted)
• average function: sum / count
• autosum button
• fill data
• fill formulas

Chapter 5

• delete rows/cols
• insert rows/cols
• add comment to cell
• view all comments, print comments
• copy & paste
• links

Email Me | Office Hours | My Home Page | Department Home | MCC Home Page

© Copyright Emmi Schatz 2007