Mixed Deck — All MOS Topics Flashcards

What does the 'Send Update' button do when you modify an existing meeting you organized?

Answer: It emails all attendees with the updated meeting details so they can accept or decline the changes

After modifying a meeting, clicking Send Update pushes the revised details to all invitees so their calendars reflect the changes.

When you freeze panes in Excel, where does the freeze line appear relative to the selected cell?

Answer: Below and to the right of the selected cell

Freeze Panes freezes all rows above and all columns to the left of the currently selected cell.

What is the maximum number of rows supported in an Excel worksheet (Excel 2016 and later)?

Answer: 1,048,576

Excel 2007 and later versions support up to 1,048,576 rows per worksheet.

Which formula correctly uses an absolute reference so that C1 does not change when the formula is copied down column D?

Answer: =A1*$C$1

Using $C$1 locks both the column and row of C1, so it remains constant when the formula is copied in any direction.

To add a trendline to a chart, you must first:

Answer: Select the data series in the chart

A trendline is added to a specific data series, so you must select that series before accessing the Add Trendline option.

In Outlook, what is the function of the 'Junk Email' filter?

Answer: Moves messages identified as spam to the Junk Email folder

The Junk Email filter automatically evaluates incoming messages and moves suspected spam to the Junk Email folder.

You want a layout to use a two-column text arrangement. What is the correct approach in Slide Master view?

Answer: Insert two separate Text placeholders side by side on the layout

Inserting two separate Text (or Content) placeholders positioned side by side on a layout creates a two-column arrangement for that layout.

Which option in Excel's Paste Special dialog lets you paste only the results of formulas, not the formulas themselves?

Answer: Paste Values

Paste Values pastes only the calculated results of formulas, stripping out the underlying formula.

What does the 'Character Spacing' setting 'Expanded' do to text?

Answer: Adds space between individual characters

The 'Expanded' character spacing option increases the amount of space between each character in the selected text.

When you move a chart from the current worksheet to a separate chart sheet, the chart's data source:

Answer: Remains linked to the original worksheet

Moving a chart to a chart sheet only relocates the chart object; the data still resides in and links to the original worksheet.

Which Picture Format option lets you choose a specific color in the image to make fully transparent?

Answer: Color > Set Transparent Color

Set Transparent Color lets you click any single color in the image to make all pixels of that color transparent.

In Word, how do you insert a non-breaking hyphen to prevent a hyphenated word from splitting across lines?

Answer: Ctrl+Shift+Hyphen

Ctrl+Shift+Hyphen inserts a non-breaking hyphen that keeps hyphenated words together on the same line.

A Radar chart is best suited for which type of analysis?

Answer: Comparing multiple attributes of several items simultaneously

Radar (or spider) charts display multiple quantitative variables on axes radiating from a central point, ideal for comparing profiles across categories.

When you click the small arrow at the bottom-right of the Font group on the Home tab, what opens?

Answer: The full Font dialog box

Clicking the dialog launcher arrow in the Font group opens the full Font dialog box with all advanced character formatting options.

In Outlook, what is the 'Clutter' or 'Focused Inbox' feature designed to do?

Answer: Separate high-priority messages from less important ones into two tabs

Focused Inbox separates your inbox into 'Focused' (important messages) and 'Other' (lower-priority messages) tabs.

Which Outlook feature automatically moves incoming messages from a specific sender to a designated folder?

Answer: Rules

Rules in Outlook automatically process incoming or outgoing messages based on conditions you define, such as moving emails from a specific sender to a folder.

You are sending an email to your team to decide on a location for a company lunch and want to get structured feedback directly within the email. Which message option allows you to embed predefined choices that recipients can click to respond?

Answer: Use Voting Buttons

Voting buttons are specifically designed to create a poll within an email, allowing recipients to select from predefined options. Outlook can then track and tally the responses for the sender. The other options serve different purposes like tracking delivery, setting priority, and classifying information.

What is the primary purpose of a primary key in an Access table?

Answer: To uniquely identify each record in the table

A primary key uniquely identifies each record in a table, ensuring no two records have the same key value.

A user is trying to find an important email from last quarter that had a contract attached. They remember the sender was "David Chen" and the subject line contained the word "Agreement". Which of the following is the most effective search query to use in the Outlook search bar?

Answer: from:"David Chen" AND hasattachments:yes AND subject:Agreement

Using specific search keywords like `from:`, `subject:`, and `hasattachments:yes` combined with the `AND` operator provides the most precise criteria to find the exact email. The other options are either too broad, use the wrong operator (OR), or use incorrect syntax.

Which Excel function converts text that represents a number into an actual number?

Answer: VALUE

VALUE converts a text string that looks like a number into a numeric value that can be used in calculations.