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 sums text values while SUMIF sums numbers

Answer

SUMIFS works across workbooks while SUMIF works only in one sheet

Answer

There is no difference between them

Question 2

Which function returns TRUE if a cell is empty?

Accepted Answer

ISBLANK

Answer

ISEMPTY

Answer

ISNULL

Answer

ISTEXT

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-aligns text in a cell

Answer

Moves the cursor to the leftmost cell

Answer

Shifts cell contents to the left

Question 4

Which function converts text to uppercase in Excel?

Accepted Answer

UPPER

Answer

CAPS

Answer

UCASE

Answer

CAPITALIZE

Question 5

What does the COUNTA function count?

Accepted Answer

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

Answer

Only cells containing numbers

Answer

Only cells containing text

Answer

Cells that contain formulas

Question 6

Which function replaces part of a text string with different text based on position?

Accepted Answer

REPLACE

Answer

SUBSTITUTE

Answer

CHANGE

Answer

SWAP