DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
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. Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.
Detailed explanation-2: -Sometimes we get values in our Excel sheets in such a way that the % sign is omitted. So instead of the value being 23%, it is 23. Now, you can very easily correct this by editing the cell and adding a % sign at the end.
Detailed explanation-3: -To show formulas in all cells press CTRL+‘ (that little mark is the grave accent mark key). When the formulas are visible, print your worksheet as you normally would. To switch back to showing formula results in all cells, press CTRL+‘ again.