FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.
A
true
B
false
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The arithmetic operator, ^, directs Excel to perform the division operation. As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. Moving from left to right, the first calculation in the order of operations is negation.

Detailed explanation-2: -A formula in Excel always begins with an equal sign (=).

Detailed explanation-3: -You can do it through AutoSum or Some Formulas.

Detailed explanation-4: -A Formula is an equation designed by a user in Excel, while a Function is a predefined calculation in the spreadsheet application.

There is 1 question to complete.
Previous
Next