MISY 5325 MS EXCEL MIDTERM EXAM STUDY
GUIDE (ACTUAL 2025) GRADED A+
Which of the following is Not a number format available in
the Number group on the Home tab?
Date Format
To begin a formula in a cell, first type the # symbol.
False
Freeze Panes only locks columns above the active cell as you
scroll through a worksheet.
false
Table style controls
Table Style Options group
Sorting Text A to Z
Sorting Dates oldest to newest
Sorting Values smallest to largest
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
conditional
Highlight Cells Rules
Top Bottom Rules
Data bar
Color scale
Icon set
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.
print area
The ___ Table Style option displays the field names of a table
when checked.
header row
Top/Bottom Rules:
format cells based upon their value in relation to the value of
other cells.
Function key __ accesses to Go To command in Excel.
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.
convert
, You can apply text, value, and date filters to fields based on
the data in a particular field.
true
1.Filtering
2.Top 10 option
3.Custom Filter
4.Duplicate Values
5.Sorting
1.displays only records that meet conditions
2.specify a number or percentage of records to display
3.complex filtering requirements
4.conditional formatting that displays doubled cells
5.arranges records in a table by the value
1.Slicer
2.Filter
3.Calculated Field
4.PivotChart
GUIDE (ACTUAL 2025) GRADED A+
Which of the following is Not a number format available in
the Number group on the Home tab?
Date Format
To begin a formula in a cell, first type the # symbol.
False
Freeze Panes only locks columns above the active cell as you
scroll through a worksheet.
false
Table style controls
Table Style Options group
Sorting Text A to Z
Sorting Dates oldest to newest
Sorting Values smallest to largest
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
conditional
Highlight Cells Rules
Top Bottom Rules
Data bar
Color scale
Icon set
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.
print area
The ___ Table Style option displays the field names of a table
when checked.
header row
Top/Bottom Rules:
format cells based upon their value in relation to the value of
other cells.
Function key __ accesses to Go To command in Excel.
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.
convert
, You can apply text, value, and date filters to fields based on
the data in a particular field.
true
1.Filtering
2.Top 10 option
3.Custom Filter
4.Duplicate Values
5.Sorting
1.displays only records that meet conditions
2.specify a number or percentage of records to display
3.complex filtering requirements
4.conditional formatting that displays doubled cells
5.arranges records in a table by the value
1.Slicer
2.Filter
3.Calculated Field
4.PivotChart
