University of Maryland IFSM 201 Quiz 2
IFSM 201 - Quiz 2
(Yellow highlights are correct answers)
Question 1 (0.25 points)
Chat
... [Show More] messages are an example of:
Question 1 options:
Information shared by individuals
Information shared by organizations
Information shared by firmware/software.
Save
Question 2 (0.25 points)
Which of the following was one reason why electronic (computer-based) information sharing was challenging in the not too distant past?
Question 2 options:
Individuals and/or members of organizations did not speak the same language.
The most powerful computers were owned by large companies.
It was considered too risky to share information electronically.
An internet connection was not widely available.
Save
Question 3 (0.25 points)
(True/False). A higher bandwidth always enables data to be transmitted more quickly than a lower bandwidth.
Question 3 options:
True
False
Save
Question 4 (0.25 points)
Data sent and received over the internet is in the form of:
Question 4 options:
words consisting of data
packages consisting of characters
data packets
characters
Save
Question 5 (0.25 points)
In networking, bandwidth is the volume of computer data carried via a conductor in a period of time. Which one of these could be a conductor of computer data into your home network?
Question 5 options:
fiber optic cables
modem
router
Save
Question 6 (0.25 points)
In this picture, which item would appear to be a wireless router?
a.
b.
Question 6 options:
Picture 1
Picture 2
Save
Question 7 (0.25 points)
In a home network, the component needed to connect multiple computers or other electronic devices to the Internet at the same time is called:
Question 7 options:
a modem.
a router.
a fax machine.
a mouse.
Save
Question 8 (0.25 points)
If you are connecting only one computer to the network from a single location in your home, the component needed is:
Question 8 options:
a modem.
a router.
a fax machine.
a mouse.
Save
Question 9 (0.25 points)
What are at least four essential components of a computer network?
Question 9 options:
At least one computer, hardware and software, the path for the information to follow, firewall.
Local Area Network (LAN), Wide Area Network (WAN), cloud computing, Global Area Network (GAN).
Emails and social media shared by individuals, funds transfers and security documents shared by organizations.
Computers, firewall, cloud computing, information sharing
Save
Question 10 (0.25 points)
When discussing home networks, a server or a host is:
Question 10 options:
the modem.
the router
One device that is physically connected to the router and through the router to the internet
Another computer in the home that needs to be connected
Save
Question 11 (0.25 points)
This diagram represents a
Question 11 options:
LAN.
WAN.
GAN
Save
Question 12 (0.25 points)
The Internet of Things (IoT) consists of:
Question 12 options:
various things in your hous.e
various networks.
objects that recognize and connect to other devices via the internet.
none of the above
Save
Question 13 (0.25 points)
(True or False). The Internet of Things means all the data that is contained on the internet.
Question 13 options:
True
False
Save
Question 14 (0.25 points)
In a complex formula containing multiple mathematical operators, there is an order of operations that is followed to ensure that the result has been calculated correctly. Which of the following is correct?
Question 14 options:
Addition and subtraction, whichever comes first, multiplication and division, whichever comes first, exponential calculations (3^2, for example), operations enclosed in parentheses.
Multiplication and division, whichever comes first, addition and subtraction, whichever comes first, operations enclosed in parentheses, exponential calculations (3^2, for example).
Operations enclosed in parentheses, exponential calculations (3^2, for example), multiplication and division, whichever comes first, addition and subtraction, whichever comes first.
Exponential calculations (3^2,for example), operations enclosed in parentheses, for example, Addition and subtraction, whichever comes first, multiplication and division, whichever comes first.
Save
Question 15 (0.25 points)
When you create a simple formula using data in just 2 cells in Excel and you use cell addresses, you are entering:
Question 15 options:
cell references in the formula.
Numerical values in the formula
Save
Question 16 (0.25 points)
If the formula =(X7 + X8) is copied from cell (A1) to a (A5)- 4 rows lower, what happens?
Question 16 options:
The formula remains (X7 + X8)
The formula in (A5) becomes A11 + A12
The formula in (A5) becomes X11 + X12
the formula in (A5) becomes X11 + X8
Save
Question 17 (0.25 points)
If your formula changes when you copy it to a new cell, your formula uses:
Question 17 options:
absolute cell references
relative cell references.
Save
Question 18 (0.25 points)
Which of the following would not be considered an example of a pre-defined function?
Question 18 options:
MIN(A1:A8)
(A1 + A2)
SUM (A1 + A2)
COUNTA (A1:A8)
Save
Question 19 (0.25 points)
________ allows you to reorganize the data in a worksheet.
Question 19 options:
Filtering
Sorting
Summarizing
Save
Question 20 (0.25 points)
________ allows you to narrow down the data in your worksheet, allowing you to view only the information you need.
Question 20 options:
Filtering
Sorting
Find and Select
Save [Show Less]