Shared Flashcard Set

Details

Advanced Excel Chapter 4
Test Questions
10
Computer Science
Undergraduate 3
09/26/2013

Additional Computer Science Flashcards

 


 

Cards

Term
Relational operators can be used to evaluate dates.
Definition
True
Term
Dun & Bradstreet’s credit rating includes a classification ranging from ____ indicating the net worth category of the company.
Definition
5A to HH
Term
The syntax of the IF function is =IF(logical_test,value_if_true,value_if_false).
Definition
True
Term
Note that relational expressions ____.
Definition
are not case sensitive
Term
If you want to compare the value 3 to the value 5 to see if 3 is greater than 5, you would enter the following formula: =3>5.
Definition
True
Term
The financial stress risk class is a rating from ____, indicating the risk of a company in financial distress, where 1 represents businesses with the lowest probability of risk
Definition
1 to 5
Term
The AND function evaluates a list of logical arguments to determine if at least one of the arguments is TRUE.
Definition
False
Term
For an OR function to be TRUE, at least one of its arguments must be TRUE.
Definition
True
Term
TRUE and FALSE are referred to as Boolean logical values.
Definition
True
Term
You can use the ____ logical functions AND, OR, and NOT.
Definition
Boolean
Supporting users have an ad free experience!