ET_Q2_L9: Advanced Productivity Tools: Microsoft Excel

= (equal sign) > (greater than sign) < (less than sign) > = (greater than or equal to sign) < = (less than or equal to sign) < > (not equal to sign)

Comparison Operators:

Relative Cell References

change when a formula is copied to another cell.

Absolute cell references

remain constant, no matter where they are copied.

⊡The Equal (=) sign. This starts the formula. ⊡The Operator ⊡The Cell reference

An Excel Formula is made by the following elements.

+ (plus sign) - (minus sign) * (asterisk) / (forward slash) % (percent sign) ^ (caret)

Arithmetic Operators:

& (ampersand)

Connects, or concatenate, two values to produce one continuous text value

1. Operations enclosed in parenthesis 2. Exponential calculations 3. Multiplication and Division 4. Addition and Subtraction a. Remember PEMDAS rule

Excel calculates formulas based on the following order of operations:

⊡Arithmetic Operators ⊡Text Operator ⊡Comparative Operators ⊡Reference Operators

Excel uses four types of operators:

dollar ($)

In Excel, it is denoted by a what sign?

⊡Relative Cell References ⊡Absolute Cell References

In Excel, there are two types of references.

(space)

Intersection operator, which produces one reference to cells common to the two references

MS Excel

It is intended to be used to calculate numerical information such as the household budget, company finances, investments and many more.

maximize the capacity of Excel

Knowing how to execute both simple and complex formulas will allow you to?

: (colon)

Range operator, which produces one reference to all cells between two references, including the two references

: (colon) , (comma) (space)

Reference Operators:

$A$2

The Column and row do not change when copied

& (ampersand)

Text Operator:

A$2

The Row does not change

$A2

The column does not change when copied

, (comma)

Union operator, which combines multiple references into one reference

ampersand (&)

Use this to concatenate (join) one or more text strings to produce a single piece of text.

get accurate result

Using the order of mathematical operations is very important to?

either TRUE or FALSE

When two values are compared by using these operators, the result is a logical value

Simple Formulas Ex: =2+2

have one mathematical operation

Complex Formulas Ex: =2+2*8

involve more than one mathematical operations

MS Excel

is a powerful spreadsheet application software that integrates graphic and data management.

Cell Reference

is actually the combination of column and simply the name of the cell where data is placed.

Operators

tell the formula of the operations to be performed.