SMS221 Lecture 1: NPExcel2016_M01_PPT
Document Summary
Introducing excel and spreadsheets: excel 2016 includes additional functions in several areas including basic math, trigonometry, statistics, look-up, and text functions. Working with worksheets: inserting a worksheet sheets in the workbook, deleting a worksheet, renaming a worksheet, 31 characters maximum, including blank spaces, width of sheet tab adjusts to length of name. Working with worksheets: moving and copying a worksheet, to move: Ctrl + drag and drop: place most important worksheets at beginning of workbook (leftmost sheet tabs), less important worksheets toward end (rightmost tabs) Entering text, dates, and numbers: new data appears in both the active cell and the formula bar, truncation, autocomplete feature, to enter multiple lines of text within a cell, create a line break with alt + enter. Editing cell content in edit mode: edit mode, double-click the cell to select the cell and switch to edit mode.