Correct answer: SSD. An SSD (solid-state drive) has no moving parts.
Background: SSDs are faster and quieter than hard disks.
Did you know? They store data in flash memory chips.
Memory trick: SSD = solid state = no moving parts.
Correct answer: Tim Berners-Lee. Tim Berners-Lee invented the World Wide Web in 1989–91.
Background: He worked at CERN in Switzerland.
Did you know? The Web is not the same as the internet, which is the network it runs on.
Memory trick: WWW = Berners-Lee.
Correct answer: Ada Lovelace. Ada Lovelace wrote the first algorithm for Babbage’s Analytical Engine in the 1840s.
Background: She was the daughter of the poet Lord Byron.
Did you know? The programming language Ada is named after her.
Memory trick: Ada = first programmer.
Correct answer: Switch. A switch connects multiple computers in a network and forwards data to the right device.
Background: Switches are used in local area networks.
Did you know? A hub is a simpler device that sends data to all ports.
Memory trick: Switch = connects many computers.
Correct answer: On Slide Sorter, click on slide and drag to the required position. In Slide Sorter view, you click a slide and drag it to the position you want.
Background: Slide Sorter view shows all slides as thumbnails.
Did you know? You can also drag slides in the thumbnail pane of Normal view.
Memory trick: Sorter = drag to reorder.
Correct answer: Metadata. Metadata is data about data, such as a file’s author and creation date.
Background: The prefix “meta” means “about”.
Did you know? A photo’s metadata can include the time and place it was taken.
Memory trick: Meta = about.
Correct answer: Insert. In MS Excel, charts are added from the Insert tab (Charts group).
Background: You select the data first and then choose a chart type.
Did you know? Common chart types are column, line, and pie.
Memory trick: Insert = add chart.
Correct answer: Home (Paragraph group). Bullets and numbering are found in the Paragraph group of the Home tab.
Background: The Paragraph group also has alignment and spacing tools.
Did you know? You can also right-click and choose Bullets or Numbering.
Memory trick: Home → Paragraph → bullets.
Correct answer: Electronic mail. E-mail stands for electronic mail.
Background: E-mail is a way of sending messages over a network.
Did you know? The first networked e-mail was sent in 1971.
Memory trick: E = Electronic.
Correct answer: 1969. ARPANET, the ancestor of the internet, began operating in 1969.
Background: The modern internet based on TCP/IP began in 1983.
Did you know? The first ARPANET message was sent in October 1969.
Memory trick: ARPANET = 1969.
Correct answer: Round. The ROUND function rounds a number to a specified number of digits.
Background: The syntax is =ROUND(number, num_digits).
Did you know? ROUNDUP and ROUNDDOWN force rounding in one direction.
Memory trick: ROUND rounds; TRUNC chops.
Correct answer: To hide the IP address and provide security. A proxy server acts as an intermediary between users and the internet, hiding the user’s IP address and adding security.
Background: Proxy servers can also filter content and store (cache) pages.
Did you know? A VPN works in a similar way by hiding your address.
Memory trick: Proxy = middleman that hides your IP.
Correct answer: Transition. The “On Mouse Click” option is in the Transitions tab, under Advance Slide.
Background: In the same group you can also set a time delay to advance slides automatically.
Did you know? The Transitions tab controls effects between slides.
Memory trick: Mouse click = Transitions tab.
Correct answer: POP3. POP3 (Post Office Protocol version 3) is designed specifically to retrieve and download emails from a mail server to a local client device.
Background: IMAP accesses and synchronizes mail directly on the server, while SMTP is used for sending outgoing emails.
Did you know? POP3 downloads emails and usually deletes them from the server unless configured otherwise.
Memory trick: POP3 = Post Office Download.
Correct answer: Auto Fit. AutoFit Column Width adjusts the column to fit the longest entry.
Background: You can also double-click the right edge of a column header to AutoFit.
Did you know? AutoFit Row Height does the same for rows.
Memory trick: AutoFit = fits the content.
Correct answer: To send and receive messages. E-mail is mainly used to send and receive messages electronically.
Background: E-mail is one of the oldest internet services.
Did you know? Ray Tomlinson sent the first networked e-mail in 1971.
Memory trick: E-mail = electronic mail.
Correct answer: Preventing unauthorized access. A firewall monitors and filters network traffic to block unauthorized access.
Background: Firewalls can be hardware, software, or both.
Did you know? The word comes from the walls built in buildings to stop fire from spreading.
Memory trick: Firewall = security guard of the network.
Correct answer: Title Slide. A new PowerPoint presentation starts with the Title Slide layout for the first slide.
Background: A layout decides where the text and objects are placed on a slide.
Did you know? You can change a layout from the Home tab’s Layout button.
Memory trick: First slide → Title Slide.
Correct answer: Show/Hide feature. The Show/Hide (¶) button displays formatting marks such as spaces, tabs, and paragraph marks.
Background: It is in the Paragraph group of the Home tab.
Did you know? The shortcut in Word is Ctrl + Shift + 8.
Memory trick: ¶ button = show hidden marks.
Correct answer: abc@website.com. A valid e-mail address has one @ symbol, followed by a domain with a dot and an extension.
Background: An e-mail address has the form username@domain, where the @ sign separates the user’s name from the mail server’s domain.
Did you know? Ray Tomlinson sent the first networked e-mail in 1971 and chose the @ sign for addresses.
Memory trick: One @, then a domain with a dot and an extension.
Correct answer: Uniform Resource Locator. URL stands for Uniform Resource Locator, the address of a web resource.
Background: A URL is the address of a web page. It has parts such as the protocol (https), domain (docmcqs.com), and path.
Did you know? Tim Berners-Lee invented the World Wide Web around 1989–91.
Memory trick: URL = Uniform Resource Locator: the Locator tells you where.
Correct answer: Max ( ). MAX() returns the largest value in a range.
Background: MAX() looks at a range of numbers and returns the largest. Similar functions are MIN(), SUM(), AVERAGE(), and COUNT().
Did you know? Example: =MAX(A1:A10) returns the highest value in cells A1 to A10 and ignores text.
Memory trick: MAX = maximum = the biggest.
Correct answer: Insert. A table is created from the Insert tab (Tables group).
Background: The Insert tab holds commands for adding things to a document: Pages, Tables, Illustrations, Links, Header & Footer, and Text.
Did you know? After you insert a table, extra Table Tools tabs appear for design and layout.
Memory trick: Insert = add new objects (table, picture, chart).
Correct answer: Home tab. The Home tab’s Font group has the font style, size, and color options.
Background: The Home tab has the Clipboard, Font, Paragraph, Styles, and Editing groups.
Did you know? Font shortcuts are Ctrl+B (bold), Ctrl+I (italic), and Ctrl+U (underline).
Memory trick: Home = Font + Paragraph (the look of your text).
Correct answer: A device or network interface on an IP network. An IP address uniquely identifies a device or network interface for communication.