USING MICROSOFT EXCEL
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: -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.
Detailed explanation-4: -Median which is the middle number of a group of numbers; that is, half the numbers have values that are greater than the median, and half the numbers have values that are less than the median.