1 / 14

INTRODUCTORY MICROSOFT EXCEL Lesson 4 Worksheet Formulas

2. Objectives. Enter and edit formulas.Distinguish between relative, absolute, and mixed cell references.Use the AutoSum button and the point-and-click method to enter formulas.Preview a calculation.Display formulas in the worksheet.Perform immediate and delayed calculations.. 3. Terms Used in

eldora
Download Presentation

INTRODUCTORY MICROSOFT EXCEL Lesson 4 Worksheet Formulas

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. 1 INTRODUCTORY MICROSOFT EXCEL Lesson 4 – Worksheet Formulas

    2. 2 Objectives Enter and edit formulas. Distinguish between relative, absolute, and mixed cell references. Use the AutoSum button and the point-and-click method to enter formulas. Preview a calculation. Display formulas in the worksheet. Perform immediate and delayed calculations.

    3. 3 Terms Used in This Lesson Absolute cell reference Formulas Mixed cell reference Operand Operator Order of evaluation Point-and-click method Relative cell reference

    4. 4 Enter and Edit Formulas A worksheet formula consists of two components: Operand is a number or cell reference used in formulas. Operator tells Excel what to do with the operands. For example, in the formula =B3+5, B3 and 5 are operands. The plus sign (+) is an operator.

    5. 5 Order Evaluation Contents within parentheses are evaluated first. Mathematical operators are evaluated in order of priority, as shown in Table 4-2. Equations are evaluated from left to right if two or more operators have the same order of evaluation.

    6. 6 Order Evaluation (cont.)

More Related