Saylor URL: http://www.saylor.org/books
The Freeze Panes command should be used to lock column and row headings in place while scrolling
through large worksheets.
The IF function is used to evaluate the contents of a cell location using a logical test. Based on the results
of the logical test, you designate a custom output or calculation to be performed by the function.
When using text, or nonnumeric data, to define any argument of the IF function, it must be placed inside
A nested IF function is used when more than one logical test and more than two outputs are required for
a project. Either the Value_if_true or theValue_if_false arguments can be defined with an IF function.
When using percentages in any logical test or formula, you must use the percent symbol (%) or convert
the percentage to a decimal. For example, 10% can also be expressed as .10.
The OR function is used when many logical tests are required to evaluate the contents of a cell location.
The OR function will produce a TRUE output if one of the logical tests is true.
The AND function is used when many logical tests are required to evaluate the contents of a cell location.
The AND function will produce a TRUE output if all of the logical tests are true.
To minimize the complexity of nested IF functions, the OR and AND functions should be used when
possible to define the logical_test argument of the IF function.
Assume the value in cell B12 is 25. Any value greater than or equal to 25 is OK, and any value below 25 is
too low. Which of the following IF functions will provide an accurate result?
=IF; 12>25, ͞TOO LOW͟, ͞OK͟Ϳ
=IF; 12=25 OR 12>25, ͞OK͟, ͞TOO LOW͟Ϳ
=IF; 12>=25, ͞OK͟, ͞TOO LOW͟Ϳ
Assume the value in cell C4 is 5 and the value in D4 is 2. If the value in C4 is greater than 10, or if the value
in D4 is greater than or equal to 2, the output should read OK. Otherwise, the output should read LOW.
Which of the following IF functions will provide an accurate result?
=IF; 4>10 or D4>2 or D4=2, ͞OK͟, ͞LOW͟Ϳ
=IF;OR; 4>10,D4>2,=2Ϳ=TRUE, ͞OK͟, ͞LOW͟Ϳ
=IF;OR;D4>=2, 4>10Ϳ=TRUE, ͞OK͟, ͞LOW͟Ϳ