Practice Test GeeksMOS - Microsoft Office Specialist Certification Practice Test
← All MOS Flashcard Decks

Excel: Formulas and Functions Flashcards

7 cards from real MOS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Excel: Formulas and Functions flashcards as text

  1. Which function returns the number of characters in a text string?

    Answer: LEN

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

  2. What does the formula =IFERROR(A1/B1, "Error") return when B1 is 0?

    Answer: Error

    IFERROR catches the division-by-zero error and returns the specified value "Error" instead.

  3. Which function finds the position of a substring within a text string, case-insensitively?

    Answer: SEARCH

    SEARCH is case-insensitive and returns the position of a substring, while FIND is case-sensitive.

  4. What result does =ROUND(2.567, 2) produce?

    Answer: 2.57

    ROUND(2.567, 2) rounds to 2 decimal places, and the third decimal (7) rounds up the second decimal from 6 to 7.

  5. A formula uses the range name 'SalesData'. What type of reference is this?

    Answer: Named range reference

    Named ranges provide a descriptive label for a cell or range that acts like an absolute reference and is easier to read.

  6. Which function calculates the sum of values that meet a single condition?

    Answer: SUMIF

    SUMIF sums values in a range that satisfy a single specified condition.

  7. What does the $ symbol do in the cell reference $B$4?

    Answer: Makes both the column and row absolute

    Placing $ before both the column letter and row number locks both, creating a fully absolute reference that does not change when copied.