DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In MS Excel to split the number of years of a data type date month year, we use which of the following functions?
|
|
Year()
|
|
|
Day()
|
|
|
Month()
|
|
|
Date()
|
Explanation:
Detailed explanation-1: -1. Select the dates you want to split, click Kutools > Text > Split Cells. 2. In the Split Cells dialog, check Split to Columns checkbox, then check Other in Split by section, type / into the next textbox.
Detailed explanation-2: -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.
There is 1 question to complete.