Microsoft Office Skills Flashcards

In Word, what is the function of 'Mail Merge'?

Answer: Generating personalized documents by merging a template with a data source

Mail Merge creates multiple personalized documents (letters, labels, envelopes) by pulling data from a spreadsheet or database.

In Excel, what is the purpose of 'conditional formatting'?

Answer: Changing cell appearance based on values or rules

Conditional formatting changes the visual appearance (color, font, icons) of cells based on their values or custom rules.

In PowerPoint, what does the 'Animation Painter' tool do?

Answer: Copies animation effects from one object and applies them to another

Animation Painter works like Format Painter but for animations, copying effects from one object to another with one click.

In Excel, which function looks up a value in the first column of a table and returns a value in the same row from a specified column?

Answer: VLOOKUP

VLOOKUP (Vertical Lookup) searches down the first column of a range and returns the corresponding value from a specified column.

In Outlook, what is the purpose of the 'Rules' feature?

Answer: Automatically organizing, moving, or flagging emails based on conditions

Rules automatically perform actions (move, flag, forward, delete) on incoming or outgoing messages that meet defined criteria.

In Word, what does 'Show/Hide' (¶) button reveal?

Answer: Non-printing characters like spaces, paragraph marks, and tabs

The Show/Hide button displays formatting marks such as paragraph breaks, spaces, and tabs that are normally invisible.

In Excel, what is the difference between 'Save' and 'Save As'?

Answer: Save updates the existing file; Save As lets you save with a new name, format, or location

Save overwrites the current file, while Save As allows you to specify a new file name, file type, or save location.