Podcast Beta
Questions and Answers
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?
Signup and view all the answers
What is the default file extension for an Excel 2016 workbook?
Signup and view all the answers
Which MS Word feature automatically corrects common typing errors as you type?
Signup and view all the answers
Which protocol is used to assign IP addresses automatically to devices on a network?
Signup and view all the answers
What is the primary purpose of a router in a network?
Signup and view all the answers
Which layer of the OSI model is responsible for establishing, managing, and terminating connections?
Signup and view all the answers
What does the ping command do?
Signup and view all the answers
Which network topology has a central hub to which all other nodes are connected?
Signup and view all the answers
Which protocol is commonly used for secure communication over a network?
Signup and view all the answers
What is the primary function of a firewall in network security?
Signup and view all the answers
Which of the following is considered a form of social engineering attack?
Signup and view all the answers
Study Notes
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.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
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!