MO-201 Question #1: Real Exam Question with Answer & Explanation

Question

You are analyzing data about the number of visitors to U.S. National Parks. Configure Excel so that you can edit content using Albanian as the editing language.

Explanation

Excel Editing Language Configuration: Albanian

Overall Goal

The editing language in Excel controls how the application handles text input, spell-checking, grammar checking, hyphenation, and autocorrect for content you type. Setting Albanian as the editing language tells Excel to apply Albanian linguistic rules when processing cell content. This is separate from the display language (which controls the UI/menus). This is the correct approach because editing language is a per-language setting managed in Office's central language options.

Step-by-Step Procedure

1. Open Excel Options

• Go to File → Options
• This opens the central configuration dialog for Excel. You cannot reach language settings from the ribbon directly.

2. Navigate to the Language tab

• In the left panel, click Language
• This section is specifically where Office manages both display and editing languages. Skipping straight here without knowing where it lives is the most common point of confusion.

3. Locate "Office authoring languages and proofing"

• This section lists currently installed/active editing languages.
• Skipping this step and editing elsewhere would change the wrong setting (e.g., display language instead of editing language).

4. Click "Add a Language..."

• A dropdown or dialog appears listing all available languages.
• This is necessary because languages not yet added won't appear in the active list.

5. Select "Albanian" and click Add

• Albanian (sq) is added to the list.
• If you skip this and only look at existing entries, Albanian won't be available if it wasn't previously added.

6. Set Albanian as the preferred editing language (if required)

• Click Set as Preferred (or similar button) if the question asks for it to be the active default.
• Without this step, Albanian is installed but not necessarily the active editing language.

7. Click OK and restart Excel

• Language changes typically require an application restart to take effect.
• Skipping the restart means the change won't be applied to your session.

What Goes Wrong If Steps Are Skipped

Memory Tip

"FOLAG-R" - File, Options, Language, Add, Go (set preferred), Restart.

Think of it as: "I need to flag Albanian as my editing language."

No community discussion yet for this question.