Functions Questions and Answers Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Functions Questions and Answers flashcards as text
What does the SUMIFS function do differently from SUMIF?
Answer: SUMIFS allows multiple criteria while SUMIF allows only one
SUMIFS can apply multiple criteria across different columns simultaneously, while SUMIF is limited to a single condition.
Which function returns TRUE if a cell is empty?
Answer: ISBLANK
ISBLANK(value) returns TRUE if the referenced cell is completely empty and FALSE otherwise.
What does the LEFT function do in Excel?
Answer: Extracts a specified number of characters from the beginning of a text string
LEFT(text, [num_chars]) returns the first num_chars characters from a text string, starting from the left side.
Which function converts text to uppercase in Excel?
Answer: UPPER
UPPER(text) converts all letters in a text string to uppercase. For example, =UPPER("hello") returns "HELLO".
What does the COUNTA function count?
Answer: All non-empty cells in a range regardless of data type
COUNTA counts all cells that are not empty, including cells with numbers, text, logical values, error values, and empty text strings returned by formulas.
Which function replaces part of a text string with different text based on position?
Answer: REPLACE
REPLACE(old_text, start_num, num_chars, new_text) replaces characters starting at a specific position for a specified length with new text.