Microsoft Excel Functions Questions and Answers 3

Question 1

What does the SUMIFS function do differently from SUMIF?

Accepted Answer

SUMIFS allows multiple criteria while SUMIF allows only one

Answer

SUMIFS can apply multiple criteria across different columns simultaneously, while SUMIF is limited to a single condition.

Question 2

Which function returns TRUE if a cell is empty?

Accepted Answer

ISBLANK

Answer

ISBLANK(value) returns TRUE if the referenced cell is completely empty and FALSE otherwise.

Question 3

What does the LEFT function do in Excel?

Accepted Answer

Extracts a specified number of characters from the beginning of a text string

Answer

LEFT(text, [num_chars]) returns the first num_chars characters from a text string, starting from the left side.

Question 4

Which function converts text to uppercase in Excel?

Accepted Answer

UPPER

Answer

UPPER(text) converts all letters in a text string to uppercase. For example, =UPPER("hello") returns "HELLO".

Question 5

What does the COUNTA function count?

Accepted Answer

All non-empty cells in a range regardless of data type

Answer

COUNTA counts all cells that are not empty, including cells with numbers, text, logical values, error values, and empty text strings returned by formulas.

Excel Practice Test

Excel Practice Test

Microsoft Excel Functions Questions and Answers 3