Home / Solved MCQS / One Liner: MS Word, MS Excel, Spreadsheet, Computer Network, Communication, and Security Threats

One Liner: MS Word, MS Excel, Spreadsheet, Computer Network, Communication, and Security Threats

There is no denial of the fact that the computer has now become a very important tool in daily life activities. Be it a field of education, business, e-commerce, manufacturing, navigation, transportation, security, internet-banking, problem-solving, data storage as well as communication; the use of computers is inescapable. It is really important to have a very basic knowledge of computer, MS Office, E-mail, the internet.

Network, and Communication

  1. The sharing of data among computers is called data communication.
  2. Data communication has enabled us to send and receive data and information from one computer to other computers.
  3. Many computer systems connected together form a network.
  4. A computer network ranges from a basic school or home network of only a few computers to large networks such as the internet.
  5. A computer network is the interconnection of two or more computer systems located in the same room, building, or at different places.
  6. Internet is a worldwide collection of networks that allows a subscriber to send and receive e-mails, chats, or browse the world wide web to get information about various topics.
  7. A computer network comprises; sending and receiving device, transmission medium, and communication medium.
  8. The sending device is usually a computer.
  9. The receiving device can be a computer, printer, or storage device.
  10. The modem is a popular communication device that is used for internet communication.
  11. The transmission medium is a channel or path through which the data or information is transferred from one place to another place in a computer network.
  12. Networks are connected via a wired or wireless transmission medium.
  13. A server is a powerful computer that facilities the whole network by providing a variety of services to a computer or devices connected to the network.
  14. The client is a less powerful computer and it relies on a server for resources such as files, devices, or even processing power.
  15. On the basis of geographic distance, a computer network is categorized into LAN, MAN, and, WAN.
  16. LAN is usually confined to a building or adjacent buildings.
  17. LAN is the most common type of network.
  18. LAN is usually owned by one organization.
  19. Special security measures are needed to stop the unauthorized users in LAN.
  20. MAN extends to a city or to a metropolitan region.
  21. A MAN connects two or more LANs to form a network that spread over the whole city.
  22. An example of a metropolitan area network is a cable television network.
  23. MAN is bigger than LAN.
  24. MAN transfers data at high speed.
  25. MAN is more expensive and difficult to maintain.
  26. WAN extends up to a state, province, country or whole world.
  27. WAN connects many small networks.
  28. Many organizations develop their own private WANs.
  29. An example of WAN is the internet.
  30. WAN can monitor distant locations and offices.
  31. The most commonly used communication devices are: Dialup Modem, and Network Interface Card (NIC).
  32. A Dialup Modem is used to connect to the internet, exchange information, and send and receive data from one computer to the other computer.
  33. A modem can be located inside or outside the computer.
  34. In a computer, information is stored digitally.
  35. Information is transmitted over telephone lines in the form of analog signals.
  36. A modem converts digital signals to analog signals(modulation).
  37. The modem also converts analog signals to digital signals (demodulation).
  38. NIC is an expansion card.
  39. NIC card enables a computer to connect to a network.
  40. Each NIC has a unique serial number that is used to identify a computer on the network.
  41. A network interface card must be installed on a computer on the network.
  42.  Physical transmission media is also called guided media.
  43. There are three forms of physical transmission media that are; twisted pair cable, fiber optic cable, coaxial cable.
  44. Guided media is the transmission media in which data is guided by cable or wire.
  45. Unguided media or wireless media doesn’t use any physical connections between any two devices.
  46. A twisted pair cable is used in LAN. It consists of two strands of copper twisted together.
  47. The twisted-pair cable is of two types; unshielded twisted pair, and shielded pair cable.
  48. The twisted-pair cable is the least expensive and easy to install.
  49. Coaxial cable is used by the cable television industry and computer networks.
  50. In the coaxial cable, the wire is surrounded by insulation and a shield of braided wire. The shied minimizes electrical and radio frequency interference.
  51. Coaxial cable has more data transfer rate than twisted pair cable.
  52. Fiber optic is a type of cable that uses glass or plastic threads to transmit data.
  53. Fiber optic cable consists of a central glass core surrounded by layers of protective materials such as cladding and a buffer coating.
  54. The data transfer rate of fiber optic cable is highest than other cables, and it is expensive than other cables; and difficult to install.
  55. Cutting edge technology is the most advanced developments in computer technology. Cellular communication, satellite communication, GPS, and Bluetooth are a few cutting edge technologies in the field of networks and communication.
  56. Cellular communication is radio communication.
  57. Each cell is served as one fixed-location transceiver known as a cell site or base station.
  58. The first mobile phone was presented by Dr. Martin Cooper of Motorola in 1973 whose weight was 2kg.
  59. GSM stands for Global System for Mobile.
  60. GSM communication is a leading cellular communication system.
  61. Bluetooth is a wireless technology for exchanging data between different devices over short distances.
  62. Bluetooth can connect several devices with each other wirelessly.
  63. Bluetooth Networks are formed temporarily from cellular phones, handhelds, computers,s, and laptops.
  64. Bluetooth offers services like file sharing, voice transport, and connection between devices like mouse, keyboard, etc.
  65. Satellite communication is a form of wireless communication in which satellites are the main objects.
  66. Satellites are known as communication satellites. These provide a telecommunication link between different places across the globe.
  67. Satellites enable us to communicate over long distances.
  68. Satellites communication is helpful for international phone calls, communication in remote areas, mobile vehicles, ships, and aircraft.
  69. Satellites orbit around the Earth.
  70. GPS stands for Global Positioning System.
  71. GPS is a global navigation satellite system. It gives information about the accurate location and time.
  72. GPS can be used to pinpoint any ship or submarine on the ocean or to measure the height of Mount Everest.
  73. A stolen vehicle can be detected via GPS.

