QuizBB

In order to work correctly, a function must be written a specific way, which is called the _________.

• syntax

• system function

• argument

• equal sign

It contains the information you want to calculate.

• syntax

• argument

• function name

• equal sign

Compares two text strings and returns TRUE if they are identical. This function is case sensitive. Text_1 is the first text to compare. Text_2 is the second text to compare.

• Text/String Function

• Logical Function

• EXACT

• ARABIC

Converts all uppercase letters in a text string to lowercase. Text is the text to be converted.

• FIND

• LEFT

• LOWER

• PROPER

____________ used to search and manipulate text strings or character codes.

• Mathematical Functions

• Statistical Analysis Functions

• Text Functions

• Logical Functions

Calc includes over ___ statistical functions which enable the evaluation of data from simple arithmetic calculations, such as averaging, to advanced distribution and probability computations.

• 70

• 80

• 90

• 50

Specifies a logical test to be performed. Test is any value or expression that can be TRUE or FALSE. Then_value (optional) is the value that is returned if the logical test is TRUE. Otherwise_value (optional) is the value that is returned if the logical test is FALSE.

• AND(logical_value_1; logical_value_2; ...logical_value_30)

• FALSE()

• NOT(logical_value)

• IF(test; then_value; otherwise_value)

Returns TRUE if at least one argument is TRUE. Returns the value FALSE if all the arguments have the logical value FALSE. Logical_value_1; logical_value_2; ...logical_value_30 are conditions to be checked. All conditions can be either TRUE or FALSE. If a range is entered as a parameter, the function uses the value from the range that is in the current column or row.

• OR(logical_value_1; logical_value_2; ...logical_value_30)

• TRUE()

• NOT(logical_value)

• IF(test; then_value; otherwise_value)

Which of the following is NOT a logical function?

• AND(logical_value_1; logical_value_2; ...logical_value_30)

• IF(test; then_value; otherwise_value)

• TRUE()

• LOG10(number)

Which of the following is a Text Function?

• SUM

• EXACT

• NOT

• TRUE