CGS 2518 TEST MULTIPLE CHOICE
(ARMSTRONG) QUESTIONS AND
ANSWERS
Which of the following is not true about the VLOOKUP function?
a) The lookup table must be in ascending order.
b) The lookup table must be in descending order.
c) The default match type is approximate.
d) The match type must be false when completing an exact match. - Answer-b) The
lookup table must be in descending order.
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in Cell 5?
a) APR
b) Periodic interest rate
c) Loan amount
d) Number of payment periods - Answer-d) Number of payment periods
Look at the stacked bar chart in figure 3.35. Which of the following is a category on the
category axis?
a) Thousands
b) Job Titles
c) CIS Managers
d) 700 - Answer-c) CIS Managers
Which of the following is not a type of sparkling?
a) Line
b) Bar
c) Column
d) Win-Loss - Answer-b) Bar
If you want to show exact for a data series in a bar chart, which chart element should
you display?
a) Chart Title
b) Legend
c) Value axis title
d) Data labels - Answer-d) Data labels
(ARMSTRONG) QUESTIONS AND
ANSWERS
Which of the following is not true about the VLOOKUP function?
a) The lookup table must be in ascending order.
b) The lookup table must be in descending order.
c) The default match type is approximate.
d) The match type must be false when completing an exact match. - Answer-b) The
lookup table must be in descending order.
The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in Cell 5?
a) APR
b) Periodic interest rate
c) Loan amount
d) Number of payment periods - Answer-d) Number of payment periods
Look at the stacked bar chart in figure 3.35. Which of the following is a category on the
category axis?
a) Thousands
b) Job Titles
c) CIS Managers
d) 700 - Answer-c) CIS Managers
Which of the following is not a type of sparkling?
a) Line
b) Bar
c) Column
d) Win-Loss - Answer-b) Bar
If you want to show exact for a data series in a bar chart, which chart element should
you display?
a) Chart Title
b) Legend
c) Value axis title
d) Data labels - Answer-d) Data labels