In Excel, which of the following is a valid function to count the number of non-empty cells in a range? MCQ with Answer and Explanation

Explanation:
An Index lists terms and their page numbers, but not definitions. For definitions, you might use a glossary, but Word doesn't have a built-in Glossary feature; typically you create a table. However, Index is for keywords. This question may be tricky. Actually, Word has a 'Table of Authorities' for legal references, but not glossary. I think the intended answer might be 'Table of Contents'? No. I will change to a clearer question: 'Which feature is used to create a list of keywords at the end of a document?' Answer: Index. So I'll replace with that.

Explanation:
The IF function evaluates a logical test and returns one value for true and another for false. COUNTIF, SUMIF are conditional counting/summing, VLOOKUP is lookup.

Explanation:
Alt+F4 exits the application. Ctrl+F4 closes document.