MIS 2201 Final Exam with Correct
Answers
Which kinds of formatting is NOT normally allowed in a word processor such as MS
Word? - Answer-Multiple file formatting
A file ______ is one or more descriptive words you store with a file to help identify its
purpose or contents. - Answer-tag
Search ____ are conditions that a file or folder must meet to have windows find it -
Answer-criteria
Which of the following is an example of nonvolatile memory? - Answer-Optical disk
Which of the following statements hold true for the term "HTML"? - Answer-It refers to
the language used to create and formate web pages.
The internet is the largest example of a ____. - Answer-WAN
In an E-R diagram, a line between two entities represents a(n) ________. - Answer-
Relationship
Columns that are keys to different tables than the ones in which they reside are called
________. - Answer-Foreign keys
In excel, the term used to represent the money being loaned in is known as the _____. -
Answer-Present value
In a database, when data items disagree with one another, this leads to a(n) ________.
- Answer-Data integrity problem
A primary key used in a database is a ________. - Answer-a column or group of
columns that identifies a unique row in a table
__________ is a data analysis technique used by decision makers to quickly get
answers to complex queries that encompass multiple factors, such as locations,
revenue, time periods, and employee status. - Answer-OLAP
Which of these is the best definition for a database? - Answer-Self-describing, collection
of integrated and related records.
One of the goals of business intelligence is to _________. - Answer-Present the results
in an easy to understand manner
,In excel mary enters .03 in cell D2 so that she can predict her monthly income for the
next year. What function key will make D2 an absolute reference? - Answer-F4
Which phase of the SDLC determines whether there is a real need for system? -
Answer-System planning
Which of the following is done in the maintenance phase of the SDLC? - Answer-Fixing
failures and bugs
Which of the these applications of data analytics involves identifying money laundering
activities? - Answer-Fraud detection
Which of the following describes the correct sequence for the phases of the SDLC? -
Answer-Definition (Planning), Analysis, design, implementation, maintenance
Operational effectiveness, a strategy that is not effective refers to: - Answer-Performing
the same tasks better than rivals perform them.
In excel, the formula =IF(G22="x",SUM(H22:J22,"") with display _____ if G22 is not
equal to "x". - Answer-A blank cell
____ rows and columns lets you keep headings on the screen as you work with the data
in a large worksheet. - Answer-Freezing
Alternatives to the SDLC such as rapid application development, the unified process,
extreme programming, and scrum have let to _________. - Answer-Agile development
Which of the following is NOT true regarding to Business Analytics (BA) - Answer-
Business analytics can be used only for forecasting future business results.
In Excel a _____ contains the actual values that are plotted on the chart. - Answer-data
series
Excel can be used as a simple database. Which of these functions are considered
database-like functions in Excel? - Answer-Look up functions like VLOOKUP
Business Analytics - Answer-Extensive use of data and quantitative analysis to support
face-based decision making within organizations.
Business Intelligence - Answer-Includes a wide range of applications, practices, and
technologies for the extraction, transformation, integration, visualization, analysis
interpretation, and presentation of data to support improved decision making.
Data Scientist - Answer-Individuals who have:
1. strong business background and experience.
, 2. healthy appreciation of limitations of their data, tools and techniques
3. Deep understanding of analytics.
Online Analytical Processing (OLAP) Analytic Tool - Answer-Method to analyze
multidimensional data from many different perspectives. Shows trends in and
opportunities in businesses.
Data Cubes - Answer-Container numeric facts called measures, which are categorized
by dimensions such as time and geography.
Data Mining (Analytic Tool) - Answer-Used to explore large amounts of data for hidden
patterns to predict future trends and behaviors for use in decision making.
Association Analysis (Data Mining) - Answer-specialized set of algorithms sorts through
data and forms statistical rules about relationships among the items
Case-Based Reasoning (Data Mining) - Answer-Historical if-then-else cases are used to
recognize patterns
Data Visualization (Analytic Tool) - Answer-Presentation of data in pictorial or graphical
format. Brings dull and boring numbers into interesting visuals.
TagCrowd & Word Cloud - Answer-Visual deception of words that have been grouped
together because of their frequency of occurrence.
Conversion Funnel - Answer-Graphical Representation that summarizes steps a
consumer takes in making a decision to buy a product.
Linear Regression (Analytic Tool) - Answer-Mathematical technique for predicting the
value of a dependent variable based on a single independent variable.
Dashboards (Analytic Tool) - Answer-Measures metrics that track progress in executing
chosen strategies to attain organizational objects and goals.
Balanced Scorecard - Answer-sets goals, measures, and targets for certain
departments.
Key Performance Indicators (KPIs) - Answer-Organization measure performance of
organization. Consists of objective, measure, target, and time frame.
Spreadsheets (Analytic Tool) - Answer-Data based on formulas to create reports and
graphs on data.
What-if Analysis - Answer-Analysis to evaluate various alternatives to a problem.
Computer Mistakes - Answer-Errors
Answers
Which kinds of formatting is NOT normally allowed in a word processor such as MS
Word? - Answer-Multiple file formatting
A file ______ is one or more descriptive words you store with a file to help identify its
purpose or contents. - Answer-tag
Search ____ are conditions that a file or folder must meet to have windows find it -
Answer-criteria
Which of the following is an example of nonvolatile memory? - Answer-Optical disk
Which of the following statements hold true for the term "HTML"? - Answer-It refers to
the language used to create and formate web pages.
The internet is the largest example of a ____. - Answer-WAN
In an E-R diagram, a line between two entities represents a(n) ________. - Answer-
Relationship
Columns that are keys to different tables than the ones in which they reside are called
________. - Answer-Foreign keys
In excel, the term used to represent the money being loaned in is known as the _____. -
Answer-Present value
In a database, when data items disagree with one another, this leads to a(n) ________.
- Answer-Data integrity problem
A primary key used in a database is a ________. - Answer-a column or group of
columns that identifies a unique row in a table
__________ is a data analysis technique used by decision makers to quickly get
answers to complex queries that encompass multiple factors, such as locations,
revenue, time periods, and employee status. - Answer-OLAP
Which of these is the best definition for a database? - Answer-Self-describing, collection
of integrated and related records.
One of the goals of business intelligence is to _________. - Answer-Present the results
in an easy to understand manner
,In excel mary enters .03 in cell D2 so that she can predict her monthly income for the
next year. What function key will make D2 an absolute reference? - Answer-F4
Which phase of the SDLC determines whether there is a real need for system? -
Answer-System planning
Which of the following is done in the maintenance phase of the SDLC? - Answer-Fixing
failures and bugs
Which of the these applications of data analytics involves identifying money laundering
activities? - Answer-Fraud detection
Which of the following describes the correct sequence for the phases of the SDLC? -
Answer-Definition (Planning), Analysis, design, implementation, maintenance
Operational effectiveness, a strategy that is not effective refers to: - Answer-Performing
the same tasks better than rivals perform them.
In excel, the formula =IF(G22="x",SUM(H22:J22,"") with display _____ if G22 is not
equal to "x". - Answer-A blank cell
____ rows and columns lets you keep headings on the screen as you work with the data
in a large worksheet. - Answer-Freezing
Alternatives to the SDLC such as rapid application development, the unified process,
extreme programming, and scrum have let to _________. - Answer-Agile development
Which of the following is NOT true regarding to Business Analytics (BA) - Answer-
Business analytics can be used only for forecasting future business results.
In Excel a _____ contains the actual values that are plotted on the chart. - Answer-data
series
Excel can be used as a simple database. Which of these functions are considered
database-like functions in Excel? - Answer-Look up functions like VLOOKUP
Business Analytics - Answer-Extensive use of data and quantitative analysis to support
face-based decision making within organizations.
Business Intelligence - Answer-Includes a wide range of applications, practices, and
technologies for the extraction, transformation, integration, visualization, analysis
interpretation, and presentation of data to support improved decision making.
Data Scientist - Answer-Individuals who have:
1. strong business background and experience.
, 2. healthy appreciation of limitations of their data, tools and techniques
3. Deep understanding of analytics.
Online Analytical Processing (OLAP) Analytic Tool - Answer-Method to analyze
multidimensional data from many different perspectives. Shows trends in and
opportunities in businesses.
Data Cubes - Answer-Container numeric facts called measures, which are categorized
by dimensions such as time and geography.
Data Mining (Analytic Tool) - Answer-Used to explore large amounts of data for hidden
patterns to predict future trends and behaviors for use in decision making.
Association Analysis (Data Mining) - Answer-specialized set of algorithms sorts through
data and forms statistical rules about relationships among the items
Case-Based Reasoning (Data Mining) - Answer-Historical if-then-else cases are used to
recognize patterns
Data Visualization (Analytic Tool) - Answer-Presentation of data in pictorial or graphical
format. Brings dull and boring numbers into interesting visuals.
TagCrowd & Word Cloud - Answer-Visual deception of words that have been grouped
together because of their frequency of occurrence.
Conversion Funnel - Answer-Graphical Representation that summarizes steps a
consumer takes in making a decision to buy a product.
Linear Regression (Analytic Tool) - Answer-Mathematical technique for predicting the
value of a dependent variable based on a single independent variable.
Dashboards (Analytic Tool) - Answer-Measures metrics that track progress in executing
chosen strategies to attain organizational objects and goals.
Balanced Scorecard - Answer-sets goals, measures, and targets for certain
departments.
Key Performance Indicators (KPIs) - Answer-Organization measure performance of
organization. Consists of objective, measure, target, and time frame.
Spreadsheets (Analytic Tool) - Answer-Data based on formulas to create reports and
graphs on data.
What-if Analysis - Answer-Analysis to evaluate various alternatives to a problem.
Computer Mistakes - Answer-Errors
