MS Office

The VLOOKUP function in Excel searches for a value in the leftmost column of a table and returns a value in the same row from a specified column. Option A correctly describes this vertical lookup process.

The Document Map in MS Word provides a navigation pane that allows users to quickly move through different sections or headings of a document, making navigation faster and easier.

In Microsoft Word, the shortcut key to mark a citation is Alt + Shift + I. This opens the Mark Citation dialog box, allowing users to add a citation to the document.

A motion path in Microsoft PowerPoint is an animation effect that moves an object along a specified path on a slide. It is not an entrance effect nor a method of advancing slides, so option C is correct.

The default font size in Microsoft PowerPoint for body text in text placeholders is typically 18 points. This is the standard size used in new presentations unless changed by the user or template. The options 10, 11, and 12 are common font sizes but not the default in PowerPoint. Therefore, the correct answer is D (18).

A slide-title master pair in PowerPoint refers to a combination of a slide master and its associated title master that together define the layout and design for a specific template. This pairing controls the formatting of both the slide content and the title area consistently.

The Document Outline View in MS Word displays the structure of the document based on headings at various levels, allowing users to easily navigate and organize content hierarchically.

In Microsoft Word, cross-references are inserted as Word fields, which dynamically link to other parts of the document such as headings, figures, or tables. This allows the referenced content to update automatically if it changes.

In MS PowerPoint, to remove or hide the border of a shape, you select the 'No Line' option, which removes the outline of the shape. 'No Outline' is not an option in PowerPoint's shape formatting.

In MS Word, the ruler can be activated by going to the View tab on the ribbon and then selecting the Ruler option. This allows users to see and adjust margins, indents, and tabs visually.

Lines, curves, freeform, and scribble are types of custom motion paths in PowerPoint that allow users to define specific movement paths for animations.

Pressing Ctrl + Shift + F8 in Microsoft Word activates the rectangular selection mode, allowing you to select a block of text in a rectangular shape rather than the usual linear selection.

To make a PowerPoint photo album slide show play continuously, you need to set the slide show to loop continuously. This option ensures the presentation restarts automatically after the last slide, enabling continuous playback.

A Slide-title master pair in Microsoft PowerPoint refers to the combination of a slide master and a title master that together define the layout and design for a specific template. This pairing controls the appearance of both the slide content and the title area consistently across slides using that template.

A 'Section' in a document refers to a portion where specific page formatting options like margins, headers, footers, or orientation can be set independently from other parts of the document.

In Microsoft Excel, the 'Chart Wizard' is the tool used to create charts by guiding users through the steps to select chart types and data ranges. The other options do not correspond to standard Excel features for creating charts.

The EXT indicator on the Microsoft Word status bar shows whether the Extended Selection mode is active. When this mode is on, users can select text by moving the cursor with arrow keys, extending the selection without using the mouse.

A motion path in PowerPoint is an animation effect that allows you to move an object along a specified path on a slide. It is not a slide transition or a general method of advancing slides, but specifically an animation for moving items on a slide.

Page numbers can be inserted in either the header or the footer of a document, so both options A and B are correct, making option C the right choice.

A 'style' in word processing software like MS Word is defined as a collection of character and paragraph formatting commands that can be applied to text to ensure consistent formatting.

The 'Ctrl + F' shortcut in Microsoft Word opens the Find dialog, allowing users to search for characters, words, and symbols within the document. This makes option B the correct answer.

The EXT indicator on the status bar of MS Word shows whether the Extended Selection mode is active. When this mode is on, users can select text by moving the cursor with arrow keys, extending the selection.

The 'Change Case' option permanently changes the text to uppercase, meaning the actual characters are converted. In contrast, the 'All Caps' option in the Font dialog box is a formatting effect that displays text in uppercase but retains the original lowercase characters, allowing easy reversion.

When you insert an AutoShape by clicking in the document, it appears near the insertion point, is inserted in its default size, and is automatically selected, so all the listed options are correct.

User-developed instructions in Excel are called Macros, which are sequences of commands and functions that automate tasks.