Interview Questions and Answers

Like IF function, AND function also does the logical function. To check whether the output will be true or false the AND function will evaluate at least one mathematical expression located in another cell in the spreadsheet. If you want to see the final result or output of more than one cells in single cell it is possible by using AND function.

Example: If you have two cells, A1 and A2, and the value you put in those two cells are >5 and you want result should display as ‘TRUE’ in cell B1 if value>5,   and ‘False’ if any of those values<5. You can use AND function to do that.

COUNT: COUNT is used to count cells containing numbers, dates, etc. any value stored as number excluding blanks.

COUNTA: COUNTAor Count All is used to count any cell value containing numbers, text, logical values, etc. any type of value excluding blanks.

COUNTBLANK: It counts blank cells or cells with an empty string.

COUNTIF and COUNTIFS: These count cells matching a certain criteria.