Mis 180 Tutorial 2 Easton

Front 1

logical functions

Back 1

used to have Excel evaluate a condition and perform an action based on the result

Front 2

IF function

Back 2

used to perform a logical test on the contents of a cell

=IF(logical_test, Value_if_true, Value_if_false)

Front 3

ISBLANK function

Back 3

check a specific value and return an answer in the cell of either "true" or "false"

=ISBLANK(Value)
returns true if value is blank

Front 4

compound condition

Back 4

two or more separate conditions combined with either AND or OR

Front 5

AND Function

Back 5

used to evaluate up to 255 different logical tests
returns true if all logical tests are true, false if one or more is false

Front 6

OR Function

Back 6

used to evaluate up to 255 different logical tests
returns true if any of the logical tests are true
returns false if all of the logical tests are false

Front 7

conditional formatting

Back 7

allows Excel to apply different cell formats based on the contents of the cell

Front 8

source data

Back 8

the data you have selected to graph

Front 9

CountIF

Back 9

combines a logical test with the count function to count how many cells in a range meet the specified criteria
=CountIF(range,criteria)

Front 10

data validation

Back 10

helps control what data your user can enter, prevents data entry errors

Front 11

VLookUp function

Back 11

looks for a match in the first column of an array or table and then moves across the row to return the value of a corresponding cell