IFSM 201 Quiz Week 2
science prodigy
Quiz2.pdf
8/28/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System
https://learn.umuc.edu/d2l/le/content/416120/viewContent/16229802/View 1/6
Question 1 (0.25 points)
Question 2 (0.25 points)
Question 3 (0.25 points)
Question 4 (0.25 points)
Saved
Saved
Saved
Saved
(True/False) Information can only be shared electronically.
True
False
Which of the following was one reason why electronic (computer-based) information sharing was challenging in the not too distant past?
True/False). Utilizing higher bandwidth always results in data being transmitted more quickly than utilizing lower bandwidth.
True
False
Data sent and received over the internet is in the form of:
Individuals and/or members of organizations did not speak the same language.
Hardware and software applications on either end could not talk to one another.
The most powerful computers were owned by large companies.
Organizations needed to protect information for competitive advantage.
words consisting of data
packages consisting of characters
data packets
characters
8/28/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System
https://learn.umuc.edu/d2l/le/content/416120/viewContent/16229802/View 2/6
Question 5 (0.25 points)
Question 6 (0.25 points)
Question 7 (0.25 points)
Question 8 (0.25 points)
Saved
Saved
Saved
Saved
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?
If you are connecting only one device (computer or laptop or tablet or other internet enabled device) to the network from a single location in your home and do not need wifi, the component needed is:
(True/False) A home network’s purpose is to allow access to the internet only by computers on the network.
True
False
In a home network, the component needed to connect multiple computers or other electronic devices to the Internet at the same time is called:
fiber optic cables
modem
router
a modem.
a router.
a fax machine.
a mouse.
8/28/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System
https://learn.umuc.edu/d2l/le/content/416120/viewContent/16229802/View 3/6
Question 9 (0.25 points)
Question 10 (0.25 points)
Question 11 (0.25 points)
Saved
Saved
Saved
What are at least four essential components of a computer network?
(True/False). A wireless home network (one that does NOT employ a wi-fi hot spot) has no need for cables anywhere in the network configuration.
True
False
Alternate text: Globe in the center surrounded by laptops connected via the globe.
This diagram represents a
a modem.
a router.
a fax machine.
a mouse.
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
8/28/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System
https://learn.umuc.edu/d2l/le/content/416120/viewContent/16229802/View 4/6
Question 12 (0.25 points)
Question 13 (0.25 points)
Question 14 (0.25 points)
Question 15 (0.25 points)
Saved
Saved
Saved
Saved
The Internet of Things consists of:
(True or False). The Internet of Things means web pages with descriptions of devices that can connect through the Internet.
True
False
In a worksheet that contains multiple formulas, how can you view all the formulas used at the same time?
LAN.
WAN.
GAN
a computer network.
various networks.
Objects that recognize and connect to other devices via the internet
none of the above.
Highlight all the cells in the worksheet and select View from the Ribbon.
Hold the Ctrl key and press ` (grave accent)
Move your cursor to each cell that contains a formula. The formula will appear in the formula bar above the worksheet
8/28/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System
https://learn.umuc.edu/d2l/le/content/416120/viewContent/16229802/View 5/6
Question 16 (0.25 points)
Question 17 (0.25 points)
Question 18 (0.25 points)
Saved
Saved
Saved
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?
If your formula changes when you copy it to a new cell, your formula uses:
If the formula =(X7 + X8) is copied from cell (A1) to a (A5)- 4 rows lower, what happens?
A(n) ______ is a predefined formula that performs calculations using specific values in a particular order.
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.
absolute cell references
relative cell references.
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
8/28/2019 Quiz - IFSM 201 6364 Concepts and Applications of Information Technology (2198) - UMUC Learning Management System
https://learn.umuc.edu/d2l/le/content/416120/viewContent/16229802/View 6/6
Question 19 (0.25 points)
Question 20 (0.25 points)
Saved
Saved
________ allows you to narrow down the data in your worksheet, allowing you to view only the information you need.
3. Before you use the subtotal command, your data must be:
Submit Quiz 20 of 20 questions saved
relative cell reference
absolute cell reference
function
equation
Filtering
Sorting
Find and Select
filtered.
sorted.
summarized
