1|Page
Misy 5325 Midterm Actual Exam Newest
2025/2026 Complete Questions And Correct
Detailed Answers (Verified Answers) |Brand New
Version!!
A chart__ controls which data series and categories are visible in a chart.
- SOLUTION=filter
Excel automatically determines the starting, incremental, and stopping
values on a chart based on the data selected. - SOLUTION=True
Which of the following is NOT one of most commonly used chart types?
- SOLUTION=X Y chart
A(n) ___ chart is a derivative of a scatter chart in which both axes are
value axes. - SOLUTION=bubble
Excel 2013 automatically assigns a different pattern to each column of a
clustered column chart. - SOLUTION=False
To begin creating sparklines on a worksheet, click the __ tab. -
SOLUTION=Insert
,2|Page
To print only a chart, select the chart, click the __ tab, and click Print. -
SOLUTION=file
Axes, chart tittles, and data tables are examples of chart elements. -
SOLUTION=True
In addition to sorting and filtering cells by content you can sort and/or
filter by __. - SOLUTION=conditional formatting
Excel enables you to sort data on __ different levels. - SOLUTION=64
Print order: - SOLUTION=is the sequence in which pages print.
Freeze Panes only locks columns above the active cell as you scroll
through a worksheet. - SOLUTION=false
Table style controls
Table Style Options group
Sorting Text A to Z
Sorting Dates oldest to newest
Sorting Values smallest to largest - SOLUTION=fill color of the header
row, columns and records in a table
,3|Page
check boxes to select format actions
arranges data in alphabetical order
displays data in chronological order
arranges numbers in sequential order
In addition to sorting and filtering cells by content, you can sort and/or
filter by __ formatting - SOLUTION=conditional
Highlight Cells Rules
Top Bottom Rules
Data bar
Color scale
Icon set - SOLUTION=highlights cells meeting criteria with a color,
font, or border
formats cells based on the value in relation to the other cells
horizontal gradient of solid fill indicating a cell's relative value
conditional format that displays a particular color based on the relative
value of a cell
conditional format that displays a small image representing a value
A(n) __ defines the range of data from a worksheet to print. -
SOLUTION=print area
, 4|Page
The ___ Table Style option displays the field names of a table when
checked. - SOLUTION=header row
Top/Bottom Rules: - SOLUTION=format cells based upon their value in
relation to the value of other cells.
Function key __ accesses to Go To command in Excel. -
SOLUTION=F5
To ___ a table into a range, click within the table, click the Table Tools
Design tab, and from the Tools group, select Convert to Range. -
SOLUTION=convert
You can apply text, value, and date filters to fields based on the data in a
particular field. - SOLUTION=true
_______ are acts that are hostile to an organization. -
SOLUTION=Intentional threats
________ help(s) prevent a hard drive from being a single point of
failure. __________ help(s) prevent a server from being a single point of
failure. _________ help(s) prevent a person from being a single point of
failure. - SOLUTION=RAID, Failover clusters, Cross-training
Misy 5325 Midterm Actual Exam Newest
2025/2026 Complete Questions And Correct
Detailed Answers (Verified Answers) |Brand New
Version!!
A chart__ controls which data series and categories are visible in a chart.
- SOLUTION=filter
Excel automatically determines the starting, incremental, and stopping
values on a chart based on the data selected. - SOLUTION=True
Which of the following is NOT one of most commonly used chart types?
- SOLUTION=X Y chart
A(n) ___ chart is a derivative of a scatter chart in which both axes are
value axes. - SOLUTION=bubble
Excel 2013 automatically assigns a different pattern to each column of a
clustered column chart. - SOLUTION=False
To begin creating sparklines on a worksheet, click the __ tab. -
SOLUTION=Insert
,2|Page
To print only a chart, select the chart, click the __ tab, and click Print. -
SOLUTION=file
Axes, chart tittles, and data tables are examples of chart elements. -
SOLUTION=True
In addition to sorting and filtering cells by content you can sort and/or
filter by __. - SOLUTION=conditional formatting
Excel enables you to sort data on __ different levels. - SOLUTION=64
Print order: - SOLUTION=is the sequence in which pages print.
Freeze Panes only locks columns above the active cell as you scroll
through a worksheet. - SOLUTION=false
Table style controls
Table Style Options group
Sorting Text A to Z
Sorting Dates oldest to newest
Sorting Values smallest to largest - SOLUTION=fill color of the header
row, columns and records in a table
,3|Page
check boxes to select format actions
arranges data in alphabetical order
displays data in chronological order
arranges numbers in sequential order
In addition to sorting and filtering cells by content, you can sort and/or
filter by __ formatting - SOLUTION=conditional
Highlight Cells Rules
Top Bottom Rules
Data bar
Color scale
Icon set - SOLUTION=highlights cells meeting criteria with a color,
font, or border
formats cells based on the value in relation to the other cells
horizontal gradient of solid fill indicating a cell's relative value
conditional format that displays a particular color based on the relative
value of a cell
conditional format that displays a small image representing a value
A(n) __ defines the range of data from a worksheet to print. -
SOLUTION=print area
, 4|Page
The ___ Table Style option displays the field names of a table when
checked. - SOLUTION=header row
Top/Bottom Rules: - SOLUTION=format cells based upon their value in
relation to the value of other cells.
Function key __ accesses to Go To command in Excel. -
SOLUTION=F5
To ___ a table into a range, click within the table, click the Table Tools
Design tab, and from the Tools group, select Convert to Range. -
SOLUTION=convert
You can apply text, value, and date filters to fields based on the data in a
particular field. - SOLUTION=true
_______ are acts that are hostile to an organization. -
SOLUTION=Intentional threats
________ help(s) prevent a hard drive from being a single point of
failure. __________ help(s) prevent a server from being a single point of
failure. _________ help(s) prevent a person from being a single point of
failure. - SOLUTION=RAID, Failover clusters, Cross-training
