Microsoft Excel Cheat Sheet 2026

The 30 highest-yield Microsoft Excel facts, distilled from real exam questions. Print it, save it as a PDF, or study it here โ€” free, no sign-up.

Microsoft Excel exam key facts

  • The Microsoft Office Specialist Excel exam (Microsoft 365 Apps) has 33-37 questions. Source
  • The Microsoft Office Specialist Excel exam gives candidates 50 minutes to complete it, with 60 minutes of seat time. Source
  • A Microsoft Office Specialist (MOS) exam voucher costs $104.00 in the US Certiport Store. Source
  • Microsoft Office Specialist (MOS) certifications are valid for 5 years. Source
Start the Timed Microsoft Excel Mock Exam โ†’
35 questions
50 min time limit
70.00% to pass
  1. What is the purpose of the Name Manager in Excel? โ†’ To create, edit, and manage named ranges and defined names
  2. Which view of a worksheet displays the worksheet's header and footer sections? โ†’ Page layout view
  3. Which view in Excel is best suited for setting page breaks and print areas before printing? โ†’ Page Break Preview
  4. What is the purpose of the Watch Window in Excel? โ†’ To monitor the values of specific cells while working in other parts of the workbook
  5. Which feature in Excel allows you to group and summarize data with collapsible outline levels? โ†’ Group and Outline
  6. Which function returns the nth largest value in a data set? โ†’ LARGE
  7. Which formula returns the number of days between two dates in cells A1 and B1? โ†’ =B1-A1
  8. What does the INDEX function return when given an array, a row number, and an optional column number? โ†’ The value at the specified row and column intersection
  9. What does the TRIM function do in Excel? โ†’ Removes leading and trailing spaces and reduces internal spaces to one
  10. What is the correct syntax to look up a value in the first column of a table and return a value from another column using VLOOKUP? โ†’ VLOOKUP(value, table_array, col_index_num, range_lookup)
  11. What is the Total Row in an Excel Table? โ†’ A summary row with dropdown aggregate functions for each column
  12. What is the location of the filling handle? โ†’ In the bottom-right corner of the selected cell
  13. What is the name of the Excel feature that highlights cells based on their content or value? โ†’ Conditional Formatting
  14. A cell cluster is referred to as a ___. โ†’ cell range
  15. Which of the following actions is prevented when you use the 'Protect Workbook' feature with the 'Structure' option selected? โ†’ Adding a new worksheet
  16. Which spreadsheet application was Excel primarily designed to compete against? โ†’ Lotus 1-2-3
  17. Which function combines the results of multiple IF conditions without nesting? โ†’ IFS
  18. Which Excel tool is used to find the input value needed to achieve a specific formula result? โ†’ Goal Seek
  19. Which option in PivotTable Options makes a PivotChart automatically reflect changes when the workbook is opened? โ†’ Refresh data when opening the file
  20. What does TEXTJOIN do that CONCATENATE cannot? โ†’ Joins text with a delimiter and can ignore empty cells
  21. A column contains full names like Smith, John. Which Text to Columns option best splits them into last and first name columns? โ†’ Delimited with comma as the delimiter
  22. What file formats can Excel save workbooks in? โ†’ Multiple: .xlsx, .xlsm, .xlsb, .xls, .csv, .pdf, .html, and more
  23. What does the Analysis ToolPak add-in provide in Excel? โ†’ Statistical and engineering analysis functions
  24. What does VLOOKUP's fourth argument (range_lookup) control? โ†’ Exact match (FALSE) or approximate match (TRUE)
  25. What is Group and Outline used for? โ†’ Collapsing and expanding sections of rows or columns
  26. Which function is capable of displaying various values according to various conditions? โ†’ IF
  27. Which Excel feature allows you to apply consistent formatting across multiple cells based on their values? โ†’ Conditional Formatting
  28. Which Excel chart type is best suited for showing the proportion of parts to a whole? โ†’ Pie chart
  29. How do you compare two worksheets side by side? โ†’ View > View Side by Side with optional synchronized scrolling
  30. How do trendlines help with data analysis? โ†’ They fit mathematical models and can project future values

What Practice Test Geeks adds beyond an AI chat for Excel

An AI chatbot can quiz you, but it can't reproduce the exam conditions or keep your record. Here you get:

  • A timed, full-length Excel mock exam โ€” 35 questions in 50 minutes with a 70% pass mark, modeled on the official exam's question count and time limit, followed by a score report broken down by exam domain.
  • A fixed Excel question bank: the same test every attempt, so your score is comparable from one try to the next instead of changing with every regenerated quiz.
  • Progress saved on your device: completed tests, scores and missed questions stay in My Progress, so you can retake only what you got wrong.
  • Excel flashcards built from the same question bank.
  • Free Excel practice tests with the correct answer shown after each question.
Start the Timed Excel Mock Exam โ†’
Was this helpful?

Written and edited by , founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. store.certiport.com โ€” Fees, retake fee ยท verified Nov 2026
  2. certiport.pearsonvue.com โ€” Renewal, score validity, score release, exam format ยท verified Nov 2026
  3. learn.microsoft.com โ€” Test delivery, time limit, eligibility ยท verified Nov 2026