CGS 2518 EXAM REVIEW QUESTIONS
WITH COMPLETE ANSWERS
You want to copy the March worksheet to use it to enter data for April. After you right-
click the March sheet tab and select Move or Copy, you click OK in the Move or Copy
dialog box without changing any settings. What happens?
- A copy of the March sheet is inserted to the right of the original March sheet. The new
sheet is named April automatically
- A copy of the March sheet is inserted to the left of the original March sheet. The new
sheet is named March (1)
- The March sheet is moved to the left of the first sheet tab. The worksheet is not copied
- The March sheet is moved to a new workbook named Book1. The March sheet no
longer exists in the original workbook - Answer-A copy of the March sheet is inserted to
the left of the original March sheet. The new sheet is named March (1)
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:
- Your Name
- File Name
- Sheet Name
- Page Number. - 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?
- Decrease the Scale value
- Increase the left and right margins
- Decrease column widths
- Decrease the font size - Answer-Decrease the font size
If cell E15 contains the function =PMT(B$15/12,C7*12,-D8), what type of cell reference
is B$15?
- Relative reference
- Absolute reference
- Mixed reference
- Syntax - Answer-Mixed reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)?
,- =SUM(B5:F5)
- =AVERAGE(B5:F5)
- =MEDIAN(B5:F5)
- =COUNT(B5:F5) - Answer-=SUM(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined
names?
- Function ScreenTip
- Formula AutoComplete
- Insert Function dialog box
- Function Arguments dialog box - 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?
- =M$7
- =J$7
- =M11
- =J$11 - Answer-=M$7
Which of the following functions should be used to insert the current date and time in a
cell?
- =TODAY()
- =CURRENT()
- =NOW()
- =DATE - Answer-=NOW()
Which of the following is not a comparison operator?
-<
->
-&
- <> - Answer-&
Which of the following is NOT true about the VLOOKUP function?
- The col_index_num argument cannot be 1
- The lookup table must be in descending order
- The default match type is approximate
- The match type must be false when completing an exact match - 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?
, - APR
- Periodic interest rate
- Loan amount
- Number of payment periods - Answer-Periodic interest rate
Which of the following is not an appropriate use of the MAX function?
- =MAX(B3:B45)
- =MAX(F1:G10)
- =MAX(A8:A15,D8:D15)
- =MAX(D15-C15) - Answer-=MAX(D15-C15)
What is the keyboard shortcut to create an absolute reference?
- F2
- F3
- F4
- Alt - Answer-F4
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years?
- Pie chart
- Line chart
- Column chart
- Bar chart - Answer-Pie chart
Why would Series 1 and Series 2 display in a chart legend?
- The data are contained in one column
- The data are contained only in one row
- Column headings were not selected when creating a chart
- The selected headings are in non-adjacent cells to the values - Answer-Column
headings were not selected when creating a chart
You moved a chart to its own chart sheet. What chart element can you add to provide a
grid that contains a copy of the data source at the bottom of the chart?
- Axis title
- Data table
- Gridlines
- Error bars - Answer-Data table
WITH COMPLETE ANSWERS
You want to copy the March worksheet to use it to enter data for April. After you right-
click the March sheet tab and select Move or Copy, you click OK in the Move or Copy
dialog box without changing any settings. What happens?
- A copy of the March sheet is inserted to the right of the original March sheet. The new
sheet is named April automatically
- A copy of the March sheet is inserted to the left of the original March sheet. The new
sheet is named March (1)
- The March sheet is moved to the left of the first sheet tab. The worksheet is not copied
- The March sheet is moved to a new workbook named Book1. The March sheet no
longer exists in the original workbook - Answer-A copy of the March sheet is inserted to
the left of the original March sheet. The new sheet is named March (1)
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:
- Your Name
- File Name
- Sheet Name
- Page Number. - 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?
- Decrease the Scale value
- Increase the left and right margins
- Decrease column widths
- Decrease the font size - Answer-Decrease the font size
If cell E15 contains the function =PMT(B$15/12,C7*12,-D8), what type of cell reference
is B$15?
- Relative reference
- Absolute reference
- Mixed reference
- Syntax - Answer-Mixed reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)?
,- =SUM(B5:F5)
- =AVERAGE(B5:F5)
- =MEDIAN(B5:F5)
- =COUNT(B5:F5) - Answer-=SUM(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined
names?
- Function ScreenTip
- Formula AutoComplete
- Insert Function dialog box
- Function Arguments dialog box - 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?
- =M$7
- =J$7
- =M11
- =J$11 - Answer-=M$7
Which of the following functions should be used to insert the current date and time in a
cell?
- =TODAY()
- =CURRENT()
- =NOW()
- =DATE - Answer-=NOW()
Which of the following is not a comparison operator?
-<
->
-&
- <> - Answer-&
Which of the following is NOT true about the VLOOKUP function?
- The col_index_num argument cannot be 1
- The lookup table must be in descending order
- The default match type is approximate
- The match type must be false when completing an exact match - 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?
, - APR
- Periodic interest rate
- Loan amount
- Number of payment periods - Answer-Periodic interest rate
Which of the following is not an appropriate use of the MAX function?
- =MAX(B3:B45)
- =MAX(F1:G10)
- =MAX(A8:A15,D8:D15)
- =MAX(D15-C15) - Answer-=MAX(D15-C15)
What is the keyboard shortcut to create an absolute reference?
- F2
- F3
- F4
- Alt - Answer-F4
Which type of chart is the least appropriate for depicting yearly rainfall totals for five
cities for four years?
- Pie chart
- Line chart
- Column chart
- Bar chart - Answer-Pie chart
Why would Series 1 and Series 2 display in a chart legend?
- The data are contained in one column
- The data are contained only in one row
- Column headings were not selected when creating a chart
- The selected headings are in non-adjacent cells to the values - Answer-Column
headings were not selected when creating a chart
You moved a chart to its own chart sheet. What chart element can you add to provide a
grid that contains a copy of the data source at the bottom of the chart?
- Axis title
- Data table
- Gridlines
- Error bars - Answer-Data table
