Logo
EDUCATION MATTERS
Guide
7 Questions
Approx 7 Minutes

Mastering Workplace Applications

The Common Application & MS Office round evaluates your digital literacy. In the actual exam, this section consists of 7 questions. Read the guide below, then test yourself.

The 4 Core Pillars

Microsoft Excel

  • • Functions: SUM, AVERAGE, COUNT, VLOOKUP.
  • • References: Absolute ($A$1) vs. Relative (A1).
  • • Data Tools: Pivot tables, sorting, filtering.
Also prepare: Ribbon formatting, Creating charts, Data Validation, Conditional Formatting, and Print setup.

Microsoft Word

  • • Layouts: Headers, Footers, Page Breaks.
  • • Advanced: Mail Merge and Track Changes.
  • • References: Table of Contents.
Also prepare: Ribbon tabs, Inserting Images/Shapes, Adjusting Margins, Document Watermarks.

PowerPoint

  • • Design: Slide Master and Themes.
  • • Motion: Transitions vs. Animations.
  • • Delivery: Presenter View and Slide Sorter.
Also prepare: Inserting Charts/Graphs, Slide Layouts, SmartArt, Morph transition, and Rehearse Timings.

Outlook & OS

  • • Email: CC, BCC, and Rules.
  • • Calendar: Scheduling and shared calendars.
  • • OS: Basic file structures and system concepts.
Also prepare: Email attachments, Out-of-office replies, Flagging, Junk mail management, and Contact groups.

Exam Strategy & Pro-Tips

Don't Overthink

If you know the shortcut for "Find and Replace" (Ctrl+H), just select it. Do not second-guess yourself on basic computer literacy questions.

Watch the Clock

You have roughly 1 minute per question. If you get stuck on an obscure Excel formula, flag it, guess, and move on.

Keyboard Shortcuts Win

Memorize the essentials: Ctrl+S (Save), Ctrl+Z (Undo), Ctrl+P (Print), F5 (Slideshow), and Alt+Tab (Switch windows).

Eliminate Absurd Options

If an Excel formula option looks made-up (e.g., "AVERAGE_SUM()"), it is definitely wrong. Use the process of elimination.

Ready to test your knowledge?

You have reviewed the core concepts and exam traps. It is time to put your skills to the test with our 7-question simulated assessment.

Disclaimer: Education Matters is an independent educational platform. We are not affiliated with, endorsed by, or sponsored by Accenture or any other company. All company names and trademarks are the property of their respective owners. Our practice tests are simulations designed for educational purposes only.