Microsoft Word

  1. In the Print Layout view, Headers and Footers are visible.
  2. The process of removing the unwanted parts of an image is called cropping.
  3. To apply center alignment to a paragraph we can press Ctrl + E.
  4. The space left between the margin and the start of a paragraph is called indentation.
  5. The Text-styling feature of MS word is WordArt.
  6. Touch Screen recognizes touch input.
  7. Through the input device data and instructions are entered into a computer.
  8. Computer Monitor is also known as VDU.
  9. VDU stands for Visual Display Unit.
  10. Arrange in ascending order the units of memory TB>GB>MB>KB.
  11. Blue Ray Disk stores more data than a DVD.
  12. The output shown on the computer monitor is called soft copy.
  13. Eight bits make up a byte.
  14. Information is the result of output given y a computer.
  15. RAM is also known as read/write memory.
  16. The printed output from a computer is called hardcopy.
  17. Raised is not a character spacing.
  18. Expanded and condensed are character spacing.
  19. By using the Ctrl F command in Ms word, we can search character and word and symbols.
  20. Gutter margin is used to give provision for better document binding.
  21. Hyphenation options are available in the page layout tab.
  22. Narrow is a page margin.
  23. Ctrl H is a short key in MS Word to find and replace.
  24. Alt F9 is a shortcut key to display field codes.
  25. You can delete a text by selecting a text and pressing the delete button.
  26. When you insert a comment in a document, the comment appears in a balloon.
  27. When word flags a spell or grammar error, it also changes the mark on the spelling and grammar icon to Red X.
  28. Bold, italics and regular are font styles.
  29. Ctrl +Shift+ enter breaks the current column.
  30. You can disable extended selection mode by pressing escape to disable.
  31. Formatting toolbar allows changing of fonts and their sizes.
  32. To view headers and footers you must switch to print layout view and print preview mode.
  33. Page orientation can be changed at any time.
  34. Paste special helps you to insert the contents of the clipboard as text without any formatting.
  35. The print layout will depict how text and graphics appear on the printed page.
  36. Font or typeface defines the appearance and shape of letters, numbers, and special characters.
  37. Cut and paste will be performed to move a block of text.
  38. The ability to combine name and address with a standard document is called mail merge.
  39. Mail merge enables us to send the same letter to different persons.
  40. Word processor would more likely be used to type a biography.
  41. Gutter margin is added to the binding site of the page when printing.
  42. The toolbar can be used for quick access to commonly used commands and tools.
  43. The main document, data source, and merge field are essential components to perform a mail merge operation.
  44. When a language bar is hidden, it means you don’t see it on the screen but it’ll be displayed the next time you start your computer.
  45. Autocorrect was originally designed to replace misspelled words as you type.
  46. The home key is used to move the cursor to the beginning of the line.
  47. Ctrl + right arrow is used to move the cursor one word right.
  48. Ctrl +left arrow is used to move the cursor one word left.
  49. Page up key moves the cursor one screen up.
  50. Ctrl +down arrow moves the cursor one paragraph down.
  51. Ctrl + page down is used to move the cursor one page down.
  52. End key moves the cursor to the end of the line.
  53. WordPerfect, Wordpad, and MS Word are word processing softwares.
  54. Windword.exe file starts MS word.
  55. Word fields are inserted as a cross-reference in word.
  56. Ctrl F opens the Find and Replace dialogue box.

 

