BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
A)Goal Seek
B)Scenario Manager
C)Data Tables
D)Solver
D) Solver
Which of the following is not a capability of the Name Manager?
A)Create a new name range
B)Edit a name range
C)Delete a name range
D)Paste a name range
C)Delete a name range
Which tool is most effective when comparing the impact of various combinations
of production expenses and new customer acquisition on net sales profit?
A)Goal Seek
B)Solver
C)One- or two-variable data table
D)Scenario Manager
C)One- or two-variable data table
What tool calculates the value required in a single cell to produce a result within a
related cell?
A)Goal Seek
B)Solver
C)One- or two-variable data table
D)Scenario Manager
B)Solver
Which of the following is not an acceptable name range?
A)Purchase_Price
B)APR
C)Term
D)Down Payment
A)Purchase_Price
6. Which of the following constraint operators should be used to limit a constraint
to only whole numbers?
A)bin
B)int
C)dif
D)=
B)int
Which of the following is not an optimization capability of Solver?
A)Value of
, B)Min
C)Max
D)Average
D)Average
What is the keyboard shortcut to open the Paste Name dialog box?
A)F2
B)F3
C)F4
D)F5
B)F3
Which of the following tools can incorporate constraints?
A)Goal Seek
B)Solver
C)Data Tables
D)Scenario Manager
B)Solver
What tab displays the Scenario Manager?
A)Home tab
B)Formulas tab
C)Data tab
D)Analyze tab
C)Data tab
The date February 16, 2024, is stored in cell B1. The last day of the semester (May
7, 2024) is stored in cell B2. Which function calculates the number days between
those dates?
A)=DAYS(B1,B2)
B)=DAYS(B2,B1)
C)=YEARFRAC(B1,B2)
D)=DAY(B1)
B)=DAYS(B2,B1)
The date 8/9/2024 is stored in cell C5, and =WEEKDAY (C5) is stored in cell D5.
What is the default function result if cell D5 has not been formatted?
A)6
B)9
C)Friday, August 9, 2024
D)Friday
A)6
You want to use an IFS function to indicate which gift card customers get based
on the points they have accumulated in one month in the rewards program.
Customers who spent over $500 get $50, customers who spent between $250-
$499 get $25, and customers who spent $00-$199 get $10. The first customer's
amount spent is in cell B5. If the first logical test is b5>=500, what is the second
logical argument?
A)B5<500
B)B5>250
GRADED
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization?
A)Goal Seek
B)Scenario Manager
C)Data Tables
D)Solver
D) Solver
Which of the following is not a capability of the Name Manager?
A)Create a new name range
B)Edit a name range
C)Delete a name range
D)Paste a name range
C)Delete a name range
Which tool is most effective when comparing the impact of various combinations
of production expenses and new customer acquisition on net sales profit?
A)Goal Seek
B)Solver
C)One- or two-variable data table
D)Scenario Manager
C)One- or two-variable data table
What tool calculates the value required in a single cell to produce a result within a
related cell?
A)Goal Seek
B)Solver
C)One- or two-variable data table
D)Scenario Manager
B)Solver
Which of the following is not an acceptable name range?
A)Purchase_Price
B)APR
C)Term
D)Down Payment
A)Purchase_Price
6. Which of the following constraint operators should be used to limit a constraint
to only whole numbers?
A)bin
B)int
C)dif
D)=
B)int
Which of the following is not an optimization capability of Solver?
A)Value of
, B)Min
C)Max
D)Average
D)Average
What is the keyboard shortcut to open the Paste Name dialog box?
A)F2
B)F3
C)F4
D)F5
B)F3
Which of the following tools can incorporate constraints?
A)Goal Seek
B)Solver
C)Data Tables
D)Scenario Manager
B)Solver
What tab displays the Scenario Manager?
A)Home tab
B)Formulas tab
C)Data tab
D)Analyze tab
C)Data tab
The date February 16, 2024, is stored in cell B1. The last day of the semester (May
7, 2024) is stored in cell B2. Which function calculates the number days between
those dates?
A)=DAYS(B1,B2)
B)=DAYS(B2,B1)
C)=YEARFRAC(B1,B2)
D)=DAY(B1)
B)=DAYS(B2,B1)
The date 8/9/2024 is stored in cell C5, and =WEEKDAY (C5) is stored in cell D5.
What is the default function result if cell D5 has not been formatted?
A)6
B)9
C)Friday, August 9, 2024
D)Friday
A)6
You want to use an IFS function to indicate which gift card customers get based
on the points they have accumulated in one month in the rewards program.
Customers who spent over $500 get $50, customers who spent between $250-
$499 get $25, and customers who spent $00-$199 get $10. The first customer's
amount spent is in cell B5. If the first logical test is b5>=500, what is the second
logical argument?
A)B5<500
B)B5>250
