CGS 2518 EXAM QUESTIONS WITH
CORRECT ANSWERS
If Cell E15 contains the formula =$C$5*J$15, what type of reference is the J$15 in the
formula?
A) relative reference
B) absolute reference
C) mixed reference
D) syntax - Answer-mixed reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)/5?
A)=SUM(B5:F5)/5
B)=AVERAGE(B5:F5)
C)=MEDIAN(B5:F5)
D)=COUNT(B5;F5) - Answer-=AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined
names?
A) function screen tip
B) formula auto complete
C) insert function dialog box
D)function argument dialog box - Answer-formula auto complete
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?
A)=$B3
B)=B3
C)=$C5
D)=$B5 - Answer-=$B5
Which of the following functions should be used to insert the current date and time in a
cell?
A)=TODAY()
B)=CURRENT()
C)=NOW()
D)=DATE - Answer-=Now()
Which of the following is not an argument of the IF function?
A) value_if_true
B) value_if_false
C) logical_test
D) lookup_value - Answer-lookup_value
, 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 - Answer-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 C5?
A)APR
B)Periodic interest rate
C)loan amount
D)number of payment periods - Answer-periodic interest rate
Which of the following is not an appropriate use of the SUM function?
A) =SUM(B3:B45)
B) =SUM(F1:G10)
C)=SUM(A8:A15,D8:15)
D)=SUM(D15-C15) - Answer-=sum(D15-C15)
What is the keyboard shortcut to create an absolute reference?
A)F2
B)F3
C)F4
D)Alt - Answer-F4
What type of chart is the least appropriate for depicting yearly rainfall totals for five cities
for four years?
A) pie chart
B) line chart
C) column chart
D)bar chart - Answer-pie chart
Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the
category axis?
A)700
B) Thousands
C) CIS Managers
D) Job Titles - Answer-cis managers
Which of the following is not a type of sparkline?
A) column
B) win loss
C) bar
D) line - Answer-bar
CORRECT ANSWERS
If Cell E15 contains the formula =$C$5*J$15, what type of reference is the J$15 in the
formula?
A) relative reference
B) absolute reference
C) mixed reference
D) syntax - Answer-mixed reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)/5?
A)=SUM(B5:F5)/5
B)=AVERAGE(B5:F5)
C)=MEDIAN(B5:F5)
D)=COUNT(B5;F5) - Answer-=AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined
names?
A) function screen tip
B) formula auto complete
C) insert function dialog box
D)function argument dialog box - Answer-formula auto complete
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?
A)=$B3
B)=B3
C)=$C5
D)=$B5 - Answer-=$B5
Which of the following functions should be used to insert the current date and time in a
cell?
A)=TODAY()
B)=CURRENT()
C)=NOW()
D)=DATE - Answer-=Now()
Which of the following is not an argument of the IF function?
A) value_if_true
B) value_if_false
C) logical_test
D) lookup_value - Answer-lookup_value
, 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 - Answer-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 C5?
A)APR
B)Periodic interest rate
C)loan amount
D)number of payment periods - Answer-periodic interest rate
Which of the following is not an appropriate use of the SUM function?
A) =SUM(B3:B45)
B) =SUM(F1:G10)
C)=SUM(A8:A15,D8:15)
D)=SUM(D15-C15) - Answer-=sum(D15-C15)
What is the keyboard shortcut to create an absolute reference?
A)F2
B)F3
C)F4
D)Alt - Answer-F4
What type of chart is the least appropriate for depicting yearly rainfall totals for five cities
for four years?
A) pie chart
B) line chart
C) column chart
D)bar chart - Answer-pie chart
Look at the stacked bar chart in Figure 3.35. Which of the following is a category on the
category axis?
A)700
B) Thousands
C) CIS Managers
D) Job Titles - Answer-cis managers
Which of the following is not a type of sparkline?
A) column
B) win loss
C) bar
D) line - Answer-bar
