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. Which function combines the results of multiple IF conditions without nesting?

    Answer: IFS

    IFS evaluates multiple condition-value pairs in order and returns the value for the first TRUE condition.

  2. What does =CONCATENATE("Hello", " ", "World") return?

    Answer: Hello World

    CONCATENATE joins text strings in order; the space in the middle argument produces "Hello World".

  3. The ROUND function =ROUND(3.567, 2) returns which value?

    Answer: 3.57

    ROUND with 2 decimal places rounds 3.567 to 3.57 because the third decimal (7) is ≥ 5.

  4. Which formula correctly calculates a weighted average for values in A1:A3 with weights in B1:B3?

    Answer: =SUMPRODUCT(A1:A3,B1:B3)/SUM(B1:B3)

    SUMPRODUCT multiplies each value by its weight and sums the results, then dividing by total weight gives the weighted average.

  5. What does the & operator do in an Excel formula?

    Answer: Concatenates text strings

    The & operator joins (concatenates) text values, functioning identically to the CONCATENATE function.

  6. Which function returns the current date and time, updating each time the workbook recalculates?

    Answer: NOW()

    NOW() returns the current date and time as a serial number that recalculates whenever the worksheet changes.

  7. In the formula =VLOOKUP(D2, A2:C10, 3, FALSE), what does the argument FALSE specify?

    Answer: Require an exact match

    FALSE (or 0) as the fourth VLOOKUP argument forces an exact match, returning #N/A if none is found.