Practice Test GeeksPractice Test Geeks
← All Microsoft Excel Flashcard Decks

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

  1. Which Excel function returns the position of a value within a range?

    Answer: MATCH

    MATCH returns the relative position of a lookup value within a range.

  2. What does the $ symbol do when placed before a column letter in a cell reference (e.g., $A1)?

    Answer: Locks only the column

    A $ before the column letter (e.g., $A1) locks the column while allowing the row to change when copied.

  3. Which keyboard shortcut inserts the current date in Excel?

    Answer: Ctrl + ;

    Ctrl + ; inserts the current static date into the selected cell.

  4. What is the result of =MOD(17, 5)?

    Answer: 2

    MOD(17, 5) returns 2 because 17 divided by 5 equals 3 with a remainder of 2.

  5. Which chart type is best suited for showing the proportion of parts to a whole?

    Answer: Pie chart

    Pie charts are designed to show how individual parts contribute to a total whole.

  6. What does the TRIM function do in Excel?

    Answer: Removes leading, trailing, and extra internal spaces

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

  7. In Excel, which function would you use to count cells that meet multiple criteria?

    Answer: COUNTIFS

    COUNTIFS counts cells that meet two or more criteria across one or more ranges.