Office Technology and Software Applications Flashcards

Which function in Excel combines text from multiple cells into one cell?

Answer: CONCATENATE or CONCAT

CONCATENATE (or the newer CONCAT and & operator) joins text strings from multiple cells into a single cell.

In Microsoft Outlook, a 'distribution list' (or contact group) is used to:

Answer: Send one email to multiple recipients using a single group name

A distribution list or contact group lets you email a pre-defined group of people at once by entering just the group name.

What is the purpose of a 'macro' in Microsoft Office applications?

Answer: To record and automate a sequence of repetitive tasks

Macros record a series of actions that can be replayed automatically to save time on repetitive tasks.

Which type of chart in Excel is best suited to show proportional parts of a whole?

Answer: Pie chart

A pie chart visually represents how each part contributes to the total, making proportions easy to compare.

In the context of office printers and copiers, what does 'duplex printing' mean?

Answer: Printing on both sides of the paper automatically

Duplex printing prints on both sides of a sheet of paper, reducing paper usage and costs.

What is 'phishing' in the context of office cybersecurity?

Answer: Fraudulent emails or messages designed to trick users into revealing sensitive information

Phishing attacks use deceptive emails or websites to trick employees into disclosing passwords, financial data, or other sensitive information.

In Microsoft Word, which page layout orientation is typically used for wide tables or landscape images?

Answer: Landscape

Landscape orientation rotates the page so it is wider than it is tall, ideal for wide tables, charts, or presentations.