Practice Test GeeksExcel Practice Test
← All Microsoft Excel Flashcard Decks

Formulas 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 Formulas Questions and Answers flashcards as text

  1. What does the IFERROR function do in Excel?

    Answer: Returns a specified value if the formula results in an error, otherwise returns the formula result

    IFERROR evaluates a formula and returns its result if no error occurs. If the formula produces any error (#N/A, #VALUE!, #DIV/0!, etc.), it returns the alternative value you specify.

  2. Which formula extracts only the year from a date value in cell A1?

    Answer: =YEAR(A1)

    YEAR() extracts the year component from a date serial number and returns it as a four-digit number.

  3. What is the purpose of the INDEX and MATCH combination in Excel?

    Answer: To look up a value in any column of a range based on a matching criterion in another column

    INDEX returns a value from a specific position in a range, and MATCH finds the position of a lookup value. Together, they create a flexible lookup that can search in any direction.

  4. What does the formula =LEN(TRIM(A1)) calculate?

    Answer: The number of characters in A1 after removing extra spaces

    TRIM removes leading, trailing, and extra internal spaces (leaving single spaces between words), and LEN then counts the characters in the cleaned text.

  5. Which formula converts the text string "123" in cell A1 to the number 123?

    Answer: =VALUE(A1)

    VALUE() converts a text string that represents a number into an actual numeric value. While multiplying by 1 also works, VALUE is the dedicated function for this purpose.

  6. What is the result of =POWER(2,10) in Excel?

    Answer: 1024

    POWER(2,10) calculates 2 raised to the 10th power, which equals 1,024. This is equivalent to writing =2^10.