Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
25 Cards in this Set
- Front
- Back
To apply "Cell Value is" conditional formatting, first do what?
|
select the cells you want to conditionally format
|
|
When using an OR function, if only one of two arguments equals FALSE (and the other argument equals TRUE), an OR function results in a value of ____
|
TRUE
|
|
An ____ function returns a value of TRUE only if all arguments in the function are TRUE
|
AND
|
|
What conditional formatting should one use if they want to apply formatting to A3 based on the value of B3?
|
"Use a formula to determine which cells to format"
|
|
T/F...The syntax of the NOT function can evaluate a range of values?
|
False
|
|
What is the relational operator for "not equal" is ______
|
<>
|
|
Give six examples of relational operators.
|
=, <>, <, >, >=, and <=
|
|
An ____ function returns a value of TRUE if at least one argument is TRUE
|
OR
|
|
=AND(NOT(F3),NOT(G3),NOT(H3)) is an example of a(n) _____ construct.
|
"None of"
|
|
=AND(F3,NOT(OR(G3:H3))) is an example of a(n) _____ construct.
|
"Only"
|
|
Relational operators can be used to determine if an expression is _____
|
TRUE or FALSE
|
|
To change a TRUE value to FALSE, or a FALSE value to TRUE, use the _____ function.
|
NOT
|
|
T/F...The OR function evaluates logical arguments to determine if at least one argument is TRUE.
|
True
|
|
A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE.
|
OR
|
|
What function should be used when you have an either/or situatoin; do this or do that?
|
IF
|
|
In the Unites States, a company can deduct only the amount paid towards interest as an expense (whch effectively reduces the amount of income taxed).
|
TRUE
|
|
=AND(FALSE,FALSE,FALSE,FALSE,FALSE,FALSE) evaluates to _____.
|
FALSE
|
|
To find whether the value in cell A1 is between 5 and 10 (inclusive), what function could you use?
|
AND
|
|
If B3 contains the date 12/31/2006 and C3 contains the date 12/31/2005, then =B3<C3 is _____.
|
FALSE
|
|
When using a IF function, formulas can be used within a Value_if_true or Value_if_false argument if the formula is enclosed within quotation marks.
|
FALSE
|
|
If the cell M1 contains Monkey1 and cell D1 contains Dog2, the formula =M1<=D1 results in a value of _____.
|
FALSE
|
|
With relational operators, a greater value is one that appears earlier in the alphabet.
|
FALSE
|
|
If the values in cells F3, F4, F5, and F6 are all greater than 100, the formula =OR(F3:F6>100) will always return a value of TRUE.
|
FALSE
|
|
Sorting by ascending order is from Z to A.
|
FALSE
|
|
When numbers containing zeros are entered in a cell, if "0" is used as one of the digits in the cell's custom formatting code, that digit displays _____.
|
any digit, regardless of whether it affects the value of the number
|