1 | Page
MISY 5325 MIDTERM ACTUAL EXAM NEWEST
2026 2027 COMPLETE QUESTIONS AND
CORRECT DETAILED ANSWERS VERIFIED
ANSWERS BRAND NEW VERSION HIGH YIELD
STUDY GUIDE ACTUAL UPDATED PRACTICE
QUESTIONS MIDTERM EXAM PREPARATION
GRADED A+ SUCCESS REVIEW
In addition to sorting and filtering cells by content you can sort and/or filter by __.
- CORRECT ANSWER=conditional formatting
Excel enables you to sort data on __ different levels. - CORRECT ANSWER=64
Print order: - CORRECT ANSWER=is the sequence in which pages print.
Freeze Panes only locks columns above the active cell as you scroll through a
worksheet. - CORRECT ANSWER=false
Table style controls
Table Style Options group
,2 | Page
Sorting Text A to Z
Sorting Dates oldest to newest
Sorting Values smallest to largest - CORRECT ANSWER=fill color of the header
row, columns and records in a table
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 - CORRECT ANSWER=conditional
Highlight Cells Rules
Top Bottom Rules
Data bar
Color scale
Icon set - CORRECT ANSWER=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
,3 | Page
A(n) __ defines the range of data from a worksheet to print. - CORRECT
ANSWER=print area
The ___ Table Style option displays the field names of a table when checked. -
CORRECT ANSWER=header row
Top/Bottom Rules: - CORRECT ANSWER=format cells based upon their value
in relation to the value of other cells.
Function key __ accesses to Go To command in Excel. -
CORRECT ANSWER=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. -
CORRECT ANSWER=convert
You can apply text, value, and date filters to fields based on the data in a
particular field. - CORRECT ANSWER=true
_______ are acts that are hostile to an organization. - CORRECT
ANSWER=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.
, 4 | Page
_________ help(s) prevent a person from being a single point of failure. -
CORRECT ANSWER=RAID, Failover clusters, Cross-training _________ is the
process of creating a list of threats. - CORRECT ANSWER=Threat identification
__________ damage for the sake of doing damage, and they often choose
targets of opportunity. - CORRECT ANSWER=Vandals
____________ assessments are objective, while ___________ assessments
are subjective. - CORRECT ANSWER=Quantitative, qualitative
_____________ is the likelihood that a threat will exploit a vulnerability.
- CORRECT ANSWER=Probability
A __________ is a computer joined to a botnet. - CORRECT ANSWER=zombie
A ___________ plan can help ensure that mission-critical systems continue to
function after a disaster. - CORRECT ANSWER=business continuity
A ___________ plan can help you identify steps needed to restore a failed
system. - CORRECT ANSWER=disaster recovery
MISY 5325 MIDTERM ACTUAL EXAM NEWEST
2026 2027 COMPLETE QUESTIONS AND
CORRECT DETAILED ANSWERS VERIFIED
ANSWERS BRAND NEW VERSION HIGH YIELD
STUDY GUIDE ACTUAL UPDATED PRACTICE
QUESTIONS MIDTERM EXAM PREPARATION
GRADED A+ SUCCESS REVIEW
In addition to sorting and filtering cells by content you can sort and/or filter by __.
- CORRECT ANSWER=conditional formatting
Excel enables you to sort data on __ different levels. - CORRECT ANSWER=64
Print order: - CORRECT ANSWER=is the sequence in which pages print.
Freeze Panes only locks columns above the active cell as you scroll through a
worksheet. - CORRECT ANSWER=false
Table style controls
Table Style Options group
,2 | Page
Sorting Text A to Z
Sorting Dates oldest to newest
Sorting Values smallest to largest - CORRECT ANSWER=fill color of the header
row, columns and records in a table
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 - CORRECT ANSWER=conditional
Highlight Cells Rules
Top Bottom Rules
Data bar
Color scale
Icon set - CORRECT ANSWER=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
,3 | Page
A(n) __ defines the range of data from a worksheet to print. - CORRECT
ANSWER=print area
The ___ Table Style option displays the field names of a table when checked. -
CORRECT ANSWER=header row
Top/Bottom Rules: - CORRECT ANSWER=format cells based upon their value
in relation to the value of other cells.
Function key __ accesses to Go To command in Excel. -
CORRECT ANSWER=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. -
CORRECT ANSWER=convert
You can apply text, value, and date filters to fields based on the data in a
particular field. - CORRECT ANSWER=true
_______ are acts that are hostile to an organization. - CORRECT
ANSWER=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.
, 4 | Page
_________ help(s) prevent a person from being a single point of failure. -
CORRECT ANSWER=RAID, Failover clusters, Cross-training _________ is the
process of creating a list of threats. - CORRECT ANSWER=Threat identification
__________ damage for the sake of doing damage, and they often choose
targets of opportunity. - CORRECT ANSWER=Vandals
____________ assessments are objective, while ___________ assessments
are subjective. - CORRECT ANSWER=Quantitative, qualitative
_____________ is the likelihood that a threat will exploit a vulnerability.
- CORRECT ANSWER=Probability
A __________ is a computer joined to a botnet. - CORRECT ANSWER=zombie
A ___________ plan can help ensure that mission-critical systems continue to
function after a disaster. - CORRECT ANSWER=business continuity
A ___________ plan can help you identify steps needed to restore a failed
system. - CORRECT ANSWER=disaster recovery
