Practice Test GeeksPractice Test Geeks
← All Microsoft Excel Flashcard Decks

Formulas Flashcards

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

  1. What does =TRIM(" Hello World ") return?

    Answer: Hello World

    TRIM removes leading and trailing spaces and collapses multiple internal spaces to a single space.

  2. Which function returns the largest value in a range?

    Answer: Both A and C

    Both MAX(range) and LARGE(range,1) return the largest value; MAX is the direct function while LARGE(range,1) specifies the 1st largest.

  3. What is the result of =TEXT(1234.5, "$#,##0.00")?

    Answer: $1,234.50

    TEXT converts a number to a formatted text string; the format code "$#,##0.00" produces "$1,234.50".

  4. How do you reference the entire column B in a formula?

    Answer: B:B

    Using B:B selects all cells in column B as a dynamic range reference.

  5. Which formula counts cells in A1:A20 that contain values greater than 50?

    Answer: =COUNTIF(A1:A20,">50")

    COUNTIF counts cells matching a single criterion; ">50" selects cells with values greater than 50.

  6. What does the TRANSPOSE function do when entered as an array formula?

    Answer: Converts rows to columns and columns to rows

    TRANSPOSE swaps the orientation of a range, turning rows into columns and vice versa.

  7. Which formula returns the number of characters in the text string in cell A1?

    Answer: =LEN(A1)

    LEN returns the number of characters in a text string, including spaces.