Question

Which function will you use in the given situations?
1. To add the numbers in a given range of cells.
2. To calculate the average value.
3. To count the number of cells with values in it.
4. To show the current date.
5. To calculate the number of characters in a text string.

Answer 1

Answer:

COUNTIF in Excel - count if not blank, greater than, duplicate or unique

Explanation:

hope it helps

Answer 2

Answer:

You can use Microsoft excel