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: -When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage. Thus, if you enter the number. 5, Excel translates the value as 50%.
Detailed explanation-2: -The value that Excel displays for a cell is always the precise value you enter in the spreadsheet or the precise value resulting from a formula in that cell that is stored by the software. When you change the format of how a cell is displayed it doesn’t affect the actual value stored by the computer.
Detailed explanation-3: -When using TRUE or FALSE as criteria in a function, they are considered to be boolean values and therefore should not be put in quotes. In the COUNTIFS( ) function, every optional argument is treated as an “OR” scenario, meaning only one criteria must be evaluated to true in order for the item to be counted.
Detailed explanation-4: -If you enter a formula using Point mode and tap and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.
Detailed explanation-5: -MIN: This function determines the lowest cell value included in the argument.