DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
function
|
|
|
argument
|
|
|
data
|
|
|
number
|
Detailed explanation-1: -Logical functions, such as the IF function, display text or values if certain conditions exist. the value if the logical test is true. The third argument determines the value if the logical test is false.
Detailed explanation-2: -A function is a shorthand way to write an equation that performs a calculation. A formula with a function has three parts: an equal sign, a function name, and for most functions one argument, which acts as an operand.
Detailed explanation-3: -What does the Excel argument Type indicate? Whether the amounts to be paid or saved occur at the beginning or end of the period.
Detailed explanation-4: -The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers.