Welcome to our free MCAS practice tests. Our 19 practice tests cover everything you need to know to pass your exam.

Each practice test includes detailed answer explanations to help you understand the correct answers.

Sample MCAS - Microsoft Certified Application Specialist Practice Questions

Try these questions from our free MCAS - Microsoft Certified Application Specialist practice tests. The correct answer and an explanation follow each question.

1. In Microsoft Excel, which function would you use to count only the cells in a range that meet a specific condition?

   • A. COUNT
   • B. COUNTIF
   • C. SUMIF
   • D. COUNTA

   Answer: B. COUNTIF

   COUNTIF counts cells within a range that meet a single criterion you specify.

2. What is the keyboard shortcut to open the Macro dialog box in Excel?

   • A. Alt + F8
   • B. Ctrl + M
   • C. Alt + F11
   • D. Ctrl + Shift + M

   Answer: A. Alt + F8

   Alt + F8 opens the Macro dialog box, where you can run, edit, or delete macros.

3. Which type of chart is most appropriate for displaying the percentage contribution of each category to a whole?

   • A. Clustered column chart
   • B. Pie chart
   • C. Line chart
   • D. Bubble chart

   Answer: B. Pie chart

   Pie charts display each category as a slice of the whole circle, making proportions and percentages easy to visualize.

4. What is the function of Microsoft OneNote?

   • A. Create spreadsheets
   • B. Organize and store notes
   • C. Send emails
   • D. Create databases

   Answer: B. Organize and store notes

   Microsoft OneNote functions as a digital notebook designed for organizing and storing various types of notes. Users can capture text, drawings, screen clippings, and audio commentaries in a free-form canvas, making it ideal for brainstorming, meeting notes, and personal organization. It allows for easy categorization and searchability across different notebooks and sections.

Take the full MCAS - Microsoft Certified Application Specialist practice test