DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The AVERAGE function requires that the argument (the range) be included within parentheses before the function name. False. The Option button lists formatting options following an insertion of cells, rows, or columns. The most common error when entering a formula is to reference the wrong cell in the formula.
Detailed explanation-2: -A function is called by using the function name, followed by a set of parentheses containing the data to be passed to the function. The data passed to the function are referred to as the “actual” parameters.
Detailed explanation-3: -MAX: This function determines the highest cell value included in the argument. MIN: This function determines the lowest cell value included in the argument.
Detailed explanation-4: -Which of the following is true about entering a function using the Insert Function dialog box? You can select a function you’ve recently used.
Detailed explanation-5: -The most common reason for an Excel formula not calculating is that you have inadvertently activated the Show Formulas mode in a worksheet. To get the formula to display the calculated result, just turn off the Show Formulas mode by doing one of the following: Pressing the Ctrl + ‘ shortcut, or.