Practice Test GeeksExcel Practice Test
← All Microsoft Excel Flashcard Decks

Mixed Deck — All Microsoft Excel Topics Flashcards

100 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 20 Mixed Deck — All Microsoft Excel Topics flashcards as text

  1. Which Excel feature allows you to automatically fill a series of dates, numbers, or text patterns?

    Answer: AutoFill

    AutoFill uses the fill handle (small square at the bottom-right of a selection) to extend a series automatically.

  2. Which function would you use to find the position of a value in a list?

    Answer: MATCH

    MATCH returns the relative position (row or column number) of a value within a range.

  3. Which function replaces all occurrences of a substring within a text string?

    Answer: SUBSTITUTE

    SUBSTITUTE replaces all (or a specific) occurrences of a given text with new text within a string.

  4. What does the SUMIFS function do differently from SUMIF?

    Answer: SUMIFS allows multiple criteria while SUMIF allows only one

    SUMIFS can apply multiple criteria across different columns simultaneously, while SUMIF is limited to a single condition.

  5. Let's say that cell A1 shows the value "12000.7789". How should this number be rounded to the nearest integer using the following formula?

    Answer: =ROUND(A1,0)

    The `ROUND` function in Excel is used to round a number to a specified number of decimal places. To round a number to the nearest integer, you specify `0` as the number of decimal places. This instructs Excel to round the value in cell A1 to the closest whole number.

  6. What is the purpose of Custom Views?

    Answer: Saving different display, filter, print settings to switch between

    Custom Views save combinations of display, filter, print settings for quick switching.

  7. Which Excel function converts a text string to all uppercase letters?

    Answer: UPPER

    UPPER(text) converts all characters in a text string to uppercase letters.

  8. What is the maximum number of rows supported in a single Excel 2016 worksheet?

    Answer: 1,048,576

    Excel 2007 and later supports 1,048,576 rows (2^20) per worksheet. The 65,536-row limit applied to Excel 2003 and earlier (.xls format).

  9. Which spreadsheet application was Excel primarily designed to compete against?

    Answer: Lotus 1-2-3

    Lotus 1-2-3 dominated the spreadsheet market in the 1980s, and Microsoft developed Excel specifically to surpass it in features and usability.

  10. What does VLOOKUP's fourth argument (range_lookup) control?

    Answer: Exact match (FALSE) or approximate match (TRUE)

    FALSE requires exact match; TRUE allows approximate match from sorted data.

  11. How does the Watch Window help with large spreadsheets?

    Answer: Displays selected cells' values in a floating window visible while navigating

    Watch Window shows cell values and formulas in a persistent panel across sheets.

  12. What does the SWITCH function do?

    Answer: Evaluates an expression against a list of values and returns the first match

    SWITCH compares an expression against value-result pairs, returning the result for the first match.

  13. What is a PivotChart in Excel?

    Answer: A chart linked to a PivotTable that dynamically updates when the PivotTable changes

    A PivotChart is directly linked to a PivotTable and automatically updates when the PivotTable is filtered, changed, or refreshed.

  14. 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.

  15. When a PivotTable is filtered using a Slicer, what happens to its associated PivotChart?

    Answer: The PivotChart is automatically updated to reflect the filtered data

    PivotCharts are dynamically linked to their PivotTable, so any filter changes are immediately and automatically reflected in the chart.

  16. What happens when you double-click the fill handle (small square at the bottom-right corner of a selected cell)?

    Answer: Excel auto-fills the formula or pattern down to match the adjacent column's data range

    Double-clicking the fill handle automatically copies the cell's formula or pattern down to the last row that has data in the adjacent column.

  17. Which Excel feature helps you identify errors in formulas by showing which cells are referenced?

    Answer: Trace Precedents and Trace Dependents

    Trace Precedents shows arrows pointing from cells that feed into a formula, while Trace Dependents shows arrows pointing to cells that use the selected cell's value.

  18. After creating an Excel table from a range of data, you want to provide users with a set of visible, clickable buttons to filter the 'Region' and 'Product Category' columns without using the drop-down arrows in the headers. Which feature should you insert?

    Answer: Slicer

    Slicers are interactive controls that provide buttons for filtering data in tables, PivotTables, and PivotCharts. They can be inserted from the 'Table Design' tab and offer a user-friendly way to see and change the current filter state.

  19. What does the 'What-If Analysis' group in Excel's Data tab include?

    Answer: Scenario Manager, Goal Seek, and Data Table

    The What-If Analysis group contains Scenario Manager, Goal Seek, and Data Table.

  20. How do you freeze the top row in Excel so it remains visible while scrolling down?

    Answer: View tab → Freeze Panes → Freeze Top Row

    On the View tab, clicking Freeze Panes and then Freeze Top Row locks row 1 in place during vertical scrolling.