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]
____ are equations that perform calculations (+, -, x, ÷) on values in a worksheet.
A
Median
B
Mode
C
Range
D
Formulas
Explanation: 

Detailed explanation-1: -Formulas are equations that perform calculations on values in your sheet. All formulas begin with an equal sign (=). You can create a simple formula by using constant and calculation operator. For example, the formula =5+2*3, multiplies two numbers and then adds a number to the result.

Detailed explanation-2: -A formula is an equation used to perform calculations in Excel.

Detailed explanation-3: -"x” is just a string which certain embedded IF functions sometimes evaluate to. It has no special Excel meaning.

Detailed explanation-4: -Show Formulas option on the Excel ribbon In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away. To get the calculated values back, click the Show Formulas button again to toggle it off.

There is 1 question to complete.
Previous
Next