ITEC 1050 - Using Excel: Lab 2

Using Excel: Edit a worksheet

• Edit or delete data: add,insert,delete data; replace,delete all data in a cell.
• Move or copy data: using the mouse, using the toolbar buttons, using the keyboard; using paste options; using the clipboard task pane.
• Inserting a row or a column; Inserting several rows or columns in the same time; authomatic adjustment of formulas after inserting a row or a column.
• Delete a row or a column; delete several rows or columns; #REF!
• Undo, redo; shortcuts for undo, redo.
• Zoom in or out

Using Excel: Using Formula and Functions

• A formula always begins with a =
• Arithmetic operators: +, -, *, /, %, ^
• Comparison operators: =, >, <, <=, >=, <>
• Order of execution of operators: %, ^, * and /, + and -, comparison operators; or use paranthesis
• Functions: AVERAGE, COUNT, MAX, SUM; specifying individual cells (use of ,); specifying groups of cells (use of :)
• Entering a formula and seeing the formula in the formula bar; changing a the content of a cell used in a formula.
• Editing a formula: double click on a cell or use the formula bar.
• Entering cell references using point and click.
• Entering a function by using Insert Function dialog and using the Function Arguments dialog; entering a function directly.
• Perform common calculations using AutoSum button; Quickly add numbers by using the status bar
• Copy a formula; relative cell references, absolute cell references
• Error checks in formulas; #NAME; Error checking button (!)
• Common errors: ##### column is too narrow to display a number; #NAME? unrecognized function name or cell reference; #VALUE! a cell contains a value that cannot be used in a calculation; #DIV/0! division by 0; #REF! a formula refers a cell that is not valid.