FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Excel has more than 400 functions that perform just about every type of calculation you can imagine.
A
true
B
false
C
Either A or B
D
None of the above
Explanation: 

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: -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.

Detailed explanation-4: -MIN: This function determines the lowest cell value included in the argument.

There is 1 question to complete.
Previous
Next