1 / 17
Télécharger la présentation

Bellringer : Try these:

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Bellringer: Try these: • Determine what Excel formula would be used to solve the following problems. Write your answers in the spaces provided on your note sheet. • Assigns the sum of cells D4 and A2 to the active cell • Assigns the difference between cells P4 and G4 to the active cell

  2. Excel Formulas Standards: 3.7.10CD-Apply basic computer operations and utilize software to solve specific problems 2.8.8F-Solve equations using computer spreadsheets

  3. Formulas • Formula- the equations used to calculate values in a cell

  4. Formulas • A formula consists of two components: • Operand- a number or cell reference used in formulas • Operator- tells excel what to do with the operands

  5. Formulas • Example: In the following formula: =B3+5 • B3 and 5 are: operands • + is the: operator that tells Excel what to do with the operands

  6. Formulas • Operator + • Operation addition • Example =B5+C5 • Meaning adds the values in B5 and C5

  7. Formulas • Operator - • Operation subtraction • Example =C8-232 • Meaning subtracts 232 from the value in C8

  8. Formulas • Operator * • Operation multiplication • Example =D4*D5 • Meaning multiplies the value in D4 by the value in D5

  9. Formulas • Operator / • Operation division • Example =E6/4 • Meaning divides the value in E6 by 4

  10. Formulas • Operator ^ • Operation exponentiation • Example =B3^3 • Meaning raises the value in B3 to the 3rd power…B3*B3*B3

  11. Two methods for entering formulas • Key the numbers or cell references • Can be keyed in uppercase (A1), or lowercase (a1) • Point and click • Must end formula by pressing enter or any clicking will result in a change in the formula

  12. Order of Operations • Order of operations- the sequence used to calculate the value of a formula • First- exponentiation (^) • Second- positive or negative (+ or -) • Third- multiplication or division (* or /) • Fourth- addition or subtraction (+ or -)

  13. Copying Formulas • You can copy formulas by using: • Copy/Cut and paste • The Fill Handle • Can fill down or across

  14. Relative, Absolute, and Mixed Cell Reference • Relative cell reference- adjusts to its new location when copied or moved • Example: • When in column A =a1+a2 • When copied to column B =b1+b2

  15. Relative, Absolute, and Mixed Cell Reference • Absolute cell reference- does not change when moved or copied to a new cell • Example: • When in column A =$a$1+$a$2 • When copied to column B =$a$1+$a$2

  16. Relative, Absolute, and Mixed Cell Reference • Mixed cell reference- $ before the row or column reference = they will not change when moved or copied; no $ = formulas will adjust relative to the cell to which they are copied • Example: • When in column A = $a$1+a2 • When copied to column B =$a$1+b2

  17. Practice Determine what Excel formula would be used to solve the following problems. • 1. Assigns the sum of 12 and 9 to the active cell • 2. Assigns 6 times the contents of cell E22 to the active cell • 3. Assigns the product of 5 times the difference between the values in cells A1 and A2 • 4. Assigns the negative value of the product of the values contained in cells G7 and V67 to the active cell

More Related