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 a value from a table based on both row and column positions?

    Answer: INDEX

    INDEX returns a value from a table by specifying a row number and column number within the range.

  2. What does =MOD(17, 5) return?

    Answer: 2

    MOD returns the remainder after division; 17 divided by 5 is 3 remainder 2, so MOD(17,5) = 2.

  3. Which function counts only the cells in a range that contain numbers?

    Answer: COUNT

    COUNT counts only numeric values, while COUNTA counts all non-empty cells regardless of data type.

  4. You want to look up a value in column A and return a corresponding value from column C without using VLOOKUP. Which combination works best?

    Answer: INDEX + MATCH

    INDEX(range, MATCH(lookup_value, lookup_column, 0)) is a flexible alternative to VLOOKUP that can look left and isn't limited to the first column.

  5. What does the TODAY() function return?

    Answer: The current date only

    TODAY() returns only the current date as a serial number formatted as a date, with no time component.

  6. Which function should you use to remove extra spaces from the beginning, end, and middle of a text string (leaving only single spaces between words)?

    Answer: TRIM

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

  7. In a nested IF formula =IF(A1>90,"A",IF(A1>80,"B","C")), what is returned when A1 is 85?

    Answer: B

    85 is not greater than 90 (outer IF fails), but 85 is greater than 80 (inner IF passes), so "B" is returned.