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: -Excel has more than 400 functions that perform just about every type of calculation you can imagine. Clicking the Create Function box opens the Function Arguments dialog box. The Sum button menu allows you to enter one of five often-used functions easily into a cell.
Detailed explanation-2: -The range automatically selected by Excel is always correct. Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.
Detailed explanation-3: -MIN: This function determines the lowest cell value included in the argument.
Detailed explanation-4: -The main difference between a function and formula is that a function is a predefined formula available in MS Excel, while a formula is a predefined calculation that uses cell references or hard-coded numbers to calculate a cell value. Technically, you can call a function a formula.