{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel07_L1_Ch2

# Excel07_L1_Ch2 - EXCEL 2007 Chapter 2 LINKSTO OBJECTIVES...

This preview shows pages 1–8. Sign up to view the full content.

Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-1    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Write Formulas with Absolute and Mixed Features Summary Microsoft Excel 2007 – Level 1 INSERTING FORMULAS  IN A WORKSHEET

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-2    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Write Formulas with Absolute and Mixed Features Summary Performance Objectives Performance Objectives Write formulas with mathematical operators Type a formula in the Formula bar Copy a formula Use the Insert Function feature to insert a formula in a cell Write formulas with the AVERAGE, MAX, MIN, COUNT, PMT, FV, DATE, NOW, and IF functions Create an absolute and mixed cell reference
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-3    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Financial Functions Absolute and Mixed Features Summary Mathematical Operators Mathematical Operators + Addition - Subtraction * Multiplication / Division % Percent ^ Exponentiation Order of Operations Negation Percent Exponentiation Multiplication, Division, left to right Addition, Subtraction , left to right Use parentheses to override the  Order of Operations

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-4    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Financial Functions Absolute and Mixed Features Summary Writing Formulas Writing Formulas Begin with the equal (=) sign Then type remainder  of formula Select cell that is to contain a formula
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-5    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Financial Functions Absolute and Mixed Features Summary Typing in the Formula Bar Typing in the Formula Bar Formulas can also be entered directly in the Formula bar Formula bar always displays formula, while active cell displays the formatted result of the  formula

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Copyright 2007, Paradigm Publishing Inc. EXCEL 2007 Chapter 2 BACK NEXT EN 2-6    LINKS TO  OBJECTIVES Mathematical Oper Formula Bar Copy a Formula Insert Function Fea Write Formulas with Absolute and Mixed Features Summary Copying Cells or a Formula Copying Cells or a Formula 1. Select cells to copy from 3. Select area to  paste copied cells  into 2. Click Copy button or press  Ctrl + C 4. Click Paste  button or press  Ctrl + V

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern