FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If the formula is written correctly but the result is a # sign on the monitor screen, it means ____
A
Data is wrong
B
Absolute cell address
C
Data cannot be processed
D
The cell column is less wide
E
The cell row is less wide
Explanation: 

Detailed explanation-1: -The rule for writing chemical formula is as follow: Firstly, write the symbols with positive charge valency first. Secondly, write the valency of each atom on the top of its symbol. Thirdly, divide the valency number by their highest common factor ignore the positive or negative radicle.

Detailed explanation-2: -Switch between displaying formulas and their results from the keyboard. Press CTRL + ‘ (grave accent).

Detailed explanation-3: -In Microsoft Excel, if you enter a formula that links one cell to a cell that is formatted with the Text number format, the cell that contains the link is also formatted as text. If you then edit the formula in the linked cell, the formula is displayed in the cell rather than the value that is returned by the formula.

There is 1 question to complete.
Previous
Next