6/16/25, 8:40 AM MISY 5325 MS Excel Midterm Exam Study Guide ACTUAL exam: QUESTION AND ANSWERS UPDATED 2025 Flashcards | Quizlet
MISY 5325 MS Excel Midterm Exam Study Guide
ACTUAL exam: QUESTION AND ANSWERS
UPDATED 2025
Save
Terms in this set (362)
Which of the following is Date Format
Not a number format
available in the Number
group on the Home tab?
To begin a formula in a False
cell, first type the #
symbol.
When you hide a column True
or row, the data is not
deleted, it is just hidden.
Text in a cell can by angle True
clockwise
The ___ command is helpful Go to
for navigating to a cell that
is not visible onscreen
The ___ view displays print Office Backstage
options and displays a
worksheet in print preview
https://quizlet.com/1054641438/misy-5325-ms-excel-midterm-exam-study-guide-actual-exam-question-and-answers-updated-2025-flash-cards/?new 1/35
,6/16/25, 8:40 AM MISY 5325 MS Excel Midterm Exam Study Guide ACTUAL exam: QUESTION AND ANSWERS UPDATED 2025 Flashcards | Quizlet
Comma, Date, Time, and True
Fraction are all number
formats available in Excel
2013.
Click Format in the Cells Home
group o the __ tab to
change the color of a
worksheet tab.
Formatting data makes it False
difficult to read and tends
to obscure meaningful
details.
In Excel 2013, it is only False
possible to add a new
worksheet when the
workbook is created.
Excel data can be copied True
and pasted into a Word or
PowerPoint document.
A Special number format True
allows characters such as
hyphens.
The Date number format False
only allows Long Date, for
example, march 14, 2016.
An argument is an False
operator such as an equal
sign or a plus sign needed
to complete a function.
A range name cannot spaces
include special characters
or __
https://quizlet.com/1054641438/misy-5325-ms-excel-midterm-exam-study-guide-actual-exam-question-and-answers-updated-2025-flash-cards/?new 2/35
,6/16/25, 8:40 AM MISY 5325 MS Excel Midterm Exam Study Guide ACTUAL exam: QUESTION AND ANSWERS UPDATED 2025 Flashcards | Quizlet
Which of the following is a Quick Analysis
new feature in Excel 2013?
Formula ___ displays a list AutoComplete
of functions and defined
name that match the
letters that you start
typing when creating a
formula.
Which of the following is Functions are organized into two categories in Excel.
False about a function in
Excel
The IF function only False
evaluates a condition of
the condition is true.
Because the Sum function False
is a rarely used function it
has no button on the
Ribbon.
An absolute cell indicates a cell's specific location and the reference
reference: does not change when you copy the formula.
The lookup value: is a reference to a cell containing a value to look up.
The __ function finds the Median
midpoint value of a list.
evaluates a condition and returns one value if the
The IF function:
condition is true, a different if false.
is a word or string of characters tat represent one or
A range name:
more cells.
The IF function in Excel three
2013 has __ arguments.
contains another function embedded inside one or
A nested function:
more of its arguments.
https://quizlet.com/1054641438/misy-5325-ms-excel-midterm-exam-study-guide-actual-exam-question-and-answers-updated-2025-flash-cards/?new 3/35
, 6/16/25, 8:40 AM MISY 5325 MS Excel Midterm Exam Study Guide ACTUAL exam: QUESTION AND ANSWERS UPDATED 2025 Flashcards | Quizlet
A range name contain up False
to 450 characters and it
must begin with a number.
Match the argument types =SUM
to their function: =TODAY
(Number1) =IF
() =VLOOKUP
(logical_test) =PMT
(....,table_array,...)
(rate,..,...)
In Excel 2013, the function True
name describes the
purpose of the function.
A chart sheet: contains a single chart and no spreadsheet data.
Gridlines on a chart in horizontal and vertical line that span across the chart
Excel 2013 are:
compares groups set side Clustered column chart
by side Stacked column chart
relationship of individual
data points to the whole
A(n) __ is a grid that data table
contains the data source
values and labels.
shows each data point in proportion to the whole
A pie chart
data series as a slice in a circular pie.
places stacks of data in segments on top of each
A stacked column chart: other in one column, with each category in the data
series represented by a different color.
A chart is: a visual depiction of numerical data
A chart__ controls which filter
data series and categories
are visible in a chart.
https://quizlet.com/1054641438/misy-5325-ms-excel-midterm-exam-study-guide-actual-exam-question-and-answers-updated-2025-flash-cards/?new 4/35
MISY 5325 MS Excel Midterm Exam Study Guide
ACTUAL exam: QUESTION AND ANSWERS
UPDATED 2025
Save
Terms in this set (362)
Which of the following is Date Format
Not a number format
available in the Number
group on the Home tab?
To begin a formula in a False
cell, first type the #
symbol.
When you hide a column True
or row, the data is not
deleted, it is just hidden.
Text in a cell can by angle True
clockwise
The ___ command is helpful Go to
for navigating to a cell that
is not visible onscreen
The ___ view displays print Office Backstage
options and displays a
worksheet in print preview
https://quizlet.com/1054641438/misy-5325-ms-excel-midterm-exam-study-guide-actual-exam-question-and-answers-updated-2025-flash-cards/?new 1/35
,6/16/25, 8:40 AM MISY 5325 MS Excel Midterm Exam Study Guide ACTUAL exam: QUESTION AND ANSWERS UPDATED 2025 Flashcards | Quizlet
Comma, Date, Time, and True
Fraction are all number
formats available in Excel
2013.
Click Format in the Cells Home
group o the __ tab to
change the color of a
worksheet tab.
Formatting data makes it False
difficult to read and tends
to obscure meaningful
details.
In Excel 2013, it is only False
possible to add a new
worksheet when the
workbook is created.
Excel data can be copied True
and pasted into a Word or
PowerPoint document.
A Special number format True
allows characters such as
hyphens.
The Date number format False
only allows Long Date, for
example, march 14, 2016.
An argument is an False
operator such as an equal
sign or a plus sign needed
to complete a function.
A range name cannot spaces
include special characters
or __
https://quizlet.com/1054641438/misy-5325-ms-excel-midterm-exam-study-guide-actual-exam-question-and-answers-updated-2025-flash-cards/?new 2/35
,6/16/25, 8:40 AM MISY 5325 MS Excel Midterm Exam Study Guide ACTUAL exam: QUESTION AND ANSWERS UPDATED 2025 Flashcards | Quizlet
Which of the following is a Quick Analysis
new feature in Excel 2013?
Formula ___ displays a list AutoComplete
of functions and defined
name that match the
letters that you start
typing when creating a
formula.
Which of the following is Functions are organized into two categories in Excel.
False about a function in
Excel
The IF function only False
evaluates a condition of
the condition is true.
Because the Sum function False
is a rarely used function it
has no button on the
Ribbon.
An absolute cell indicates a cell's specific location and the reference
reference: does not change when you copy the formula.
The lookup value: is a reference to a cell containing a value to look up.
The __ function finds the Median
midpoint value of a list.
evaluates a condition and returns one value if the
The IF function:
condition is true, a different if false.
is a word or string of characters tat represent one or
A range name:
more cells.
The IF function in Excel three
2013 has __ arguments.
contains another function embedded inside one or
A nested function:
more of its arguments.
https://quizlet.com/1054641438/misy-5325-ms-excel-midterm-exam-study-guide-actual-exam-question-and-answers-updated-2025-flash-cards/?new 3/35
, 6/16/25, 8:40 AM MISY 5325 MS Excel Midterm Exam Study Guide ACTUAL exam: QUESTION AND ANSWERS UPDATED 2025 Flashcards | Quizlet
A range name contain up False
to 450 characters and it
must begin with a number.
Match the argument types =SUM
to their function: =TODAY
(Number1) =IF
() =VLOOKUP
(logical_test) =PMT
(....,table_array,...)
(rate,..,...)
In Excel 2013, the function True
name describes the
purpose of the function.
A chart sheet: contains a single chart and no spreadsheet data.
Gridlines on a chart in horizontal and vertical line that span across the chart
Excel 2013 are:
compares groups set side Clustered column chart
by side Stacked column chart
relationship of individual
data points to the whole
A(n) __ is a grid that data table
contains the data source
values and labels.
shows each data point in proportion to the whole
A pie chart
data series as a slice in a circular pie.
places stacks of data in segments on top of each
A stacked column chart: other in one column, with each category in the data
series represented by a different color.
A chart is: a visual depiction of numerical data
A chart__ controls which filter
data series and categories
are visible in a chart.
https://quizlet.com/1054641438/misy-5325-ms-excel-midterm-exam-study-guide-actual-exam-question-and-answers-updated-2025-flash-cards/?new 4/35
