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]
When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.
A
true
B
false
C
Either A or B
D
None of the above
Explanation: 

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: -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-3: -The IF function is useful when you want to assign a value to a cell based on a logical test. Goal seeking assumes you can change the value of multiple cells referenced directly or indirectly to reach a specific goal for a value of another cell.

Detailed explanation-4: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell.

Detailed explanation-5: -A function is a prewritten formula that is built into Excel.

There is 1 question to complete.
Previous
Next