CIS 101 Lecture Notes - Lecture 1: Microsoft Excel, North American Numbering Plan
Document Summary
Excel (tool that allows you to enter quantitative data into an electronic w/s to apply math): converts quantitative data into information. Cell range (any two cell locations separated by a colon): what"s in a cell is what is written in the fx toolbar. Quick-access toolbar (provides access to most frequently used commands). Status bar (located below the worksheet tabs; performs functions for highlighted tabs). Auto-fill (useful when entering data in a defined sequence) Merge and center button to center titles, etc. Also, use format cells in this drop-down for easier access of number formatting, alignment, fonts, borders, fills, and protection. The delete key on keyboard can delete data from cells. Deleting a row or column using rt-click -> delete deletes formatting and entire row/column. Use the fill handle (black cross) of to fill in rows/columns with the same words or equations. Highlight which part of the equation you want to be locked.