IFSM 201 – Quiz 2
Question 1 (0.25 points)
Chat 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 (computerbased) 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 predefined 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
IFSM 201 – Quiz 2
Question 1 (0.25 points)
Chat 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 (computerbased) 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 predefined 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
IFSM 201 – Quiz 2
Question 1 (0.25 points)
Chat 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 (computerbased) 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 predefined 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
IFSM 201 – Quiz 2
IFSM 201 – Quiz 2IFSM 201 – Quiz 2IFSM 201 – Quiz 2
Question 1 (0.25 points)
Question 1 (0.25 points)Question 1 Question 1 (0.25 points)
Chat messages are an example of:
Chat messages are an example of:
Question 1 options:
Question 1 options:
Information shared by individuals 

Information shared by organizations 

Information shared by firmware/software. 
Information shared by individuals
Information shared by organizations
Information shared by firmware/software.
Information shared by individuals
Information shared by individuals
Information shared by individuals
Information shared by individuals
Information shared by organizations
Information shared by organizations
Information shared by organizations
Information shared by organizations
Information shared by firmware/software.
Information shared by firmware/software.
Information shared by firmware/software.
Information shared by firmware/software.
Save
Save
Question 2 (0.25 points)
Question 2 (0.25 points)Question 2 Question 2 (0.25 points)
Which of the following was one reason why electronic (computerbased) information sharing was challenging in the not too distant past?
Which of the following was one reason why electronic (computerbased) information sharing was challenging in the not too distant past?
Question 2 options:
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. 
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.
Individuals and/or members of organizations did not speak the same language.
Individuals and/or members of organizations did not speak the same language.
Individuals and/or members of organizations did not speak the same language.
Individuals and/or members of organizations did not speak the same language.
The most powerful computers were owned by large companies.
The most powerful computers were owned by large companies.
The most powerful computers were owned by large companies.
The most powerful computers were owned by large companies.
It was considered too risky to share information electronically.
It was considered too risky to share information electronically.
It was considered too risky to share information electronically.
It was considered too risky to share information electronically.
An internet connection was not widely available.
An internet connection was not widely available.
An internet connection was not widely available.
An internet connection was not widely available.
Save
Save
Question 3 (0.25 points)
Question 3 (0.25 points)Question 3 Question 3 (0.25 points)
(True/False). A higher bandwidth always enables data to be transmitted more quickly than a lower bandwidth.
(True/False). A higher bandwidth always enables data to be transmitted more quickly than a lower bandwidth.
Question 3 options:
Question 3 options:
True 

False 
True
False
True
True
True
True
False
False
False
False
Save
Save
Question 4 (0.25 points)
Question 4 (0.25 points)Question 4 Question 4 (0.25 points)
Data sent and received over the internet is in the form of:
Data sent and received over the internet is in the form of:
Question 4 options:
Question 4 options:
words consisting of data 

packages consisting of characters 

data packets 

characters 
words consisting of data
packages consisting of characters
data packets
characters
words consisting of data
words consisting of data
words consisting of data
words consisting of data
packages consisting of characters
packages consisting of characters
packages consisting of characters
packages consisting of characters
data packets
data packets
data packets
data packets
characters
characters
characters
characters
Save
Save
Question 5 (0.25 points)
Question 5 (0.25 points)Question 5 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?
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:
Question 5 options:
fiber optic cables 

modem 

router 
fiber optic cables
modem
router
fiber optic cables
fiber optic cables
fiber optic cables
fiber optic cables
modem
modem
modem
modem
router
router
router
router
Save
Save
Question 6 (0.25 points)
Question 6 (0.25 points)Question 6 Question 6 (0.25 points)
In this picture, which item would appear to be a wireless router?
In this picture, which item would appear to be a wireless router?
a.
a.
b.
b.
Question 6 options:
Question 6 options:
Picture 1 

Picture 2 
Picture 1
Picture 2
Picture 1
Picture 1
Picture 1
Picture 1
Picture 2
Picture 2
Picture 2
Picture 2
Save
Save
Question 7 (0.25 points)
Question 7 (0.25 points)Question 7 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:
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:
Question 7 options:
a modem. 

a router. 

a fax machine. 

a mouse. 
a modem.
a router.
a fax machine.
a mouse.
a modem.
a modem.
a modem.
a modem.
a router.
a router.
a router.
a router.
a fax machine.
a fax machine.
a fax machine.
a fax machine.
a mouse.
a mouse.
a mouse.
a mouse.
Save
Save
Question 8 (0.25 points)
Question 8 (0.25 points)Question 8 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:
If you are connecting only one computer to the network from a single location in your home, the component needed is:
Question 8 options:
Question 8 options:
a modem. 

