PassEveryTest
العربية

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.

  • دورة
  • كندا
  • عدد الأسئلة: 90
  • تمت المراجعة في 13 أكتوبر 2026
  • تم التحقق من الحقائق في 13 أكتوبر 2026

إجابة سريعة

تتضمن هذه الدورة المجانية نحو 300 دقيقة من الدروس، و5 اختبارات موضوعية بلا وقت محدد (90 سؤالًا إجمالًا)، وتقييمًا نهائيًا محدد الوقت من 35 سؤالًا يُختار عشوائيًا. احصل على 80% أو أكثر في التقييم النهائي لتنزيل شهادة إتمام (خاصة، غير معتمدة). تمت مراجعته مقارنةً بالمصادر الرسمية في 13 أكتوبر 2026.

ابدأ بالدروسMicrosoft Office Specialist: Excel Exam Preparation: Lessons: نحو 300 دقيقة من القراءة. كل أسئلة الاختبار مشروحة في الدروس.

ما ستتعلمه

  • 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

احصل على 80% أو أكثر لتنزيل شهادتك.

خطتك الدراسية

اقرأ كل درس، ثم أجرِ اختبار موضوعه (بلا وقت محدد ومع الشرح)، ثم التقييم النهائي المحدد بوقت. تُختار مجموعة جديدة من الأسئلة في كل مرة. يُحفظ تقدمك في هذا المتصفح.

  1. اقرأ الدروس5 دروس، نحو 300 دقيقة
  2. اختبار الموضوع 1: Manage worksheets and workbooksعدد الأسئلة: 20
  3. اختبار الموضوع 2: Manage data cells and rangesعدد الأسئلة: 20
  4. اختبار الموضوع 3: Manage tables and table dataعدد الأسئلة: 15
  5. اختبار الموضوع 4: Perform operations by using formulas and functionsعدد الأسئلة: 20
  6. اختبار الموضوع 5: Manage chartsعدد الأسئلة: 15
  7. الامتحان النهائي35 سؤالًا، 50 دقيقة · احصل على 80% أو أكثر

اختبار الموضوع 1: Manage worksheets and workbooks

  1. السؤال 1 من 20

    On which ribbon tab do you find Freeze Panes?
    أظهر الإجابة

    الإجابة: B. View

    Freeze Panes is in the Window group on the View tab.

  2. السؤال 2 من 20

    You want row 1 (the headings) to stay on screen while you scroll down a long list. What should you use?
    أظهر الإجابة

    الإجابة: C. View > Freeze Panes > Freeze Top Row

    Freeze Top Row keeps row 1 visible while you scroll. Print Titles only affects printed pages.

  3. السؤال 3 من 20

    You select cell C3 and choose View > Freeze Panes > Freeze Panes. What stays locked on screen?
    أظهر الإجابة

    الإجابة: 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.

  4. السؤال 4 من 20

    A manager asks to see the formulas in the cells instead of their results. What is the fastest way to do this for the whole sheet?
    أظهر الإجابة

    الإجابة: C. Formulas > Show Formulas (or Ctrl+`)

    Show Formulas switches the sheet to display formulas. Press it again (or Ctrl+`) to show results.

  5. السؤال 5 من 20

    You received a comma-separated text file of patrol times. How do you bring it into Excel as data you can preview first?
    أظهر الإجابة

    الإجابة: 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.

  6. السؤال 6 من 20

    Which command imports a table from a page on the internet by entering its web address?
    أظهر الإجابة

    الإجابة: 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.

  7. السؤال 7 من 20

    A workbook has a named range called Rates. What is the quickest way to select it?
    أظهر الإجابة

    الإجابة: 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.

  8. السؤال 8 من 20

    A cell contains a hyperlink to a supplier website. You want to keep the text but remove the link. What should you do?
    أظهر الإجابة

    الإجابة: 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.

  9. السؤال 9 من 20

    A 6-page staff list must show the heading row at the top of every printed page. Where do you set this?
    أظهر الإجابة

    الإجابة: 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.

  10. السؤال 10 من 20

    You only ever want cells A1:F20 to print. What should you set?
    أظهر الإجابة

    الإجابة: B. Page Layout > Print Area > Set Print Area

    A print area tells Excel which cells to print, and it is saved with the workbook.

  11. السؤال 11 من 20

    You hold Ctrl, select A1:C10 and E1:G10, and set them as the print area. How do they print?
    أظهر الإجابة

    الإجابة: 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.

  12. السؤال 12 من 20

    In a footer you want "Page 2 of 5". Which code shows the current page number?
    أظهر الإجابة

    الإجابة: D. &[Page]

    &[Page] is the current page number and &[Pages] is the total number of pages, so the footer is &[Page] of &[Pages].

  13. السؤال 13 من 20

    Which view shows blue lines where each printed page will break, so you can drag them?
    أظهر الإجابة

    الإجابة: B. Page Break Preview

    Page Break Preview (View > Workbook Views) shows page breaks you can move. Normal view does not show the page layout.

  14. السؤال 14 من 20

    You use Sort A to Z many times a day. How can you add it to the Quick Access Toolbar?
    أظهر الإجابة

    الإجابة: C. Right-click Sort A to Z > Add to Quick Access Toolbar

    Right-clicking almost any ribbon command offers Add to Quick Access Toolbar.

  15. السؤال 15 من 20

    Where do you add a Title and Tags to the workbook's document properties?
    أظهر الإجابة

    الإجابة: A. File > Info, in the Properties list

    File > Info shows the workbook properties, such as Title, Tags and Author, which you can edit there.

  16. السؤال 16 من 20

    A workbook has three sheets. You save it as CSV (Comma delimited). What is saved in the CSV file?
    أظهر الإجابة

    الإجابة: 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.

  17. السؤال 17 من 20

    You must send a schedule that should look the same on any computer and not be easy to edit. Which format fits best?
    أظهر الإجابة

    الإجابة: 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.

  18. السؤال 18 من 20

    What is the path to run the Document Inspector in Excel?
    أظهر الإجابة

    الإجابة: A. File > Info > Check for Issues > Inspect Document

    The Document Inspector is under File > Info > Check for Issues > Inspect Document.

  19. السؤال 19 من 20

    Why does Microsoft advise running the Document Inspector on a copy of the workbook?
    أظهر الإجابة

    الإجابة: 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.

  20. السؤال 20 من 20

    You want a co-worker to answer a question you left on cell D8, with replies kept together. What should you add?
    أظهر الإجابة

    الإجابة: C. A threaded comment (Review > New Comment)

    Threaded comments have a Reply box for discussion. Notes are yellow annotations with no Reply box.

ما يجب معرفته قبل الاختبار

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

الأسئلة الشائعة

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.

هل الشهادة معتمدة أو معترف بها رسميًا؟

لا. إنها شهادة إتمام خاصة للمعرفة فقط. وهي غير معترف بها أو معتمدة أو موافق عليها من أي حكومة أو جهة ترخيص أو هيئة تنظيمية أو مؤسسة تعليمية، ولا تحل محل أي رخصة أو شهادة أو تدريب يفرضه القانون.

المصادر

اختبارات ذات صلة