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. In an Excel formula, what does the $ symbol do when placed before a column letter or row number?

    Answer: Creates an absolute reference that does not change when copied

    The $ symbol creates an absolute reference, preventing the row or column from changing when the formula is copied.

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

    Answer: Pie chart

    A pie chart displays data as slices of a circle, making it ideal for showing each category's proportion of a total.

  3. What does the Excel function TODAY() return?

    Answer: The current date only

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

  4. Which option in Excel's Paste Special dialog lets you paste only the results of formulas, not the formulas themselves?

    Answer: Paste Values

    Paste Values pastes only the calculated results of formulas, stripping out the underlying formula.

  5. In Excel, which of the following is a valid way to reference the range A1 to D10?

    Answer: A1:D10

    The colon (:) operator defines a range from the first cell to the last cell, so A1:D10 references all cells from A1 through D10.

  6. What is the maximum number of rows supported in an Excel worksheet (Excel 2016 and later)?

    Answer: 1,048,576

    Excel 2007 and later versions support up to 1,048,576 rows per worksheet.

  7. Which Excel function concatenates two or more text strings into one string?

    Answer: CONCAT

    CONCAT (or the older CONCATENATE) joins multiple text strings into a single string.