CGS 2518 MODULE 7 EXAM QUESTIONS
AND ANSWERS
Your coworker created a workbook with a list of names and addresses. The state
abbreviation and zip code are stored in once cell per customer, such as NC27215. You
need to be able to sort these data by postal code to use bulk-rate mailing. The
appropriate excel action is to - Answer-Type 27215 in the cell to the right of NC27215
and use Flash Fill
A workbook contains addresses in column C. the addresses use commas after the
street, city, and state such as 129 Elm Street. Column D contains the phone number.
You instruct excel to divide the data into multiple columns. You successfully divide the
column into four columns. What happens to the phone numbers in column D? - Answer-
The phone numbers are overwritten by the cities
You have client last names stored in column A and the date of their first purchase in
column B. You would like to create a custom account number by combining the client's
last name and date. What function would you use to complete the task? - Answer-
CONCATENATE
A worksheet contains a list of graduates at your university. The worksheet contains
these columns in this sequence: Student Last Name, Student First Name, College,
Major, and GPA. Data are sorted by College, then by Major, and then by Student Last
Name. What is the default At a change in setting within the Subtotal dialog box, and
what would be a more appropriate setting? - Answer-C. Student Last Name (default
field), College (correct field)
You created an outline within a worksheet. What does the [ - ] below button indicate to
the left of a row heading? - Answer-You can click it to collapse the details of that
category.
A worksheet contains a PivotTable placeholder and the PivotTable Fields List. No fields
have been added to the PivotTable yet. If you click the College Major field check box in
the PivotTable Fields List, where does Excel place this field? - Answer-ROWS area
You created a PivotTable to summarize commissions earned by employees in each
department. What is the default summary statistic for the commissions field when you
add it to the PivotTable? - Answer-Sum
You have created a PivotTable and made some changes to values in the original
dataset from which the PivotTable was created. How does this affect the PivotTable? -
Answer-Changes in the dataset do not affect the PivotTable until you refresh the
PivotTable.
AND ANSWERS
Your coworker created a workbook with a list of names and addresses. The state
abbreviation and zip code are stored in once cell per customer, such as NC27215. You
need to be able to sort these data by postal code to use bulk-rate mailing. The
appropriate excel action is to - Answer-Type 27215 in the cell to the right of NC27215
and use Flash Fill
A workbook contains addresses in column C. the addresses use commas after the
street, city, and state such as 129 Elm Street. Column D contains the phone number.
You instruct excel to divide the data into multiple columns. You successfully divide the
column into four columns. What happens to the phone numbers in column D? - Answer-
The phone numbers are overwritten by the cities
You have client last names stored in column A and the date of their first purchase in
column B. You would like to create a custom account number by combining the client's
last name and date. What function would you use to complete the task? - Answer-
CONCATENATE
A worksheet contains a list of graduates at your university. The worksheet contains
these columns in this sequence: Student Last Name, Student First Name, College,
Major, and GPA. Data are sorted by College, then by Major, and then by Student Last
Name. What is the default At a change in setting within the Subtotal dialog box, and
what would be a more appropriate setting? - Answer-C. Student Last Name (default
field), College (correct field)
You created an outline within a worksheet. What does the [ - ] below button indicate to
the left of a row heading? - Answer-You can click it to collapse the details of that
category.
A worksheet contains a PivotTable placeholder and the PivotTable Fields List. No fields
have been added to the PivotTable yet. If you click the College Major field check box in
the PivotTable Fields List, where does Excel place this field? - Answer-ROWS area
You created a PivotTable to summarize commissions earned by employees in each
department. What is the default summary statistic for the commissions field when you
add it to the PivotTable? - Answer-Sum
You have created a PivotTable and made some changes to values in the original
dataset from which the PivotTable was created. How does this affect the PivotTable? -
Answer-Changes in the dataset do not affect the PivotTable until you refresh the
PivotTable.
