Practice Test GeeksPractice Test Geeks
← All Microsoft Excel Flashcard Decks

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

  1. Which function returns a value from a specific row and column within a given range?

    Answer: INDEX

    INDEX returns the value at the intersection of a specified row and column within a range.

  2. What does =SUMIF(A1:A10, ">100", B1:B10) calculate?

    Answer: Sum of B1:B10 where corresponding A values are greater than 100

    SUMIF sums values in B1:B10 only for rows where the corresponding value in A1:A10 is greater than 100.

  3. Which function converts a number into text formatted as currency?

    Answer: DOLLAR

    DOLLAR converts a number to text in currency format, with optional decimal places, using the $ symbol.

  4. What does the EXACT function do?

    Answer: Compares two text strings and returns TRUE if they are identical (case-sensitive)

    EXACT performs a case-sensitive comparison of two text strings, returning TRUE only if they match exactly.

  5. Which function returns the nth largest value in a data set?

    Answer: LARGE

    LARGE returns the k-th largest value in a data set, where k is the second argument.

  6. What does the YEARFRAC function calculate?

    Answer: The fraction of the year represented by the number of days between two dates

    YEARFRAC returns the fraction of the year represented by the number of whole days between two dates, useful for financial calculations.

  7. Which function replaces all occurrences of a substring within a text string?

    Answer: SUBSTITUTE

    SUBSTITUTE replaces all (or a specific) occurrences of a given text with new text within a string.