MISY 5325 FINAL SCRIPT 2026
MANAGEMENT INFORMATION SYSTEMS
QUESTIONS ANSWERS COMPLETE A+
◉ True or False: The IF function can contain an inner loop
Answer: True
◉ Give example of inner loop in IF function.
Answer: =if(A1>=90, "A", if(A1>=80, "B", if(A1>=70, "C", if(A1>=60,
"D", "F"))))
◉ True or False: You can press F5 to make a cell reference absolute
Answer: False
◉ True or False: The result of adding margin and cost of goods sold
is always equal to 100%.
Answer: True
◉ Gross margin
Answer: the profit made directly from selling products before
subtracting all expenses
, ◉ True or False: With accounting format the zero will be displayed
Answer: False
a hyphen will be displayed
◉ What is the most important concept in plotting a chart?
Answer: knowing what areas need to be highlighted
◉ True or False: When splitting a window into panes, you can create
up to 4 panes
Answer: True
◉ True or False: To freeze pane, the cursor needs to be placed on
row or column of the area you wish to freeze.
Answer: False
The cursor need to be one column or row after the area you wish to
freeze
◉ Using Excel to scrutinize the impact of changing values in cells
that are referenced by a formula in another cell is called
Answer: What-if analysis
MANAGEMENT INFORMATION SYSTEMS
QUESTIONS ANSWERS COMPLETE A+
◉ True or False: The IF function can contain an inner loop
Answer: True
◉ Give example of inner loop in IF function.
Answer: =if(A1>=90, "A", if(A1>=80, "B", if(A1>=70, "C", if(A1>=60,
"D", "F"))))
◉ True or False: You can press F5 to make a cell reference absolute
Answer: False
◉ True or False: The result of adding margin and cost of goods sold
is always equal to 100%.
Answer: True
◉ Gross margin
Answer: the profit made directly from selling products before
subtracting all expenses
, ◉ True or False: With accounting format the zero will be displayed
Answer: False
a hyphen will be displayed
◉ What is the most important concept in plotting a chart?
Answer: knowing what areas need to be highlighted
◉ True or False: When splitting a window into panes, you can create
up to 4 panes
Answer: True
◉ True or False: To freeze pane, the cursor needs to be placed on
row or column of the area you wish to freeze.
Answer: False
The cursor need to be one column or row after the area you wish to
freeze
◉ Using Excel to scrutinize the impact of changing values in cells
that are referenced by a formula in another cell is called
Answer: What-if analysis
