CGS 2518 EXAM QUESTIONS AND
ANSWERS
The Header & Footer Tools tab contains commands that insert codes into a header or
footer. These codes enable the header or footer text to change automatically. You can
insert a code for all of the following except: - Answer-Your name
Assume that the data on a worksheet consume a whole printed page and two columns
on a second page. You can do all of the following except what to force the data to print
all on one page? - Answer-Increase the left and right margins
If cell E15 contains the function =PMT(B$15/12,C7*12,-D8), what type of cell reference
is B$15? - Answer-absolute
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)? - Answer-=SUM(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined
names? - Answer-Formula AutoComplete
A formula containing the entry =J$7 is copied to a cell three columns to the right and
four rows down. How will the entry display in its new location? - Answer-=J$11
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 true about the VLOOKUP function? - 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? -
Answer-Periodic interest rate
Which of the following is not an appropriate use of the MAX function? - Answer-
=MAX(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
Why would Series 1 and Series 2 display in a chart legend? - Answer-Column headings
were not selected when creating a chart.
ANSWERS
The Header & Footer Tools tab contains commands that insert codes into a header or
footer. These codes enable the header or footer text to change automatically. You can
insert a code for all of the following except: - Answer-Your name
Assume that the data on a worksheet consume a whole printed page and two columns
on a second page. You can do all of the following except what to force the data to print
all on one page? - Answer-Increase the left and right margins
If cell E15 contains the function =PMT(B$15/12,C7*12,-D8), what type of cell reference
is B$15? - Answer-absolute
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)? - Answer-=SUM(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined
names? - Answer-Formula AutoComplete
A formula containing the entry =J$7 is copied to a cell three columns to the right and
four rows down. How will the entry display in its new location? - Answer-=J$11
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 true about the VLOOKUP function? - 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? -
Answer-Periodic interest rate
Which of the following is not an appropriate use of the MAX function? - Answer-
=MAX(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
Why would Series 1 and Series 2 display in a chart legend? - Answer-Column headings
were not selected when creating a chart.
