USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Series
|
|
|
Function
|
|
|
Formula
|
|
|
None of the above
|
Detailed explanation-1: -Excel MONTH function-syntax and uses For the correct work of Excel MONTH formulas, a date should be entered by using the DATE(year, month, day) function. For example, the formula =MONTH(DATE(2015, 3, 1)) returns 3 since DATE represents the 1st day of March, 2015.
Detailed explanation-2: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.
Detailed explanation-3: -Here are a few Excel DATE formula examples: =DATE(2015, 5, 20)-returns a serial number corresponding to 20-May-2015. =DATE(YEAR(TODAY()), MONTH(TODAY()), 1)-returns the first day of the current year and month. =DATE(2015, 5, 20)-5-subtracts 5 days from May 20, 2015.