USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which number format is used to display the month as a single text character (such as N for November)?
|
|
mm
|
|
|
m
|
|
|
mmmmm
|
|
|
mmmm
|
Explanation:
Detailed explanation-1: -The format code “mmm” or “mmmm” displays only the month name.
Detailed explanation-2: -Select the range that needs data bars. On the Home tab, in the Styles group, select Data Bars from the Conditional Formatting tool. From there you can select data bars of different colors and opacities (see Figure 3.19).
Detailed explanation-3: -As you already know, the validation criteria are defined on the Settings tab of the Data Validation dialog box (Data tab > Data Validation).
There is 1 question to complete.