620 likes | 640 Views
Excel – Part One IS 240. Competencies. Load Excel for Windows 95. Use toolbars. Move around the worksheet. Design a worksheet. Enter data. Delete and edit cell entries. Open and close workbooks. Copy data. Enter formulas. Competencies. Recalculate a worksheet.
E N D
Excel – Part One IS 240
Competencies • Load Excel for Windows 95. • Use toolbars. • Move around the worksheet. • Design a worksheet. • Enter data. • Delete and edit cell entries. • Open and close workbooks. • Copy data. • Enter formulas.
Competencies • Recalculate a worksheet. • Change cell alignment. • Document, save and print a workbook. • Exit the Excel program.
Definition of Electronic Spreadsheets • Automated version of accountant’s ledger • Composed of rows and columns or primarily numeric data • Formulas based on cell references, so easy to update results • Easy to store, retrieve and print results
Alignment data’s position to the left, centered or right of a cell Electronic Spreadsheet Terminology
Alignment Cell - Columns vertical blocks of cells identified by letter data’s position to the left, centered or right of a cell space created by intersection of horizontal row and vertical column Electronic Spreadsheet Terminology
Copy duplicates contents of cell or cell to another location Electronic Spreadsheet Terminology
Copy File linking duplicates contents of cell or cell to another location creates a connection between two files to share data Electronic Spreadsheet Terminology
Format cell styles that control the appearance of the data there Electronic Spreadsheet Terminology
Format Formula cell styles that control the appearance of the data there entry performing a calculation Electronic Spreadsheet Terminology
Format Formula Function cell styles that control the appearance of the data there entry performing a calculation built-in formula Electronic Spreadsheet Terminology
Format Formula Function Graph cell styles that control the appearance of the data there entry performing a calculation built-in formula visual representation of data ranges in a worksheet Electronic Spreadsheet Terminology
Label entry consisting of text and numeric characters Electronic Spreadsheet Terminology
Label Move entry consisting of text and numeric characters relocates cell contents to another worksheet location Electronic Spreadsheet Terminology
Label Move Rows entry consisting of text and numeric characters relocates cell contents to another worksheet location horizontal blocks of cells identified by number Electronic Spreadsheet Terminology
Value numerical entry, or one resulting from a formula or function Electronic Spreadsheet Terminology
Value What-if Analysis numerical entry, or one resulting from a formula or function process of evaluating effects of changing one or more values in formulas to help in decision making and planning Electronic Spreadsheet Terminology
move handle Minimize, Restore/Maximum Close buttons menu bar Standard tool bar formula bar Formatting tool bar drawing tool bar Status bar work area Office Assistant
Using Office Assistant Office Assistant
Arrow keys Moves cell selector one cell in direction of arrow Moving Around the Worksheet
Arrow keys Alt + Pg Dn Moves cell selector one cell in direction of arrow Moves cell selector right one full window Moving Around the Worksheet
Arrow keys Alt + Pg Dn Alt + Pg Up Moves cell selector one cell in direction of arrow Moves cell selector right one full window Moves cell selector left one full window Moving Around the Worksheet
Pg Dn Moves cell selector down one full window Moving Around the Worksheet
Pg Dn Pg Up Moves cell selector down one full window Moves cell selector up one full window Moving Around the Worksheet
Pg Dn Pg Up Ctrl + Home Moves cell selector down one full window Moves cell selector up one full window Moves cell selector to cell in upper-left corner of worksheet Moving Around the Worksheet
Home Moves cell selector to beginning of row Moving Around the Worksheet
Home Pg Up Moves cell selector to beginning of row Moves cell selector to last used cell in row Moving Around the Worksheet
Home Pg Up Ctrl + Home Moves cell selector to beginning of row Moves cell selector to last used cell in row Moves cell selector to last used cell in column Moving Around the Worksheet
Design a Worksheet • Specify purpose - ID the input data required, and the desired output • Design and build - either on paper or in Excel, should include title, row label and column headings, and some sample data
Types of Data Entries • Text - any combination of letters, numbers, spaces, etc • Number - the digits 0 thru 9, plus any of the special characters such as +, _, /, $, %, etc. • Formula - perform calculations on data contained in other cells
Entering Data • Move the cell pointer to the desired location in spreadsheet work area • Press the appropriate keys • Press the Enter key
Enter button Cancel button formula bar displays entry active cell displays entry and insertion point
text entries are left-aligned in cell space cell selector moves down to next cell after Enter is pressed
Delete and Edit Cell Entries • While still typing and before pressing enter • Escape, or Backspace • To delete an entry, press the Delete key • To edit a cell entry, press the F2 key, or double click
Home Moves insertion point to beginning of entry Key Strokes in Edit Mode
Home End Moves insertion point to beginning of entry Moves insertion point to end of entry Key Strokes in Edit Mode
Home End -> Moves insertion point to beginning of entry Moves insertion point to end of entry Moves insertion point one character right Key Strokes in Edit Mode
Home End -> <- Moves insertion point to beginning of entry Moves insertion point to end of entry Moves insertion point one character right Moves insertion point one character left Key Strokes in Edit Mode
Open and Close Workbooks • Open Workbook • File, Open • File Name • Close Workbook • File, Close
Delete and edit cell entries • Highlight cell • Delete key • Edit, Cut • Highlight cell • F2 key • Double mouse click
Cutting, Copying and Pasting Data • Cut - cell contents deleted from the cell location, but stored in the Clipboard • Copy - copy of cell contents stored in the Clipboard • Paste - contents of the Clipboard transferred to the destination cell location
Enter Formulas • Entries that perform calculations • Result of the calculation is displayed in the cell containing the formula • Always begins with an = sign, which tells Excel that a numeric operation follows
Enter Formulas • With multi operator formulas the order of precedence is • Exponents • Multiplication • Division • Addition • Subtraction
Enter Formulas • Operands - the values or cell references that the numeric operators operate on
+ for addition Numeric Operators