Excel By Dr Farrokh Alemi Dr Kashif Haqqi

Excel By Dr. Farrokh Alemi Dr. Kashif Haqqi Jump to first page

Spreadsheet

Why on a Computer? Change the Car Payment Change the Utilities

Basics of Spreadsheet

What is a Column?

What is a Row?

What is a Cell?

Types of Data types Examples Descriptions LABEL Names or Wages or Days Any thing that is just text CONSTAN T 5 or 3. 45 or – 2. 9 Any number FORMULA = 5+3 or 4 -2*9 Math equation

Labels in Excel

Constants in Excel

Formulas in Excel • Formulas OR Functions MUST BEGIN with an equal sign (=).

Formulas in Excel

Basic Formulas in Excel n n n Equation in B 4 = B 1 * B 2 = 23 * 5. 36

Change in Formulas - Hours have been changed to 34 - Wage is the same - Total pay would now be = 34 * 5. 36 - But would still be = B 1 * B 2

Change in Formulas First Equation Changed Equation

Basic Math Functions Operations Symbol Constant Data Referenced Data Answer Multiplication * =5*6 = A 1* B 3 30 Division / =8/4 = A 3 / B 2 2 Addition + =4+7 = B 2 + A 2 11 Subtraction - =8 -3 = A 3 - B 1 5

Methods of Selecting Cells n n Type in the cell Click on the cell

Methods of Selecting Cells To select Type in Click on A 1 A 1, A 2, A 3 A 1: A 3 click on A 1, with button down drag to A 3 A 1, B 1 A 1: B 1 click on A 1, with button down drag to B 1 A 1, B 3 click on A 1, type in comma, click on B 3 A 1, A 2, B 1, B 3 A 1: B 2 click on A 1, with button down, drag to B 2 click on A 1