Question 1
(True/False) Information can only be shared electronically.
True
False
Question 2
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.
Question 3
(True/False) A higher bandwidth enables a larger volume of data (in bits per second) to be transmitted than a lower bandwidth.
True
False
Question 4
Data sent and received over the internet is in the form of:
words
packages
data packets
characters
Question 5
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?
fiber optic cables
modem
router
Question 6
If your home network has more than one computer that needs to access the internet, the component needed to support this is the:
modem.
router.
fax machine
mouse.
Question 7
(True/False) A home network's purpose is to allow access to the internet only by computers on the network.
True
False
Question 8
In this picture, which item would appear to be a wireless router?
a.
b.
Picture 1
Picture 2
Question 9
What are at least four essential components of a home computer network?
Computers, firewall, cloud computing, security app.
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
At least one computer, hardware and software, the path for the information to follow, firewall.
Question 10
When discussing home networks, a server or a host is:
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
Question 11
This diagram represents a
LAN.
WAN.
GAN
Question 12
The Internet of Things consists of:
a computer network.
various networks.
Objects that recognize and connect to other devices via the internet
none of the above.
Question 13
(True or False). The Internet of Things means all the data that is contained on the internet.
True
False
Question 14
In a worksheet that contains multiple formulas, how can you view all the formulas used at the same time?
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
Question 15
If the correct answer to this calculation should be 25 , which formula is constructed correctly?
8 + 12 + 10 * 0.5
(8 + 12 + 10) * 0.5
Question 16
If the formula =(X7 + X8) is copied from cell (A1) to a (A5)- 4 rows lower, what happens?
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
Question 17
To keep a row or column cell reference constant in a formula, you would use:
absolute cell references.
relative cell references.
Question 18
Which of the following would not be considered an example of a pre-defined function?
MIN(A1:A8)
(A1 + A2)
SUM (A1 + A2)
COUNTA (A1:A8)
Question 19
________ allows you to narrow down the data in your worksheet, allowing you to view only the information you need.
Filtering
Sorting
Find and Select
Question 20
Before you use the subtotal command, your data must be:
filtered.
sorted.
summarized