CGS 2518- MIDTERM EXAM QUESTIONS
WITH CORRECT ANSWERS
How to insert a pie chart using quick analysis - Answer-Step 1: Select the data values
you desire.
Step 2: Click on Ctrl + Q for the quick analysis shortcut.
Step 3: Click on the CHARTS category.
Step 4: Select pie chart.
How to move and resize a chart: - Answer-Step 1: highlight your desired data.
Step 2: Use the sizing handles at the bottom of the selected range.
What is what-if analysis? - Answer-Checking how changing the values of a cell will
affect the outcomes of the formulas in the worksheet.
What are the three types of what if analyses? - Answer-1- Scenarios: When you want to
test various variables.
2- Data tables: When you want to test one or two variables.
3- Goal Seek: When you want to test multiple variables that all have one specific
outcome.
clustered column chart - Answer-A column chart that displays the data values in
separate columns side-by-side.
Column Chart - Answer-a chart that uses bars of varying height to illustrate values in a
worksheet
stacked column chart - Answer-A column chart that places the data series values within
combined columns showing how much is contributed by each series.
100% stacked column chart - Answer-Makes the same comparison as the stacked
column chart except that the stacked sections are expressed as percentages
NPER function - Answer-A financial function that calculates the number of periods for
an investment or loan
What is an active worksheet? - Answer-The selected worksheet.
In group mode, any changes applied to the active worksheet such as formatting or
formulas, will also be applied to all the other worksheets in the group.
Table name - Answer-every excel table has a table name, you can change it from "table
1" to any descriptive name of your choice.
, What does it mean when the title bar shows [group] ? - Answer-That the worksheet is in
group editing mode.
Filter button - Answer-changes to a sort icon as a reminder that the data is sorted by
that field
How do you exit group editing mode? - Answer-You click on any tab or sheet outside of
the worksheet group.
OR, right click the active sheet, and select 'ungroup'
Header row - Answer-The first row of the table that is formatted differently and should
be repeated for tables that continue beyond one page.
How does the name of the active sheet appear? - Answer-In bold text and a different
color.
Record - Answer-a group of related fields, every row represents a record.
What is a worksheet group? - Answer-A collection of two or more selected worksheets.
Sort - Answer-To arrange data alphabetically, numerically, or chronologically.
How do you group adjacent worksheets? - Answer-Hold Shift, click the first worksheet,
then click the last one and press enter.
Sort field - Answer-A field you use to order data
How do you group nonadjacent worksheets? - Answer-Hold Ctrl, select the desired
worksheets, press enter.
Predefined list - Answer-Sorts data in chronological order
What is 3D Reference? - Answer-Combines sheet references and cell references.
Refers to the same cell or range in multiple worksheets of the same workbook.
('Quarter 1:Quarter 4'!E10)
Table styles - Answer-allow you to easily add formatting to your table by using preset
combinations
Why use multiple worksheets? - Answer-Because it makes it easier to filter and
summarize data.
field name/column header - Answer-A unique label that describes the contents of the
data in a column.
WITH CORRECT ANSWERS
How to insert a pie chart using quick analysis - Answer-Step 1: Select the data values
you desire.
Step 2: Click on Ctrl + Q for the quick analysis shortcut.
Step 3: Click on the CHARTS category.
Step 4: Select pie chart.
How to move and resize a chart: - Answer-Step 1: highlight your desired data.
Step 2: Use the sizing handles at the bottom of the selected range.
What is what-if analysis? - Answer-Checking how changing the values of a cell will
affect the outcomes of the formulas in the worksheet.
What are the three types of what if analyses? - Answer-1- Scenarios: When you want to
test various variables.
2- Data tables: When you want to test one or two variables.
3- Goal Seek: When you want to test multiple variables that all have one specific
outcome.
clustered column chart - Answer-A column chart that displays the data values in
separate columns side-by-side.
Column Chart - Answer-a chart that uses bars of varying height to illustrate values in a
worksheet
stacked column chart - Answer-A column chart that places the data series values within
combined columns showing how much is contributed by each series.
100% stacked column chart - Answer-Makes the same comparison as the stacked
column chart except that the stacked sections are expressed as percentages
NPER function - Answer-A financial function that calculates the number of periods for
an investment or loan
What is an active worksheet? - Answer-The selected worksheet.
In group mode, any changes applied to the active worksheet such as formatting or
formulas, will also be applied to all the other worksheets in the group.
Table name - Answer-every excel table has a table name, you can change it from "table
1" to any descriptive name of your choice.
, What does it mean when the title bar shows [group] ? - Answer-That the worksheet is in
group editing mode.
Filter button - Answer-changes to a sort icon as a reminder that the data is sorted by
that field
How do you exit group editing mode? - Answer-You click on any tab or sheet outside of
the worksheet group.
OR, right click the active sheet, and select 'ungroup'
Header row - Answer-The first row of the table that is formatted differently and should
be repeated for tables that continue beyond one page.
How does the name of the active sheet appear? - Answer-In bold text and a different
color.
Record - Answer-a group of related fields, every row represents a record.
What is a worksheet group? - Answer-A collection of two or more selected worksheets.
Sort - Answer-To arrange data alphabetically, numerically, or chronologically.
How do you group adjacent worksheets? - Answer-Hold Shift, click the first worksheet,
then click the last one and press enter.
Sort field - Answer-A field you use to order data
How do you group nonadjacent worksheets? - Answer-Hold Ctrl, select the desired
worksheets, press enter.
Predefined list - Answer-Sorts data in chronological order
What is 3D Reference? - Answer-Combines sheet references and cell references.
Refers to the same cell or range in multiple worksheets of the same workbook.
('Quarter 1:Quarter 4'!E10)
Table styles - Answer-allow you to easily add formatting to your table by using preset
combinations
Why use multiple worksheets? - Answer-Because it makes it easier to filter and
summarize data.
field name/column header - Answer-A unique label that describes the contents of the
data in a column.
