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

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

  1. Which Excel function returns the number of cells in a range that meet a single condition?

    Answer: COUNTIF

    COUNTIF counts cells within a range that meet a specified single condition.

  2. When you freeze panes in Excel, what is frozen by default when you select cell B2 and apply Freeze Panes?

    Answer: Row 1 and column A

    Freeze Panes with B2 selected freezes everything above and to the left — row 1 and column A.

  3. Which keyboard shortcut applies the Currency format to selected cells in Excel?

    Answer: Ctrl+Shift+$

    Ctrl+Shift+$ applies the Currency number format to selected cells.

  4. In Excel, what does the TRIM function do?

    Answer: Removes leading, trailing, and extra spaces between words

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

  5. What is the purpose of the Name Box in Excel?

    Answer: Shows and navigates to cell references or named ranges

    The Name Box (left of the formula bar) displays the current cell address and can be used to navigate to or name ranges.

  6. Which function would you use to look up a value in the first column of a table and return a value in the same row from another column?

    Answer: VLOOKUP

    VLOOKUP searches vertically in the first column of a range and returns a value from a specified column in the same row.

  7. Which Excel feature allows you to define a series of valid entries for a cell and display them as a dropdown list?

    Answer: Data Validation

    Data Validation can restrict cell input to a list of valid entries and display them as a dropdown list.