DATABASE FUNDAMENTALS
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
3+5*6
|
|
|
=3+5x6
|
|
|
3+(5x6)
|
|
|
=3+(5*6)
|
Detailed explanation-1: -Select the cells that you want to format. On the Home tab, click the Dialog Box Launcher next to Number. In the Category list, click Fraction. In the Type list, click the fraction format type that you want to use.
Detailed explanation-2: -To do this task, use the * (asterisk) arithmetic operator. For example, if you type =5*10 in a cell, the cell displays the result, 50.
Detailed explanation-3: -To do this, prefix the “number” with a single quote: ‘1.01 It will now be stored as text exactly as you enter it. Alternatively, you can format the entire column as text prior to entering your data.
Detailed explanation-4: -Formula =ROUND(A2/B2, 1)&":"&1 Once you have typed the formula, hit the Enter button. Excel will immediately display the ratio of the two numbers in a proper format. The ratio of 10 and 20 comes out to be 5:1.