CGS 2518 MC EXAM QUESTIONS AND
ANSWERS
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization? - Answer-Solver
What tool is used to edit pre-existing range names? - Answer-Name Manager
Which tool is most effective when comparing the impact of various combinations of
interest rates and down payments on a mortgage? - Answer-Two-variable data table
This tool calculates the value required in a single cell to produce a desired result within
a related cell. - Answer-Goal Seek
This analysis tool has the ability to handle multiple adjustable cells while minimizing,
maximizing, or meeting goals. - Answer-Solver
Which of the following is an excel add-in? - Answer-Solver
Which of the following is not an acceptable range name? - Answer-2018_Rate
What is the keyboard shortcut to paste range names? - Answer-F3
Which of the following tools can incorporate constraints? - Answer-Solver
How can you determine if the solver add-in is active? - Answer-Solver appears on Data
tab
Today's date (Feb.12, 2018) is stored in cell B1. The last day of the semester (May 4,
2018) is stored in cell B2. You want to know how many days until the end of the
semester. Which function should you use? - Answer-=DAYS(B2,B1)
The date 5/12/18 is stored (in format month/day/year) in cell C1. What function should
you use to extract just 12? - Answer-=DAY(C1)
Your workbook contains a list of artwork. Column b lists sold out if the piece is sold out,
available if it's available, or limited if only a few pieces are available. In the 3rd column,
you want to display TRUE if the artwork isn't sold out. What function would produce the
same results as =OR(B1="Available",B1="Limited") - Answer-=NOT(B1="Sold Out")
A workbook contains a list of members in the computer club. You want to identify the #
of students who are freshman information systems majors. Without filtering the dataset,
what function should you use? - Answer-DCOUNT
ANSWERS
Which what-if analysis tool is the best option for complex calculations requiring
constrained optimization? - Answer-Solver
What tool is used to edit pre-existing range names? - Answer-Name Manager
Which tool is most effective when comparing the impact of various combinations of
interest rates and down payments on a mortgage? - Answer-Two-variable data table
This tool calculates the value required in a single cell to produce a desired result within
a related cell. - Answer-Goal Seek
This analysis tool has the ability to handle multiple adjustable cells while minimizing,
maximizing, or meeting goals. - Answer-Solver
Which of the following is an excel add-in? - Answer-Solver
Which of the following is not an acceptable range name? - Answer-2018_Rate
What is the keyboard shortcut to paste range names? - Answer-F3
Which of the following tools can incorporate constraints? - Answer-Solver
How can you determine if the solver add-in is active? - Answer-Solver appears on Data
tab
Today's date (Feb.12, 2018) is stored in cell B1. The last day of the semester (May 4,
2018) is stored in cell B2. You want to know how many days until the end of the
semester. Which function should you use? - Answer-=DAYS(B2,B1)
The date 5/12/18 is stored (in format month/day/year) in cell C1. What function should
you use to extract just 12? - Answer-=DAY(C1)
Your workbook contains a list of artwork. Column b lists sold out if the piece is sold out,
available if it's available, or limited if only a few pieces are available. In the 3rd column,
you want to display TRUE if the artwork isn't sold out. What function would produce the
same results as =OR(B1="Available",B1="Limited") - Answer-=NOT(B1="Sold Out")
A workbook contains a list of members in the computer club. You want to identify the #
of students who are freshman information systems majors. Without filtering the dataset,
what function should you use? - Answer-DCOUNT
