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. What is the result of =ROUND(3.567, 2)?

    Answer: 3.57

    ROUND(3.567, 2) rounds 3.567 to 2 decimal places, resulting in 3.57.

  2. Which of the following is NOT a valid cell reference style in Excel?

    Answer: 1A

    Cell references in the A1 style must begin with the column letter(s) followed by the row number.

  3. What is the purpose of Data Validation in Excel?

    Answer: To restrict the type or range of data entered into a cell

    Data Validation restricts what users can enter into a cell, such as only allowing numbers within a specific range.

  4. Which keyboard shortcut selects an entire row in Excel?

    Answer: Shift + Space

    Shift + Space selects the entire row of the currently active cell.

  5. What does the NOW() function return in Excel?

    Answer: The current date and time

    NOW() returns the current date and time as a serial number that updates whenever the worksheet is recalculated.

  6. Which Excel feature allows you to split a single column of data into multiple columns based on a delimiter?

    Answer: Text to Columns

    Text to Columns (under the Data tab) splits cell content into separate columns using a delimiter like a comma or space.

  7. What is the function of the SUMPRODUCT formula?

    Answer: Multiplies corresponding elements in arrays and returns their sum

    SUMPRODUCT multiplies corresponding values across multiple arrays and returns the sum of those products.