Excel 1 - C01

List the 4 data types in excel

1. logical

2. text

3. number

4. error

Formula

equations that works in combination with data from other cells

Function

preset formulas intended to carry out specific calculations (i.e. SUM, IF, AVERAGE)

IF function

type of logical function used to test specific conditions (results in 2 possible answers)

syntax: IF function

= IF (logical test, TRUE, FALSE)

Logical test

a form of statement that you want to prove, and can be represented as logical operators

Logical operators

=, <>, <=,>= etc.

T/F: when writing text in formulas, you must include “__”

True or else it returns “N/A” or “ERROR”

Nested IF function

when there are more than 2 possible responses

Syntax: Nested IF function

= IF (logical test, TRUE, IF (logical test, TRUE, FALSE))

Relative reference

cell formula does not include $

Absolute reference

cell formula does include $ which locks the cell and its value in place