Microsoft Office Specialist: Excel Exam Preparation 2026
This course is for people preparing for exam MO-210, the Microsoft Office Specialist exam for Excel (Microsoft 365 Apps). Five lessons follow the five skill areas in Microsoft's skills outline, each with a practical exercise you do in Excel. Each lesson has an untimed topic quiz with explanations, and a timed 35-question final assessment unlocks a certificate of completion when you score 80% or more.
Respuesta rápida
Este curso gratuito tiene unos 300 minutos de lecciones, 5 pruebas temáticas sin límite de tiempo (90 preguntas en total) y una evaluación final cronometrada de 35 preguntas elegidas al azar. Saca un 80 % o más en la evaluación final para descargar un certificado de finalización (privado, no acreditado). Contrastado con fuentes oficiales el 13 de octubre de 2026.
Qué aprenderás
- Describe the MO-210 exam format, timing, scoring and five skill areas
- Import data, navigate workbooks, and set views, print settings, headers and footers
- Prepare a workbook for sharing with the right file format, the Document Inspector, comments and notes
- Fill and format cells with Paste Special, Auto Fill, SEQUENCE, named ranges, sparklines and conditional formatting
- Create, change, sort and filter Excel tables with a total row
- Write formulas with relative, absolute, mixed and structured references and the functions on the skills list
- Create and format charts and chart sheets, including alt text
Obtén un 80 % o más para descargar tu certificado.
Tu plan de estudio
Lee cada lección, haz su prueba temática (sin límite de tiempo, con explicaciones) y luego la evaluación final cronometrada. Cada vez se elige una nueva mezcla de preguntas. Tu progreso se guarda en este navegador.
- Leer las lecciones5 lecciones, unos 300 min
- Prueba temática 1: Manage worksheets and workbooks20 preguntas
- Prueba temática 2: Manage data cells and ranges20 preguntas
- Prueba temática 3: Manage tables and table data15 preguntas
- Prueba temática 4: Perform operations by using formulas and functions20 preguntas
- Prueba temática 5: Manage charts15 preguntas
- Examen final35 preguntas, 50 min · Obtén un 80 % o más
Prueba temática 1: Manage worksheets and workbooks
-
Pregunta 1 de 20
Ver respuesta
Respuesta: B. View
Freeze Panes is in the Window group on the View tab.
-
Pregunta 2 de 20
Ver respuesta
Respuesta: C. View > Freeze Panes > Freeze Top Row
Freeze Top Row keeps row 1 visible while you scroll. Print Titles only affects printed pages.
-
Pregunta 3 de 20
Ver respuesta
Respuesta: C. Rows 1–2 and columns A–B
Freeze Panes locks the rows above and the columns to the left of the selected cell. Above C3 are rows 1–2; to the left are columns A–B.
-
Pregunta 4 de 20
Ver respuesta
Respuesta: C. Formulas > Show Formulas (or Ctrl+`)
Show Formulas switches the sheet to display formulas. Press it again (or Ctrl+`) to show results.
-
Pregunta 5 de 20
Ver respuesta
Respuesta: C. Data > From Text/CSV
From Text/CSV (in Get & Transform Data) opens a preview where you check the delimiter, then Load or Transform Data.
-
Pregunta 6 de 20
Ver respuesta
Respuesta: D. Data > From Web
From Web asks for a URL and lets you choose a table from that page. Insert > Link only makes a hyperlink.
-
Pregunta 7 de 20
Ver respuesta
Respuesta: A. Choose Rates from the Name Box list
The Name Box (left of the formula bar) lists named ranges; picking one selects it. Go To (F5 or Ctrl+G) also works. Find only searches cell contents.
-
Pregunta 8 de 20
Ver respuesta
Respuesta: C. Right-click it and choose Remove Hyperlink
Remove Hyperlink keeps the cell text and removes only the link. Delete would clear the text too.
-
Pregunta 9 de 20
Ver respuesta
Respuesta: D. Page Layout > Print Titles > Rows to repeat at top
Print Titles repeats chosen rows on every printed page. Freeze Panes only affects the screen.
-
Pregunta 10 de 20
Ver respuesta
Respuesta: B. Page Layout > Print Area > Set Print Area
A print area tells Excel which cells to print, and it is saved with the workbook.
-
Pregunta 11 de 20
Ver respuesta
Respuesta: B. Each area prints on its own page
When a sheet has more than one print area, each print area prints on a separate page.
-
Pregunta 12 de 20
Ver respuesta
Respuesta: D. &[Page]
&[Page] is the current page number and &[Pages] is the total number of pages, so the footer is &[Page] of &[Pages].
-
Pregunta 13 de 20
Ver respuesta
Respuesta: B. Page Break Preview
Page Break Preview (View > Workbook Views) shows page breaks you can move. Normal view does not show the page layout.
-
Pregunta 14 de 20
Ver respuesta
Respuesta: C. Right-click Sort A to Z > Add to Quick Access Toolbar
Right-clicking almost any ribbon command offers Add to Quick Access Toolbar.
-
Pregunta 15 de 20
Ver respuesta
Respuesta: A. File > Info, in the Properties list
File > Info shows the workbook properties, such as Title, Tags and Author, which you can edit there.
-
Pregunta 16 de 20
Ver respuesta
Respuesta: C. Only the active sheet, as plain text without formatting
A CSV file holds one sheet of plain text values. Excel saves only the active sheet and drops formatting.
-
Pregunta 17 de 20
Ver respuesta
Respuesta: D. PDF
Saving or exporting as PDF keeps the printed layout and is not edited like a workbook. CSV and text files lose the layout.
-
Pregunta 18 de 20
Ver respuesta
Respuesta: A. File > Info > Check for Issues > Inspect Document
The Document Inspector is under File > Info > Check for Issues > Inspect Document.
-
Pregunta 19 de 20
Ver respuesta
Respuesta: D. Removed items may not be recoverable, even with Undo
Content that the inspector removes might not come back with Undo, so keep the original and inspect a copy.
-
Pregunta 20 de 20
Ver respuesta
Respuesta: C. A threaded comment (Review > New Comment)
Threaded comments have a Reply box for discussion. Notes are yellow annotations with no Reply box.
Teclado: 1–4 para responder, Intro para la siguiente pregunta.
Qué debes saber antes del examen
- Passing exam MO-210: Microsoft Excel (Microsoft 365 Apps) earns the Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) certification.
- Microsoft lists five skill areas: manage worksheets and workbooks (25–30%), manage data cells and ranges (25–30%), manage tables and table data (10–15%), formulas and functions (15–20%) and charts (15–20%).
- You have 50 minutes to complete the exam. Certiport lists 33–37 questions for the Excel exam, and the time covers the timed portion only, not check-in and the tutorial.
- Certiport describes Microsoft Office Specialist exams as performance-based, with hands-on, live-in-the-application testing.
- Certiport reports scores on a 1–1000 scale, and the passing value is always equated to 700.
- If you do not pass, you must wait 24 hours before a second attempt, then 2 days (48 hours) before each later retake.
- Microsoft suggests candidates have about 150 hours of instruction and hands-on experience with Excel.
Preguntas frecuentes
Is this the official MO-210 exam?
No. This is an independent practice course with original questions. The real exam is taken in Excel itself, proctored, and booked through Certiport.
What does the certificate of completion show?
It shows that you finished this course and scored at least 80% on its final assessment. It is not the Microsoft Office Specialist certification and is not issued by Microsoft or Certiport.
How is the real exam scored?
Certiport reports scores on a scale of 1 to 1000, and the passing value is always equated to 700. Your score report shows the passing score for your exam.
How long is the real exam?
Microsoft gives 50 minutes for the exam, and Certiport lists 33–37 questions for Excel. Plan extra time at the test centre for check-in and the tutorial.
How is this course different from the general Excel courses?
It follows the MO-210 skills outline closely, including printing, sharing, tables and charts, and uses the exam's own skill areas as its topics. The final assessment is 35 questions in 50 minutes to match the exam's pace.
Can my practice score predict my exam result?
No. The real exam is hands-on and scaled, so practice scores here are feedback only. Practise each task in Excel until you can do it quickly.
¿El certificado está acreditado o reconocido oficialmente?
No. Es un certificado de finalización privado, solo para tus conocimientos. No está reconocido, acreditado ni aprobado por ningún gobierno, organismo de licencias, regulador ni institución educativa, y no sustituye ninguna licencia, certificación ni formación exigida por la ley.
Fuentes
- Microsoft: Exam MO-210 Microsoft Excel (Microsoft 365 Apps) skills outline
- Microsoft Learn: Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps)
- Certiport: Exam lengths
- Certiport: Exam scoring policy
- Certiport: Retake policy
- Certiport: Microsoft Office Specialist overview
- Certiport: Schedule a Microsoft exam