DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You want to display the two numbers 1, 540, 257.14 and 2, 250, 444.18 as 1.54 M and 2.25 M, respectively. Which number format must be applied to the first two numbers?
|
|
#, ##0.00, , “M”
|
|
|
0, 000.00 “M”
|
|
|
#, ##0.* “M”
|
|
|
[millions] #, ##0.00 “M”
|
Explanation:
Detailed explanation-1: -On the Home tab, in the Number group, click the arrow next to the Number Format box, and then click Text. Note: If you don’t see the Text option, use the scroll bar to scroll to the end of the list.
There is 1 question to complete.