a router. 

a fax machine. 

a mouse. 
a modem.
a router.
a fax machine.
a mouse.
a modem.
a modem.
a modem.
a modem.
a router.
a router.
a router.
a router.
a fax machine.
a fax machine.
a fax machine.
a fax machine.
a mouse.
a mouse.
a mouse.
a mouse.
Save
Save
Question 9 (0.25 points)
Question 9 (0.25 points)Question 9 Question 9 (0.25 points)
What are at least four essential components of a computer network?
What are at least four essential components of a computer network?
Question 9 options:
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 
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
At least one computer, hardware and software, the path for the information to follow, firewall.
At least one computer, hardware and software, the path for the information to follow, firewall.
At least one computer, hardware and software, the path for the information to follow, firewall.
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).
Local Area Network (LAN), Wide Area Network (WAN), cloud computing, Global Area Network (GAN).
Local Area Network (LAN), Wide Area Network (WAN), cloud computing, Global Area Network (GAN).
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.
Emails and social media shared by individuals, funds transfers and security documents shared by organizations.
Emails and social media shared by individuals, funds transfers and security documents shared by organizations.
Emails and social media shared by individuals, funds transfers and security documents shared by organizations.
Computers, firewall, cloud computing, information sharing
Computers, firewall, cloud computing, information sharing
Computers, firewall, cloud computing, information sharing
Computers, firewall, cloud computing, information sharing
Save
Save
Question 10 (0.25 points)
Question 10 (0.25 points)Question 10 Question 10 (0.25 points)
When discussing home networks, a server or a host is:
When discussing home networks, a server or a host is:server or a hos
Question 10 options:
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 
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
the modem.
the modem.
the modem.
the modem.
the router
the router
the router
the router
One device that is physically connected to the router and through the router to the internet
One device that is physically connected to the router and through the router to the internet
One device that is physically connected to the router and through the router to the internet
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
Another computer in the home that needs to be connected
Another computer in the home that needs to be connected
Another computer in the home that needs to be connected
Save
Save
Question 11 (0.25 points)
Question 11 (0.25 points)Question 11 Question 11 (0.25 points)
This diagram represents a
This diagram represents a
Question 11 options:
Question 11 options:
LAN. 

WAN. 

GAN 
LAN.
WAN.
GAN
LAN.
LAN.
LAN.
LAN.
WAN.
WAN.
WAN.
WAN.
GAN
GAN
GAN
GAN
Save
Save
Question 12 (0.25 points)
Question 12 (0.25 points)Question 12 Question 12 (0.25 points)
The Internet of Things (IoT) consists of:
The Internet of Things (IoT) consists of:
Question 12 options:
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 
various things in your hous.e
various networks.
objects that recognize and connect to other devices via the internet.
none of the above
various things in your hous.e
various things in your hous.e
various things in your hous.e
various things in your hous.e
various networks.
various networks.
various networks.
various networks.
objects that recognize and connect to other devices via the internet.
objects that recognize and connect to other devices via the internet.
objects that recognize and connect to other devices via the internet.
objects that recognize and connect to other devices via the internet.
none of the above
none of the above
none of the above
none of the above
Save
Save
Question 13 (0.25 points)
Question 13 (0.25 points)Question 13 Question 13 (0.25 points)
(True or False). The Internet of Things means all the data that is contained on the internet.
(True or False). The Internet of Things means all the data that is contained on the internet.
Question 13 options:
Question 13 options:
True 

False 
True
False
True
True
True
True
False
False
False
False
Save
Save
Question 14 (0.25 points)
Question 14 (0.25 points)Question 14 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?
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:
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. 
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.
Addition and subtraction, whichever comes first, multiplication and division, whichever comes first, exponential calculations (3^2, for example), operations enclosed in parentheses.
Addition and subtraction, whichever comes first, multiplication and division, whichever comes first, exponential calculations (3^2, for example), operations enclosed in parentheses.
Addition and subtraction, whichever comes first, multiplication and division, whichever comes first, exponential calculations (3^2, for example), operations enclosed in parentheses.
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).
Multiplication and division, whichever comes first, addition and subtraction, whichever comes first, operations enclosed in parentheses, exponential calculations (3^2, for example).
Multiplication and division, whichever comes first, addition and subtraction, whichever comes first, operations enclosed in parentheses, exponential calculations (3^2, for example).
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.
Operations enclosed in parentheses, exponential calculations (3^2, for example), multiplication and division, whichever comes first, addition and subtraction, whichever comes first.
Operations enclosed in parentheses, exponential calculations (3^2, for example), multiplication and division, whichever comes first, addition and subtraction, whichever comes first.
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.
Exponential calculations (3^2,for example), operations enclosed in parentheses, for example, Addition and subtraction, whichever comes first, multiplication and division, 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.
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
Save
Question 15 (0.25 points)
Question 15 (0.25 points)Question 15 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:
When you create a simple formula using data in just 2 cells in Excel and you use cell addresses, you are entering:cell addresses,
Question 15 options:
Question 15 options:
cell references in the formula. 