Word Shortcut Keys

  • Ctrl + A — Select all contents of the page.
  • Ctrl + B — Bold highlighted selection.
  • Ctrl + C — Copy selected text.
  • Ctrl + X — Cut selected text.
  • Ctrl + N — Open new/blank document.
  • Ctrl + O — Open options.
  • Ctrl + P — Open the print window.
  • Ctrl + F — Open find box.
  • Ctrl + I — Italicise highlighted selection.
  • Ctrl + K — Insert link.
  • Ctrl + U — Underline highlighted selection.
  • Ctrl + V — Paste.
  • Ctrl + Y — Redo the last action performed.
  • Ctrl + Z — Undo last action.
  • Ctrl + G — Find and replace options.
  • Ctrl + H — Find and replace options.
  • Ctrl + J — Justify paragraph alignment.
  • Ctrl + L — Align selected text or line to the left.
  • Ctrl + Q — Align selected paragraph to the left.
  • Ctrl + E — Align selected text or line to the center.
  • Ctrl + R — Align selected text or line to the right.
  • Ctrl + M — Indent the paragraph.
  • Ctrl + T — Hanging indent.
  • Ctrl + D — Font options.
  • Ctrl + Shift + F — Change the font.
  • Ctrl + Shift + > — Increase selected font +1.
  • Ctrl + ] — Increase selected font +1.
  • Ctrl + [ — Decrease selected font -1.
  • Ctrl + Shift + * — View or hide non printing characters.
  • Ctrl + (Left arrow) — Move one word to the left.
  • Ctrl + (Right arrow) — Move one word to the right.
  • Ctrl + (Up arrow) — Move to the beginning of the line or paragraph.
  • Ctrl + (Down arrow) — Move to the end of the paragraph.
  • Ctrl + Del — Delete word to the right of the cursor.
  • Ctrl + Backspace — Delete word to the left of the cursor.
  • Ctrl + End — Move cursor to end of the document.
  • Ctrl + Home — Move cursor to the beginning of the document.
  • Ctrl + Space — Reset highlighted text to default font.
  • Ctrl + 1 — Single-space lines.
  • Ctrl + 2 — Double-space lines.
  • Ctrl + 5 — 1.5-line spacing.
  • Ctrl + Alt + 1 Change text to heading 1.
  • Ctrl + Alt + 2 Change text to heading 2.
  • Ctrl + Alt + 3 Change text to heading 3.
  • F1 — Open Help.
  • Shift + F3 — Change case of selected text.
  • Shift + Insert — Paste.
  • F4 — Repeat the last action performed (Word 2000+).
  • F7 — Spell check selected text and/or document.
  • Shift + F7 — Activate the thesaurus.
  • F12 — Save as.
  • Ctrl + S — Save.
  • Shift + F12 — Save.
  • Alt + Shift + D — Insert the current date.
  • Alt + Shift + T — Insert the current time.
  • Ctrl + W — Close document.

 

Excel Shortcut Keys

  • F2 — Edit the selected cell.
  • F5 — Go to a specific cell.
  • F7 — Spell check selected text and/or document.
  • F11 — Create a chart
  • Ctrl + Shift + ; — Enter the current time.
  • Ctrl + ; — Enter the current date
  • Alt + Shift + F1 — Insert new worksheet.
  • Shift + F3 — Open the Excel formula window.
  • Shift + F5 — Bring up the search box
  • Ctrl + A — Select all contents of a worksheet.
  • Ctrl + B — Bold highlighted selection.
  • Ctrl + I — Italicize highlighted selection.
  • Ctrl + C — Copy selected text.
  • Ctrl + V — Paste
  • Ctrl + D — Fill
  • Ctrl + K — Insert link
  • Ctrl + F — Open find and replace options.
  • Ctrl + G — Open go-to options.
  • Ctrl + H — Open find and replace options.
  • Ctrl + U — Underline highlighted selection.
  • Ctrl + Y — Underline selected text.
  • Ctrl + 5 — Strikethrough highlighted selection.
  • Ctrl + O — Open options.
  • Ctrl + N — Open new document.
  • Ctrl + P — Open print dialog box.
  • Ctrl + S — Save.
  • Ctrl + Z — Undo last action.
  • Ctrl + F9 — Minimize current window.
  • Ctrl + F10 — Maximize currently selected window.
  • Ctrl + F6 — Switch between open workbooks/windows.
  • Ctrl + Page up & Page Down — Move between Excel worksheets in the same document.
  • Ctrl + Tab — Move between Two or more open Excel files
  • Alt + = — Create the formula to sum all of the above cells.
  • Ctrl + — Insert the value of the above cell into the current cell.
  • Ctrl + Shift + ! — Format number in comma format.
  • Ctrl + Shift + $ — Format number in currency format.
  • Ctrl + Shift + # — Format number in date format.
  • Ctrl + Shift + % — Format number in percentage format.
  • Ctrl + Shift + ^ — Format number in scientific format.
  • Ctrl + Shift + @ — Format number in time format.
  • Ctrl + (Right arrow) — Move to next section of text.
  • Ctrl + Space — Select entire column.
  • Shift + Space — Select entire row.
  • Ctrl + W — Close document.

 

Outlook shortcut keys

  • Alt + S — Send the email.
  • Ctrl + C — Copy selected text.
  • Ctrl + X — Cut selected text.
  • Ctrl + P — Open print dialog box.
  • Ctrl + K — Complete name/email typed in address bar.
  • Ctrl + B — Bold highlighted selection.
  • Ctrl + I — Italicize highlighted selection.
  • Ctrl + U — Underline highlighted selection.
  • Ctrl + R — Reply to an email.
  • Ctrl + F — Forward an email.
  • Ctrl + N — Create a new email.
  • Ctrl + Shift + A — Create a new appointment to your calendar.
  • Ctrl + Shift + O — Open the outbox.
  • Ctrl + Shift + I — Open the inbox.
  • Ctrl + Shift + K — Add a new task.
  • Ctrl + Shift + C — Create a new contact.
  • Ctrl + Shift+ J — Create a new journal entry.

Bits, bytes, and other units

  • A bit is a binary digit, the smallest increment of data on a computer.
  • A bit can hold only one of two values: 0 or 1, corresponding to the electrical values of off or on, respectively.
  • Bits are usually assembled into a group of eight to form a byte (1 byte=8bits).
  • A byte contains enough information to store a single ASCII character, like “h”.
  • A kilobyte (KB) is not equal to one thousand bytes as might be expected, because computers use binary (base two) math, instead of a decimal (base ten) system.
  • Computer storage and memory are measured in megabytes (MB) and gigabytes (GB).
  • A medium-sized novel contains about 1 MB of information.
  • A kilobyte (KB) is 1,024 bytes.
  • 1 MB is 1,024 kilobytes, or 1,048,576 (1024×1024) bytes.
  • 1 GB is 1,024 MB.
  • 1 GB is equal to 1,073,741,824 (1024x1024x1024) bytes.
  • A terabyte (TB) is 1,024 GB.
  • 1 petabyte (PB) is 1,024 TB.
  • An exabyte (EB) is 1,024 PB.
  • A zettabyte (ZB) is 1,024 EB.
  • 1 yottabyte (YB) is 1,024 ZB.
  • The abbreviations for numbers of bits use a lower-case “b”.
  • If a broadband Internet connection is advertised with a download speed of 3.0 Mbps, its speed is 3.0 megabits per second.

About Noshin Bashir

Check Also

Galaxy-S20-Samsung

CE 2021: Current Affairs And Pakistan Affairs Solved MCQs (General Knowledge II and III)

Article 6 of the Pakistan Constitution deals with high treason. Explanation: Article 6 states: “Any …

Leave a Reply

Your email address will not be published. Required fields are marked *