UNH MIS (410) First Exam Study Set
|Questions Solved 100% Correct|
Verified Solutions
Columns are - ANSWER fields
Rows are - ANSWER records
Subtotal function - ANSWER returns an aggregate result for supplied values
Range name - ANSWER A word or string of characters that represent one or more cells
Axis title - ANSWER Label that describes either the category axis or the value axis
Clustered column chart - ANSWER Chart type to compare multiple categories of
data vertically
Pie chart - ANSWER Chart that shows each data point in proportion to the whole
data series
Bar chart - ANSWER Chart type that compares categories of data horizontally
Total Row - ANSWER A table row that appears below the last row of records in an
Excel table and displays summary or aggregate statistics, such as a sum or an average
, Table - ANSWER A structure that organizes data in a series of records (rows), with
each record made up of a number of fields( columns)
PivotTable - ANSWER An organized strutter that summarizes large amounts of
data without altering the original dataset
Rows area - ANSWER Drag fields here to display categories horizontally in a PivotTable
PivotChart - ANSWER A graphical representation of aggregated data derived from
a PivotTable
Slicer - ANSWER A window listing all items in a field and enabling efficient filtering
Plot area - ANSWER Section of a chart that contains graphical representation of the
values in a data series
Chart area - ANSWER Boundary that contains the entire chart and all of its
elements, including the plot area, title, legends, and labels
Data label - ANSWER Descriptive label that shows the exact value of the data points
on the value axis
Data point - ANSWER Numeric value that describes a single value on a chart
Filters area - ANSWER Drag fields here to be able to specify which values or con ten
to include or exclude in the PivotTable
|Questions Solved 100% Correct|
Verified Solutions
Columns are - ANSWER fields
Rows are - ANSWER records
Subtotal function - ANSWER returns an aggregate result for supplied values
Range name - ANSWER A word or string of characters that represent one or more cells
Axis title - ANSWER Label that describes either the category axis or the value axis
Clustered column chart - ANSWER Chart type to compare multiple categories of
data vertically
Pie chart - ANSWER Chart that shows each data point in proportion to the whole
data series
Bar chart - ANSWER Chart type that compares categories of data horizontally
Total Row - ANSWER A table row that appears below the last row of records in an
Excel table and displays summary or aggregate statistics, such as a sum or an average
, Table - ANSWER A structure that organizes data in a series of records (rows), with
each record made up of a number of fields( columns)
PivotTable - ANSWER An organized strutter that summarizes large amounts of
data without altering the original dataset
Rows area - ANSWER Drag fields here to display categories horizontally in a PivotTable
PivotChart - ANSWER A graphical representation of aggregated data derived from
a PivotTable
Slicer - ANSWER A window listing all items in a field and enabling efficient filtering
Plot area - ANSWER Section of a chart that contains graphical representation of the
values in a data series
Chart area - ANSWER Boundary that contains the entire chart and all of its
elements, including the plot area, title, legends, and labels
Data label - ANSWER Descriptive label that shows the exact value of the data points
on the value axis
Data point - ANSWER Numeric value that describes a single value on a chart
Filters area - ANSWER Drag fields here to be able to specify which values or con ten
to include or exclude in the PivotTable
