CGS 2518 EXAM MULTIPLE CHOICE
QUESTIONS AND ANSWERS
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
A worksheet contains a PivotTable placeholder and the PivotTable Fields List. No fields
have been added to the PivotTable yet. If you click the College Major field check box in
the PivotTable Field List, where does Excel place this Field? - Answer-
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 the
Data tab
Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May
4, 2018) is stored in cell B2. You to know how many days until the end of the semester?
Which function should you use? - Answer-=DAYS(B2,B1)
The date 5/12/2018 is stored 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 is still readily available, or Limited if only a few pieces are available. In the
3rd column, you want to display TRUE if the art is not sold out. What function would
produce the same results as =OR(B1="Avalible",B1="Limited")? - Answer-
=NOT(B1="Sold out")
A workbook contains a list of members in the Computer Club. You want to identify the
number of students who are freshmen who are Information Systems majors. Without
filtering the data set, what function should you use? - Answer-DCOUNT
A worksheet contains the times in which runners completed a race, with the times
organized from fastest to slowest. You will use the MATCH function to identify what
QUESTIONS AND ANSWERS
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
A worksheet contains a PivotTable placeholder and the PivotTable Fields List. No fields
have been added to the PivotTable yet. If you click the College Major field check box in
the PivotTable Field List, where does Excel place this Field? - Answer-
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 the
Data tab
Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May
4, 2018) is stored in cell B2. You to know how many days until the end of the semester?
Which function should you use? - Answer-=DAYS(B2,B1)
The date 5/12/2018 is stored 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 is still readily available, or Limited if only a few pieces are available. In the
3rd column, you want to display TRUE if the art is not sold out. What function would
produce the same results as =OR(B1="Avalible",B1="Limited")? - Answer-
=NOT(B1="Sold out")
A workbook contains a list of members in the Computer Club. You want to identify the
number of students who are freshmen who are Information Systems majors. Without
filtering the data set, what function should you use? - Answer-DCOUNT
A worksheet contains the times in which runners completed a race, with the times
organized from fastest to slowest. You will use the MATCH function to identify what
