USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In MS Excel to split the number of months of a date string data type, we use which of the following functions?
|
|
Month()
|
|
|
Day()
|
|
|
Year()
|
|
|
Date()
|
Explanation:
Detailed explanation-1: -Right-Click on any cell within the Dates column and select Group from the fly-out list. Then select Month in the dialog box. Using the Starting at: and Ending at: fields, you can even specify the range of dates that you want to group if you don’t want to group the entire list.
Detailed explanation-2: -TEXT function in Excel-extract month as a text string An alternative way to get a month number from an Excel date is using the TEXT function: =TEXT(A2, “m")-returns a month number without a leading zero, as 1-12. =TEXT(A2, "mm")-returns a month number with a leading zero, as 01-12.
Detailed explanation-3: -If you need to extract the month from a date, you can use the MONTH function.
There is 1 question to complete.