Practice Test GeeksPractice Test Geeks
← All Microsoft Excel Flashcard Decks

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

  1. What year was Microsoft Excel first released for the Macintosh?

    Answer: 1985

    Microsoft Excel was first released in 1985 for the Apple Macintosh, two years before the Windows version.

  2. Which Excel function returns the number of cells in a range that are not empty?

    Answer: COUNTA

    COUNTA counts all non-empty cells in a range, including text, numbers, and errors.

  3. What is the maximum number of rows in a modern Excel worksheet (Excel 2007 and later)?

    Answer: 1,048,576

    Excel 2007 and later supports 1,048,576 rows per worksheet, a massive increase from the 65,536 limit in earlier versions.

  4. Which keyboard shortcut inserts the current date into an Excel cell?

    Answer: Ctrl+;

    Ctrl+; (semicolon) inserts the current date as a static value into the active cell.

  5. What does the TRIM function do in Excel?

    Answer: Removes leading and trailing spaces and reduces internal spaces to one

    TRIM removes leading and trailing spaces and reduces any internal sequences of spaces to a single space.

  6. Which Excel chart type is best suited for showing data trends over time with continuous data?

    Answer: Line chart

    Line charts are ideal for displaying continuous data trends over time, clearly showing direction and rate of change.

  7. What does the F4 key do when editing a cell formula in Excel?

    Answer: Toggles absolute/relative cell references

    F4 cycles through the four reference types: relative (A1), absolute ($A$1), mixed ($A1), and mixed (A$1).