Microsoft Office and Networking Basics
14 Questions
0 Views

Microsoft Office and Networking Basics

Created by
@DecisiveDivergence7949

Podcast Beta

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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

  • Templates
  • SmartArt
  • Mail Merge (correct)
  • Macros
  • In Excel, what does the function =VLOOKUP(A2, B2:C10, 2, FALSE) do?

  • Looks up a value in any column and returns a value from the first column.
  • Finds the maximum value in a range.
  • Looks up a value in the first column and returns a value in the same row from another column. (correct)
  • Searches horizontally across the first row.
  • Which key combination is used to insert a new slide in a PowerPoint presentation?

  • Ctrl + O
  • Ctrl + S
  • Ctrl + M (correct)
  • Ctrl + N
  • In MS Outlook, what does the 'Out of Office' feature do?

    <p>Sends an automated reply to incoming emails.</p> Signup and view all the answers

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

    <p>.xlsx</p> Signup and view all the answers

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

    <p>AutoCorrect</p> Signup and view all the answers

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

    <p>DHCP</p> Signup and view all the answers

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

    <p>To connect different networks together</p> Signup and view all the answers

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

    <p>Session Layer</p> Signup and view all the answers

    What does the ping command do?

    <p>Tests the reachability of a host on an IP network.</p> Signup and view all the answers

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

    <p>Star</p> Signup and view all the answers

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

    <p>HTTPS</p> Signup and view all the answers

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

    <p>To block unauthorized access to or from a private network.</p> Signup and view all the answers

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

    <p>Phishing</p> 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.

    Quiz Team

    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!

    More Like This

    Use Quizgecko on...
    Browser
    Browser