CGS 2518 Exam 1 with correct Answers
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 want to know how many days until the end of the
semester. Which function should you use? - Answers -c. =DAYS(B2, B1)
The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function
should you use to extract just 12? - Answers -c. =DAY(C1)
You 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
third column, you want to display TRUE if the art is not sold out. What function would
produce the same results as =OR(B1="Available", B1="Limited")? - Answers -d.
=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 dataset, what function should you use? - Answers -A. 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
place a runner came in given a time of 4:05 (four minutes and five seconds). Which
argument should contain the specific runner's time? - Answers -a. Lookup_value
What function would you use to calculate the total (i.e., cumulative) interest paid for the
first year of a mortgage? - Answers -a. CUMIPMT
When you are performing an advanced filter, where do you enter the rage for the
dataset? - Answers -B. List range
The original mortgage loan was for $300,000 with a 5% APR for 30 years. You want to
calculate the interest on the last monthly payment at the end of the 15th year. What
value should be referenced for the per argument in the IPMT function? Hint: Number of
payment periods in a year is 12. - Answers -A. 180
A local police office wants to create a rule that if an officer pulls over a person for
exceeding the speed limit by at least five miles per hour or if that person has two or
more speeding violations on record, the officer will fine the speeder the higher of $200
or $50 for each mile over the speed limit. Otherwise, the fine is $45. The speed limit is
entered in cell B5, the person's speed is entered in cell B10, and the person's number of
previous tickets is entered in cell B11. What function derives the correct answer?
, When you start to type =AV, what feature displays a list of functions and defined
names? - Answers -Formula AutoComplete
A formula containing the entry =$B3 is copied down to a cell one column to the right and
two rows down. How will the entry appear in its new location? - Answers -=$B5
If cell E15 contains the formula $C$5*J$15 what type of cell reference is the J$15 in the
formula? - Answers -Mixed reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)/5? - Answers -=AVERAGE(B5:F5)
Which of the following functions should be used to insert the current date and time in a
cell? - Answers -=NOW()
Which of the following is not an argument of the IF function? - Answers -lookup_value
a. =IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50), 45)
b. =IF(OR(B10>B5, B11>=2), MAX(200, 50), 45)
c. =IF(AND(B10-B5>=5, B11<2), MAX(200, (B10-B5)*50), 45)
d. =IF(AND(B10>B5, B11>=2), 200, 45) - Answers -a. =IF(OR(B10-B5>=5, B11>=2),
MAX(200, (B10B5)*50), 45)
What function would you use to calculate the total number of periods in a loan or
investment? - Answers -C. NPER
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years? - Answers -Pie chart
Look at the stacked bar chart in Figure.3.35. Which of the following is a category on the
category axis? - Answers -CIS Managers
Which of the following is NOT a type of sparkline? - Answers -bar
If you want to show exact values for a data series in a bar chart, which chart element
should you display? - Answers -data labels
The value axis currently shows increments such as 50,000 and 100,000. What option
would you select to display the values in increments of 50 and 100? - Answers -show
axis in thousands
You want to create a single chart that shows the proportion of yearly sales for five
divisions for each year for 5 years. Which type of chart can accommodate your needs? -
Answers -100% stacked column chart
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 want to know how many days until the end of the
semester. Which function should you use? - Answers -c. =DAYS(B2, B1)
The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function
should you use to extract just 12? - Answers -c. =DAY(C1)
You 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
third column, you want to display TRUE if the art is not sold out. What function would
produce the same results as =OR(B1="Available", B1="Limited")? - Answers -d.
=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 dataset, what function should you use? - Answers -A. 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
place a runner came in given a time of 4:05 (four minutes and five seconds). Which
argument should contain the specific runner's time? - Answers -a. Lookup_value
What function would you use to calculate the total (i.e., cumulative) interest paid for the
first year of a mortgage? - Answers -a. CUMIPMT
When you are performing an advanced filter, where do you enter the rage for the
dataset? - Answers -B. List range
The original mortgage loan was for $300,000 with a 5% APR for 30 years. You want to
calculate the interest on the last monthly payment at the end of the 15th year. What
value should be referenced for the per argument in the IPMT function? Hint: Number of
payment periods in a year is 12. - Answers -A. 180
A local police office wants to create a rule that if an officer pulls over a person for
exceeding the speed limit by at least five miles per hour or if that person has two or
more speeding violations on record, the officer will fine the speeder the higher of $200
or $50 for each mile over the speed limit. Otherwise, the fine is $45. The speed limit is
entered in cell B5, the person's speed is entered in cell B10, and the person's number of
previous tickets is entered in cell B11. What function derives the correct answer?
, When you start to type =AV, what feature displays a list of functions and defined
names? - Answers -Formula AutoComplete
A formula containing the entry =$B3 is copied down to a cell one column to the right and
two rows down. How will the entry appear in its new location? - Answers -=$B5
If cell E15 contains the formula $C$5*J$15 what type of cell reference is the J$15 in the
formula? - Answers -Mixed reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)/5? - Answers -=AVERAGE(B5:F5)
Which of the following functions should be used to insert the current date and time in a
cell? - Answers -=NOW()
Which of the following is not an argument of the IF function? - Answers -lookup_value
a. =IF(OR(B10-B5>=5, B11>=2), MAX(200, (B10-B5)*50), 45)
b. =IF(OR(B10>B5, B11>=2), MAX(200, 50), 45)
c. =IF(AND(B10-B5>=5, B11<2), MAX(200, (B10-B5)*50), 45)
d. =IF(AND(B10>B5, B11>=2), 200, 45) - Answers -a. =IF(OR(B10-B5>=5, B11>=2),
MAX(200, (B10B5)*50), 45)
What function would you use to calculate the total number of periods in a loan or
investment? - Answers -C. NPER
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years? - Answers -Pie chart
Look at the stacked bar chart in Figure.3.35. Which of the following is a category on the
category axis? - Answers -CIS Managers
Which of the following is NOT a type of sparkline? - Answers -bar
If you want to show exact values for a data series in a bar chart, which chart element
should you display? - Answers -data labels
The value axis currently shows increments such as 50,000 and 100,000. What option
would you select to display the values in increments of 50 and 100? - Answers -show
axis in thousands
You want to create a single chart that shows the proportion of yearly sales for five
divisions for each year for 5 years. Which type of chart can accommodate your needs? -
Answers -100% stacked column chart
