Question 1: How often should a business back up its data?
Hourly
Daily
Weekly
As often as needed to alleviate unacceptable risk
Question 2: Which of the following is a detailed process for recovering information or a system in the event of a catastrophic disaster?
Infrastructure Plan
Fault Tolerance Plan
Disaster Recovery Plan
Business Continuity Plan
Question 3: Which of the following details how a company recovers and restores critical business operations and systems after a disaster or extended disruption?
Infrastructure Plan
Disaster Recovery Plan
Business Continuity Plan
Fault Tolerance Plan
Question 4: Which of the following is NOT one of the characteristics of an Agile MIS Infrastructure?
Probability
Usability
Accessibility
Portability
Question 5: Which of the following is NOT a benefit of Cloud Computing?
Increased Dependence on an Internet Connection
Decreased Maintenance Issues
Increased Software Updates
Increased Storage Capacity
Question 6: Which of the following is NOT a trait that contributes to the value of information?
Governance
Software
Quality
Timeliness
Question 7: A collection of related information that is organized for easy storage, manipulation, and retrieval is
a DBMS
a database
metadata
SQL
Question 8: The software that allows creating, reading, updating, and deleting data in a database while controlling access and security is
a DBMS
metadata
a database
SQL
Question 9: Which of the following is NOT an advantage of relational databases over spreadsheets or text documents?
Increased redundancy
Increased flexibility
Increased scalability
Increased security
Question 10: When designing a database, what process helps to ensure the database won't include built-in anomalies?
Data mining
Normalization
ETL
Standardization
Question 11: Which of the following is an advantage of data-driven websites?
Web browsers are easier to use than database querying tools
Web pages can store more data than databases
Web pages ensure referential integrity
Customers usually know how to write their own SQL queries
Question 12: A collection of information gathered from many different operational databases, that supports business analysis and decision making is
An Entity-Relationship Diagram
An impossible dream
A data-oriented design scheme
A data warehouse
Question 13: The process that gets information from databases, makes it conform to a set of common definitions, and puts it into a data warehouse is called:
Extraction, Transformation, and Loading (ETL)
Normalization
Business Analytics
Data Mining (DM)
Question 14: The process which led to one grocery store's discover of a pattern of customers buying diapers and beer is called
DBMS
Data mining
ETL
Normalization
Question 15: Using Business Intelligence to support Decision Making helps to overcome which problem?
Moore's Law
Data rich, Information poor
The missionary-cannibal problem
Communication with people of lower intelligence
Question 16: One of the five networking elements creating a connected world is ______________________, which are standards specifying data formats and rules to be followed during transmission.
Protocols
Convergence
Access Technologies
Providers
Question 17: Which of the following is NOT one of the benefits of a connected world?
Reduced travel
Sharing resources
Enhanced security
Providing opportunities
Question 18: The gap between those who have access to technology and those who do not is called the
Electronic doldrums
Digital divide
Technology gap
Computer malaise
Question 19: Wireless communication categories include:
Security, Access, Integrity, and Ethics
PANs, WLANs, WMANs, and WWANs
Routers, Hubs, Switches, and Firewalls
Batman, Spiderman, Iron man, and Dr. Johnson
Question 20: A mobile application that can tell you where the nearest (to you, no matter where you are) gas station is, would be in which
category of wireless network applications?
Location-Based Services (LBS)
Geographic Information Systems (GIS)
Radio-Frequency Identification (RFID)
Global Positioning System (GPS)
Question 21: Which of the following is NOT an advantage provided by wireless networks?
Privacy
Enhanced mobility
Provides immediate data access
Improves workflow
Question 22: Challenges of Using wireless networks include: protecting against theft, protecting wireless connections, preventing viruses on mobile devices, and:
providing mobile business opportunities
providing alternatives to wiring
increasing location and monitoring capability
addressing privacy concerns
Question 23: Connections which allow communication among different systems and databases, and eliminate the need for manual data entry in to multiple systems are called:
Integrations
networks
functionality
Enterprise systems
Question 24: Maximizing total supply chain effectiveness is one goal of
Database management systems
Supply Chain Management (SCM)
Porter's value chain model
All international businesses
Question 25: Good supply chain management can help eliminate
Profits
Database update anomalies
System security breaches
The bullwhip effect
Question 26: Customer Relationship Management has nothing to do with supporting sales department operations.
No answer text provided.
No answer text provided.
False
True
Question 27: CRM is beneficial to companies because:
it brings customers into conformance with company standards
it isoates employees from personal contact with customers
it keeps annoying customers away
it helps companies treat customers well
Question 28: CRM is important to companies because:
customers are always loyal
it is easier than ever for customers to take their business elsewhere
customers never tell others about their business experiences
customers spend their money in as many places as possible
Question 29: ERP Systems integrate all departments and functions into a single IT system (or integrated set of IT systems).
No answer text provided.
False
True
No answer text provided.
Question 30: Which of the following has NOT been (historically and/or the present) a core component of ERP systems?
production and materials management
entrepreneurship
human resources
accounting and finance
Question 31: MIS stands for:
Management Information Systems
More Interstellar Sightings
Minor Irritation Syndrome
My, Isn't it Special!
Question 32: Column A of a spreadsheet contains the names sales representatives. Column B contains the sales amounts for sales completed by each representative. Every time another sale is completed a new row is added to the list. Now you want to calculate the total amount for all sales made by Kristin. A good function to accomplish this easily would be
SUMIF()
Vlookup()
ConditionalAdd ()
SORT()
Question 33: A 3-D formula applies a formula to the same cell in several worksheets at once.
No answer text provided.
No answer text provided.
False
True
Question 34: The only way to get data from a web page into a spreadsheet is to manually re-enter the data.
No answer text provided.
False
No answer text provided.
True
Question 35: Todd has entered a function in his worksheet to calculate the payment amount for a loan. He is thinking of borrowing between 10,000 and 15,000 dollars, at an interest rate between 5% and 7%. He would like to know what the payment would be for each combination of principal (10, 11, 12, 13, 14, and 15 thousand) and interest rate (5%, 5.5%, 6%, 6.5%, and 7%).
a web query
a two-variable data table
a pivot table
the scenario manager
Question 36: After creating a pro forma income statement, Julie realizes that if her assumptions are correct, her business will lose money next year. She tests different assumptions using the scenario manager, but now wants to know how much sales income would be necessary to attain a Net Income of exactly zero (break even). Julie should use:
Solver
a sharp pencil with a BIG eraser
A compound/nested IF function
Goal seek
Question 37: Which of the following includes the three primary network types?
LAN, WAN, MAN
LAN, WAN, SAN
LAN, WAN, XAN
LAN, SAN, XAN
Question 38: What is a large computer network usually spanning a city or a specific infrastructure like a college known as?
Local area network (LAN)
Metropolitan area network (MAN)
Wide area network (WAN)
Secure area network (SAN)
Question 39: The Internet is a hierarchical structure linking different levels of service providers whose millions of devices supply all the interconnections. The three levels outlined in the book from the top down include _____________________.
National service provider (NSP), Regional service provider (RSP), and Internet service provider (ISP)
None of these
Net server point (NSP), Radio server point (RSP), and Internet server point (ISP)
New system provider (NSP), Current system provider (CSP), and Order entry system provider (OSP)
Question 40: What measures network performance by the maximum amount of data that can pass from one point to another in a unit of time?
Bandwidth
Protocol
Frequency
Access
Question 41: What measures bandwidth in terms of numbers transferred or received per unit of time?
Bit rate
Broadband
Protocol
Connection time
Question 42: What is a high-speed Internet connection that is always connected and has a bandwidth greater than 2 Mbps?
None of these
Broadband
Dial up
Analog
Question 43: What is the standard Internet protocol, which provides the technical foundation for the public Internet?
Data streaming and DSL protocols
Data streaming rules and regulations
Internet protocol/Transmission control protocol (IP/TCP)
Transmission control protocol/Internet protocol (TCP/IP)
Question 44: What is a benefit of network convergence?
Multiple services offered from a single vendor
All of these
Multiple devices supported by one provider
The weaving together of voice, data, and video
Question 45: Tracert is a command in the Internet Control Message Protocol (ICMP) that does what?
Encrypts a data transmission between two IP addresses
Identifies all T1 lines between two IP addresses
There is no such command
Returns a list of all nodes traversed between two IP addresses
Question 46: The purpose of the Ping command is to:
determine whether a particular node on a network is active
"wake up" the nodes on a network
disable the target computer
annoy network managers
Question 47: Which of the following properly creates the largest heading?
Question 48: Which of the following properly inserts a picture?
Face.jpg = ![]()
![]()
face.jpg
Question 49: HTML stands for:
Hyperactive Text Making Language
Hypertrophyic Muscles and Ligaments
Hypertext Markup Language
High Tech Messaging Language
Question 50: Which of the following correctly creates a "click here" hyperlink to Utah State University's website?
click here
click here <'link>
click here "https://www.usu.edu"
Question 51: What is wrong with the following section of HTML code?:
- second
- first
- third
The list items are in the wrong order
The first tag should be
instead of
Nothing
There are no ending tags
Question 52: Why would a developer use this tag:
instead of this tag:
?
The ID allows the developer to assign specific styles to that one paragraph only
There is no difference and therefore no reason to use one over the other
"forfun" is a special HTML command that creates fun
The second one is incorrect and will crash the browser
Question 53: Which of the following tags is not part of a correctly made table in HTML?
Question 54: Both of the following numeric codes for colors produce red. What is the difference between them?
#ff0000
#660000
it will depend on the browser
#660000 is lighter and #ff0000 is darker
#660000 is darker and #ff0000 is lighter
There is no difference
Question 55: In CSS, the background color for a page element (such as table or body) is specified properly by which of the following?
{background-color: #fe23ab}
background {color: fe23ab}
{background-color: #fe23ab
backgound color: hot pink
Question 56: Which of the following is not part of the CSS box model?
padding
margin
spacing
border
Question 57: A developer would like to style some text to be quite large. Which style specification would accomplish this?
font-size; 50
{font-size: 50}
{font-size: quite large}
{font-size: 50%}
Question 58: Which item in an HTML page will be styled by the following?
#special {background-color: bisque; color: red; transform: rotate(60deg)}
Anything with ID="special" in its opening tag
I don't know but it will look really cool!
Anything in the file called "special.htm"
only paragraphs after the tag and before the tag
Question 59: What is wrong with the following style specification?
h1,h3,h6 {text-align: center}
Nothing is wrong. It should work fine.
It should say "middle" instead of "center"
There should be a semi-colon before the last curly bracket
You can't list tag names with commas like that
Question 60: What do the letters CSS stand for?
Webpage Appearance Change (in German)
Creative Style Sheets
Computer Style Sheets
Cascading Style Sheets
Question 61: Which of the following correctly links an HTML page to an external stylesheet?
styler.css
Question 62: What is the effect of the following CSS specification?
table {width: 50%}
All tables will shrink to 50% of their original size.
All tables will be 50% as wide as the page.
There will be no effect because the specification contains an error
Only the first table will be moved 50% away from the left margin
Question 63: A developer wants to style the word "big" differently than the rest of this sentence. How should the HTML be coded?
A developer wants to style the word "big" differently than the rest of this sentence.
A developer wants to style the word "big" differently than the rest of this sentence.
A developer wants to style the word "big" differently than the rest of this sentence.
No change in the HTML; the change is in the CSS file.
Question 64: How is XML different from HTML?
XML allows the user to define tags. In HTML tags are pre-defined.
HTML is very common but XML is rarely used
XML is only for spreadsheet applications. HTML is for the Internet
XML is the future. It will eventually replace HTML.
Question 65: What is the result of the following Excel function, assuming cell C1 has the value 100.
=if(c1>250,"high", if(c1>100, "medium", "low"))
high
low
an error message
medium
Question 66: What is the result of the following Excel function, assuming cell C1 has the value 100.
=if(c1<=100,"low", if(c1<=250, "medium", "high"))
high
an error message
low
medium
Question 67: What is the result of the following function, assuming cell C1 has the value: Richard = proper(C1)
RICHARD
richard
Richard
rICHARD
Question 68: Which of the following would result in a higher monthly payment amount?
=PMT(5%,5,50000,0,0)
No answer text provided.
=PMT(5%,5,50000,0,1)
No answer text provided.
Question 69: Which markup language is used in the following code?
Salt Lake City
SLC
UML - universal markup language
none of these
XML - extensible markup language
HTML - hypertext markup language
Question 70: What is the result of the following Excel function, assuming cell c1 has the value: Go#Froggy
=substitute(C1,"#"," ")
#########
Go#Froggy
Go Froggy
An error message
Question 71: In Excel, what is a "delimiter"?
none of these
An indicator of the maximum number of rows or columns
A special character (such as a tab or space) that separates data
Data that has been "embedded" from an external file
Question 72: Which major in the Huntsman School consistently has the highest placement rate and the highest starting salaries?
Business Administration
Marketing
Accounting
MIS
1436984
Questions
Answered
Start Excelling in your courses, Ask a tutor for help and get answers for your problems !!
ask Question