Microsoft Office and Networking Basics

Which feature in MS Word allows you to create a set of documents that have the same layout but different content?

In Excel, what does the function =VLOOKUP(A2, B2:C10, 2, FALSE) do?

Which key combination is used to insert a new slide in a PowerPoint presentation?

In MS Outlook, what does the 'Out of Office' feature do?

What is the default file extension for an Excel 2016 workbook?

Which MS Word feature automatically corrects common typing errors as you type?

Which protocol is used to assign IP addresses automatically to devices on a network?

What is the primary purpose of a router in a network?

Which layer of the OSI model is responsible for establishing, managing, and terminating connections?

What does the ping command do?

Which network topology has a central hub to which all other nodes are connected?

Which protocol is commonly used for secure communication over a network?

What is the primary function of a firewall in network security?

Which of the following is considered a form of social engineering attack?

Microsoft Word

Mail Merge allows creating documents with the same layout but different content.
Templates pre-defined layouts for documents.
AutoCorrect feature automatically corrects common typing errors.
SmartArt provides graphical representations to visualize data.

Microsoft Excel

=VLOOKUP(A2, B2:C10, 2, FALSE) looks up a value in the first column (A2) and returns a value in the same row from the second column of the specified range.
Default file extension for an Excel workbook is .xlsx.

Microsoft PowerPoint

Ctrl + M is the key combination to insert a new slide in a PowerPoint presentation.

Microsoft Outlook

The "Out of Office" feature sends an automated reply to incoming emails when you are unavailable.

Networking Basics

DHCP protocol is responsible for automated IP address allocation on a network.
Routers connect different networks together.
Ping command tests the reachability of a host on an IP network.
Star topology involves a central connecting point (hub) linked to every other node in the network.

OSI Model

Session Layer of the OSI model manages and terminates connections.

Network Security

HTTPS protocol is commonly used for secure communication over a network.
Firewall is used to block unauthorized access to or from a private network.
Phishing is a social engineering attack that aims to trick users into providing sensitive information.

Test your knowledge on Microsoft Office applications including Word, Excel, PowerPoint, and Outlook, as well as foundational networking concepts. This quiz covers important features, functions, and terms you should know. Perfect for users looking to enhance their computer skills!