Explain the following function with purpose, syntax in example in MS- EXCEL (1) countblank (2) Month (3) Large
Answers
Answer:
Countblank:
The countblank function is to count blank cells in a range, where the word blank means empty. For example, COUNTBLANK(A1:A10) will count the number of blank cells in the range A1:A10. Cells that contain text, numbers, errors, etc. are not counted.
Month:
The month function extracts the month from a given date as number between 1 to 12. You can use the MONTH function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function. Use Month number between 1 and 12.
Large:
The large function returns the largest value from a set of values. The large function is a built-in function in Excel that is categorized as a Statistical Function. As a worksheet function, the large function can be entered as part of a formula in a cell of a worksheet.