FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which is an example of a function that extracts the year from a date that is typed in cell B9?

A	=DATE(B9)
B	=DATE(YEAR, B9)
C	=YEAR(B9)
D	=YEAR(DATE, B9)

Explanation:

Detailed explanation-1: -Using dates in financial modeling is very common and the YEAR function helps extract a year number from a date into a cell. The function can also be used to extract and feed a year value into another formula such as the DATE function.

Detailed explanation-2: -Excel YEAR function =YEAR(A2)-returns the year of a date in cell A2. =YEAR("20-May-2015")-returns the year of the specified date. =YEAR(DATE(2015, 5, 20))-a more reliable method to get the year of a given date. =YEAR(TODAY())-returns the current year.

Detailed explanation-3: -MONTH function in Excel-get month number from date This is the most obvious and easiest way to convert date to month in Excel. For example: =MONTH(A2)-returns the month of a date in cell A2.

There is 1 question to complete.