3rd Quarter - Computer 5 Review

It is an equation that calculates data.

• Formula

• Function

• Condition

• Relation

It is the symbol that represents the calculation to be applied on the operands.

• Operand

• Operator

• Equation

• Symbol

The operator used for Multiplication in Excel.

• +

• -

• *

• /

These are used to perform basic mathematical operations.

• Arithmetic Operators

• Concatenation

• Order of Precedence

• Cell Reference

It is the process of combining two or more strings together.

• Operations

• Concatenation

• Reference

• Formulation

It refers to the sequence in which the operations in the formula are evaluated.

• Order of Operations

• Cell Reference

• Order of Precedence

• Relationship

The question mark (?) is used to separate the reference for the worksheet and the cell.

• True

• False

These are the predefined formulas that perform calculations on a set of arguments.

• Formula

• Functions

• Conditions

• Relations

It can be a value or a cell reference in function.

• Formula

• Relation

• Argument

• Operand

it is a set of functions that performs the basic mathematical operations.

• AutoSum

• Financial

• Logical

• Date and Time