CGS 2518 MULTIPLE CHOICE EXAM
QUESTIONS AND ANSWERS
When you start to type =AV, what feature displays a list of functions and defined
names? - Answer-Formula AutoComplete
A formula containing the entry =$B3 is copied to a cell one column to the right and two
rows down. How will the entry appear in its new location? - Answer-=$B5
Which of the following functions should be used to insert the current date and time in a
cell? - Answer-=NOW()
Which of the following is not an argument of the IF function? - Answer-lookup_value
Which of the following is not true about the VLOOKUP function? - Answer-the lookup
table must be in descending order
The function =PMT(C5,C7,-C3) is stored in C15. What must be stored in cell C5? -
Answer-Periodic interest rate
Which of the following is not an appropriate use of the SUM function? - Answer-
=SUM(D15-C15)
What is the keyboard shortcut to create an absolute reference? - Answer-F4
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years? - Answer-Pie Chart
Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the
category axis? - Answer-CIS Managers
Which of the following is not a type of sparkline? - Answer-Bar
If you want to show exact values for a data series in a bar chart, which chart element
should you display? - Answer-Data Labels
The value axis currently shows increments such as 50,000 and 100,000. What options
would you select to display the values in increments of 50 and 100? - Answer-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 five years. Which type of chart can accommodate your
needs? - Answer-100% stacked column chart
QUESTIONS AND ANSWERS
When you start to type =AV, what feature displays a list of functions and defined
names? - Answer-Formula AutoComplete
A formula containing the entry =$B3 is copied to a cell one column to the right and two
rows down. How will the entry appear in its new location? - Answer-=$B5
Which of the following functions should be used to insert the current date and time in a
cell? - Answer-=NOW()
Which of the following is not an argument of the IF function? - Answer-lookup_value
Which of the following is not true about the VLOOKUP function? - Answer-the lookup
table must be in descending order
The function =PMT(C5,C7,-C3) is stored in C15. What must be stored in cell C5? -
Answer-Periodic interest rate
Which of the following is not an appropriate use of the SUM function? - Answer-
=SUM(D15-C15)
What is the keyboard shortcut to create an absolute reference? - Answer-F4
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years? - Answer-Pie Chart
Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the
category axis? - Answer-CIS Managers
Which of the following is not a type of sparkline? - Answer-Bar
If you want to show exact values for a data series in a bar chart, which chart element
should you display? - Answer-Data Labels
The value axis currently shows increments such as 50,000 and 100,000. What options
would you select to display the values in increments of 50 and 100? - Answer-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 five years. Which type of chart can accommodate your
needs? - Answer-100% stacked column chart
