MSIS 3223 REVISION EXAM UPDATED 2026 QUESTIONS
AND ANSWERS SURE A+
✔✔Optimization - ✔✔finding values of decision variables that minimize (or maximize)
something such as cost (or profit)
✔✔Objective function - ✔✔the equation that minimizes (or maximizes) the quantity of
interest
✔✔Optimal solution - ✔✔values of the decision variables at the minimum (or maximum)
point
✔✔Problem Solving with Analytics - ✔✔1.Recognizing a problem
2.Defining the problem
3.Structuring the problem
4.Analyzing the problem
5.Interpreting results and making a decision
6.Implementing the solution
✔✔Data set - ✔✔a collection of data
✔✔Database - ✔✔a collection of related files containing records on people, places, or
things
✔✔Logical Functions
=IF(condition, value if true, value if false) - ✔✔returns one value if the condition is true
and another if the condition is false
✔✔Logical Functions
=AND(condition 1, condition 2...) - ✔✔returns TRUE if all conditions are true and FALSE
if not
✔✔Logical Functions
=OR(condition 1, condition 2...) - ✔✔returns TRUE if any condition is true and FALSE if
not.
✔✔=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) - ✔✔looks up
a value in the leftmost column of a table and returns a value in the same row from a
column you specify
✔✔=HLOOKUP(lookup_value,table_array,row_index_num,[range lookup]) - ✔✔looks
up a value in the top row of a table and returns a value in the same column from a row
you specify.
, ✔✔=INDEX(array,row_num,col_num) - ✔✔returns a value or reference of the cell at the
intersection of a particular row and column in a given range.
✔✔=MATCH(lookup_value,lookup_array,match_type) - ✔✔returns the relative position
of an item in an array that matches a specified value in a specified order.
✔✔=CHOOSE(index_num, value1, value2, . . . ) - ✔✔returns a value from a list based
on the position in the list, specified by index_num
✔✔PivotTables - ✔✔allows you to create custom summaries and charts of key
information in the data
✔✔How to create PivotTable - ✔✔Insert > Tables > PivotTable
✔✔Data visualization - ✔✔the process of displaying data (often in large quantities) in a
meaningful fashion to provide insights that will support better decisions.
✔✔Column and Bar Charts - ✔✔Excel distinguishes between vertical and horizontal bar
charts, calling the former column charts and the latter bar charts.
Column and bar charts are useful for comparing categorical or ordinal data, for
illustrating differences between sets of values, and for showing proportions or
percentages of a whole.
✔✔Line Charts - ✔✔Line charts provide a useful means for displaying data over time.
✔✔Pie Charts - ✔✔displays the relative proportion of each data source to the total by
partitioning a circle into pie-shaped areas.
✔✔Area Charts - ✔✔combines the features of a pie chart with those of line charts.
✔✔Scatter Charts - ✔✔show the relationship between two variables. To construct a
scatter chart, we need observations that consist of pairs of variables.
✔✔Orbit Charts - ✔✔scatter chart in which the points are connected in sequence, such
as over time. Orbit charts show the "path" that the data take over time, often showing
some unusual patterns that can provide unique insights.
✔✔Bubble Charts - ✔✔type of scatter chart in which the size of the data marker
corresponds to the value of a third variable; consequently, it is a way to plot three
variables in two dimensions.
✔✔Combination Charts - ✔✔Excel 2016 for Windows provides a Combo Chartoption for
constructing such a combination chart; in Excel 2016 for Mac, it must be done manually.
AND ANSWERS SURE A+
✔✔Optimization - ✔✔finding values of decision variables that minimize (or maximize)
something such as cost (or profit)
✔✔Objective function - ✔✔the equation that minimizes (or maximizes) the quantity of
interest
✔✔Optimal solution - ✔✔values of the decision variables at the minimum (or maximum)
point
✔✔Problem Solving with Analytics - ✔✔1.Recognizing a problem
2.Defining the problem
3.Structuring the problem
4.Analyzing the problem
5.Interpreting results and making a decision
6.Implementing the solution
✔✔Data set - ✔✔a collection of data
✔✔Database - ✔✔a collection of related files containing records on people, places, or
things
✔✔Logical Functions
=IF(condition, value if true, value if false) - ✔✔returns one value if the condition is true
and another if the condition is false
✔✔Logical Functions
=AND(condition 1, condition 2...) - ✔✔returns TRUE if all conditions are true and FALSE
if not
✔✔Logical Functions
=OR(condition 1, condition 2...) - ✔✔returns TRUE if any condition is true and FALSE if
not.
✔✔=VLOOKUP(lookup_value,table_array,col_index_num,[range_lookup]) - ✔✔looks up
a value in the leftmost column of a table and returns a value in the same row from a
column you specify
✔✔=HLOOKUP(lookup_value,table_array,row_index_num,[range lookup]) - ✔✔looks
up a value in the top row of a table and returns a value in the same column from a row
you specify.
, ✔✔=INDEX(array,row_num,col_num) - ✔✔returns a value or reference of the cell at the
intersection of a particular row and column in a given range.
✔✔=MATCH(lookup_value,lookup_array,match_type) - ✔✔returns the relative position
of an item in an array that matches a specified value in a specified order.
✔✔=CHOOSE(index_num, value1, value2, . . . ) - ✔✔returns a value from a list based
on the position in the list, specified by index_num
✔✔PivotTables - ✔✔allows you to create custom summaries and charts of key
information in the data
✔✔How to create PivotTable - ✔✔Insert > Tables > PivotTable
✔✔Data visualization - ✔✔the process of displaying data (often in large quantities) in a
meaningful fashion to provide insights that will support better decisions.
✔✔Column and Bar Charts - ✔✔Excel distinguishes between vertical and horizontal bar
charts, calling the former column charts and the latter bar charts.
Column and bar charts are useful for comparing categorical or ordinal data, for
illustrating differences between sets of values, and for showing proportions or
percentages of a whole.
✔✔Line Charts - ✔✔Line charts provide a useful means for displaying data over time.
✔✔Pie Charts - ✔✔displays the relative proportion of each data source to the total by
partitioning a circle into pie-shaped areas.
✔✔Area Charts - ✔✔combines the features of a pie chart with those of line charts.
✔✔Scatter Charts - ✔✔show the relationship between two variables. To construct a
scatter chart, we need observations that consist of pairs of variables.
✔✔Orbit Charts - ✔✔scatter chart in which the points are connected in sequence, such
as over time. Orbit charts show the "path" that the data take over time, often showing
some unusual patterns that can provide unique insights.
✔✔Bubble Charts - ✔✔type of scatter chart in which the size of the data marker
corresponds to the value of a third variable; consequently, it is a way to plot three
variables in two dimensions.
✔✔Combination Charts - ✔✔Excel 2016 for Windows provides a Combo Chartoption for
constructing such a combination chart; in Excel 2016 for Mac, it must be done manually.
