MSIS 3223 EXAM 1 REVISION
QUESTIONS AND CORRECT ANSWERS
Dashboards may include tabular as well as visual data
to help a manager to quickly locate key information.
True
AND(condition 1, condition 2...) is a logical function
that returns TRUE if all conditions are true and FALSE
if not.
True
The Pareto principle is often called the "80--20 rule."
True
The filter tool extracts records meeting the specified
criteria, deleting any records that don't match the
criteria.
False
Three useful logical functions in business analytics
applications are IF, AND, and OR followed by
conditions in parentheses.
True
Form controls are buttons, boxes, and other
mechanisms for inputting or changing data on
spreadsheets easily and used to design user-friendly
spreadsheets.
True
, PivotTables may be used to facilitate data
visualization and statistical analysis of data sets.
True
Excel has a tool called 'dicers' for drilling down data in
a PivotTable to display a subset of that data.
False
A database is a collection of related files (tables)
containing records on people, places, or things.
True
A data set is simply a collection of data.
True
Which of the following is not a lookup function in
Excel?
Countif
Excel distinguishes between vertical and horizontal
bar charts, calling the former column charts and the
latter bar charts.
True
Line charts provide a useful means for displaying data
over time.
True
A bubble chart is a type of scatter chart that provides
a way to plot three variables in two dimensions.
True
Tableau is a powerful and quickly growing data
visualization tool used in the Business Intelligence
Industry.
True
Data visualization is the process of displaying data in
a meaningful fashion to provide insights that will
support better decisions.
QUESTIONS AND CORRECT ANSWERS
Dashboards may include tabular as well as visual data
to help a manager to quickly locate key information.
True
AND(condition 1, condition 2...) is a logical function
that returns TRUE if all conditions are true and FALSE
if not.
True
The Pareto principle is often called the "80--20 rule."
True
The filter tool extracts records meeting the specified
criteria, deleting any records that don't match the
criteria.
False
Three useful logical functions in business analytics
applications are IF, AND, and OR followed by
conditions in parentheses.
True
Form controls are buttons, boxes, and other
mechanisms for inputting or changing data on
spreadsheets easily and used to design user-friendly
spreadsheets.
True
, PivotTables may be used to facilitate data
visualization and statistical analysis of data sets.
True
Excel has a tool called 'dicers' for drilling down data in
a PivotTable to display a subset of that data.
False
A database is a collection of related files (tables)
containing records on people, places, or things.
True
A data set is simply a collection of data.
True
Which of the following is not a lookup function in
Excel?
Countif
Excel distinguishes between vertical and horizontal
bar charts, calling the former column charts and the
latter bar charts.
True
Line charts provide a useful means for displaying data
over time.
True
A bubble chart is a type of scatter chart that provides
a way to plot three variables in two dimensions.
True
Tableau is a powerful and quickly growing data
visualization tool used in the Business Intelligence
Industry.
True
Data visualization is the process of displaying data in
a meaningful fashion to provide insights that will
support better decisions.