Numerical values in the formula 
cell references in the formula.
Numerical values in the formula
cell references in the formula.
cell references in the formula.
cell references in the formula.
cell references in the formula.
Numerical values in the formula
Numerical values in the formula
Numerical values in the formula
Numerical values in the formula
Save
Save
Question 16 (0.25 points)
Question 16 (0.25 points)Question 16 Question 16 (0.25 points)
If the formula =(X7 + X8) is copied from cell (A1) to a (A5) 4 rows lower, what happens?
If the formula =(X7 + X8) is copied from cell (A1) to a (A5) 4 rows lower, what happens?
Question 16 options:
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 
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
The formula remains (X7 + X8)
The formula remains (X7 + X8)
The formula remains (X7 + X8)
The formula remains (X7 + X8)
The formula in (A5) becomes A11 + A12
The formula in (A5) becomes A11 + A12
The formula in (A5) becomes A11 + A12
The formula in (A5) becomes A11 + A12
The formula in (A5) becomes X11 + X12
The formula in (A5) becomes X11 + X12
The formula in (A5) becomes X11 + X12
The formula in (A5) becomes X11 + X12
the formula in (A5) becomes X11 + X8
the formula in (A5) becomes X11 + X8
the formula in (A5) becomes X11 + X8
the formula in (A5) becomes X11 + X8
Save
Save
Question 17 (0.25 points)
Question 17 (0.25 points)Question 17 Question 17 (0.25 points)
If your formula changes when you copy it to a new cell, your formula uses:
If your formula changes when you copy it to a new cell, your formula uses:
Question 17 options:
Question 17 options:
absolute cell references 

relative cell references. 
absolute cell references
relative cell references.
absolute cell references
absolute cell references
absolute cell references
absolute cell references
relative cell references.
relative cell references.
relative cell references.
relative cell references.
Save
Save
Question 18 (0.25 points)
Question 18 (0.25 points)Question 18 Question 18 (0.25 points)
Which of the following would not be considered an example of a predefined function?
Which of the following would not be considered an example of a predefined function?Which of the following would notnot be considered an example of a predefined function?
Question 18 options:
Question 18 options:
MIN(A1:A8) 

(A1 + A2) 

SUM (A1 + A2) 

COUNTA (A1:A8) 
MIN(A1:A8)
(A1 + A2)
SUM (A1 + A2)
COUNTA (A1:A8)
MIN(A1:A8)
MIN(A1:A8)
MIN(A1:A8)
MIN(A1:A8)
(A1 + A2)
(A1 + A2)
(A1 + A2)
(A1 + A2)
SUM (A1 + A2)
SUM (A1 + A2)
SUM (A1 + A2)
SUM (A1 + A2)
COUNTA (A1:A8)
COUNTA (A1:A8)
COUNTA (A1:A8)
COUNTA (A1:A8)
Save
Save
Question 19 (0.25 points)
Question 19 (0.25 points)Question 19 Question 19 (0.25 points)
________ allows you to reorganize the data in a worksheet.
________ allows you to reorganize the data in a worksheet.
Question 19 options:
Question 19 options:
Filtering 

Sorting 

Summarizing 
Filtering
Sorting
Summarizing
Filtering
Filtering
Filtering
Filtering
Sorting
Sorting
Sorting
Sorting
Summarizing
Summarizing
Summarizing
Summarizing
Save
Save
Question 20 (0.25 points)
Question 20 (0.25 points)Question 20 Question 20 (0.25 points)
________ allows you to narrow down the data in your worksheet, allowing you to view only the information you need.
________ allows you to narrow down the data in your worksheet, allowing you to view only the information you need.arrow down
Question 20 options:
Question 20 options:
Filtering 

Sorting 

Find and Select 
Filtering
Sorting
Find and Select
Filtering
Filtering
Filtering
Filtering
Sorting
Sorting
Sorting
Sorting
Find and Select
Find and Select
Find and Select
Find and Select
Save
Save