MISY 5325 MS Excel Midterm Exam |2026 ACTUAL
EXAM QUESTIONS AND VERIFIED ANSWERS
/GET IT 100% ACCURATE|ALREADY GRADED A+
Save
Terms in this set (362)
Which of the following is Not a Date Format
number format available in the
Number group on the Home tab?
To begin a formula in a cell, first type False
the # symbol.
When you hide a column or row, the True
data is not deleted, it is just hidden.
Text in a cell can by angle clockwise True
The ___ command is helpful for Go to
navigating to a cell that is not visible
onscreen
The ___ view displays print options Office Backstage
and displays a worksheet in print
preview
,Comma, Date, Time, and Fraction are True
all number formats available in Excel
2013.
Click Format in the Cells group o the Home
__ tab to change the color of a
worksheet tab.
Formatting data makes it difficult to False
read and tends to obscure
meaningful details.
In Excel 2013, it is only possible to False
add a new worksheet when the
workbook is created.
Excel data can be copied and True
pasted into a Word or PowerPoint
document.
A Special number format allows True
characters such as hyphens.
The Date number format only allows False
Long Date, for example, march 14,
2016.
An argument is an operator such as False
an equal sign or a plus sign needed
to complete a function.
A range name cannot include special spaces
characters or __
,Which of the following is a new Quick Analysis
feature in Excel 2013?
Formula ___ displays a list of functions AutoComplete
and defined name that match the
letters that you start typing when
creating a formula.
Which of the following is False about Functions are organized into two categories in
a function in Excel Excel.
The IF function only evaluates a False
condition of the condition is true.
Because the Sum function is a rarely False
used function it has no button on the
Ribbon.
An absolute cell reference: indicates a cell's specific location and the 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 midpoint Median
value of a list.
The IF function: evaluates a condition and returns one value if the
condition is true, a different if false.
A range name: is a word or string of characters tat represent one
or more cells.
, The IF function in Excel 2013 has __ three
arguments.
A nested function: contains another function embedded inside one or
more of its arguments.
A range name contain up to 450 False
characters and it must begin with a
number.
Match the argument types to their =SUM
function: =TODAY
(Number1) =IF
() =VLOOKUP
(logical_test) =PMT
(....,table_array,...)
(rate,..,...)
In Excel 2013, the function name True
describes the purpose of the
function.
A chart sheet: contains a single chart and no spreadsheet data.
Gridlines on a chart in Excel 2013 are: horizontal and vertical line that span across the
chart
compares groups set side by side Clustered column chart
relationship of individual data points Stacked column chart
to the whole
A(n) __ is a grid that contains the data data table
source values and labels.
EXAM QUESTIONS AND VERIFIED ANSWERS
/GET IT 100% ACCURATE|ALREADY GRADED A+
Save
Terms in this set (362)
Which of the following is Not a Date Format
number format available in the
Number group on the Home tab?
To begin a formula in a cell, first type False
the # symbol.
When you hide a column or row, the True
data is not deleted, it is just hidden.
Text in a cell can by angle clockwise True
The ___ command is helpful for Go to
navigating to a cell that is not visible
onscreen
The ___ view displays print options Office Backstage
and displays a worksheet in print
preview
,Comma, Date, Time, and Fraction are True
all number formats available in Excel
2013.
Click Format in the Cells group o the Home
__ tab to change the color of a
worksheet tab.
Formatting data makes it difficult to False
read and tends to obscure
meaningful details.
In Excel 2013, it is only possible to False
add a new worksheet when the
workbook is created.
Excel data can be copied and True
pasted into a Word or PowerPoint
document.
A Special number format allows True
characters such as hyphens.
The Date number format only allows False
Long Date, for example, march 14,
2016.
An argument is an operator such as False
an equal sign or a plus sign needed
to complete a function.
A range name cannot include special spaces
characters or __
,Which of the following is a new Quick Analysis
feature in Excel 2013?
Formula ___ displays a list of functions AutoComplete
and defined name that match the
letters that you start typing when
creating a formula.
Which of the following is False about Functions are organized into two categories in
a function in Excel Excel.
The IF function only evaluates a False
condition of the condition is true.
Because the Sum function is a rarely False
used function it has no button on the
Ribbon.
An absolute cell reference: indicates a cell's specific location and the 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 midpoint Median
value of a list.
The IF function: evaluates a condition and returns one value if the
condition is true, a different if false.
A range name: is a word or string of characters tat represent one
or more cells.
, The IF function in Excel 2013 has __ three
arguments.
A nested function: contains another function embedded inside one or
more of its arguments.
A range name contain up to 450 False
characters and it must begin with a
number.
Match the argument types to their =SUM
function: =TODAY
(Number1) =IF
() =VLOOKUP
(logical_test) =PMT
(....,table_array,...)
(rate,..,...)
In Excel 2013, the function name True
describes the purpose of the
function.
A chart sheet: contains a single chart and no spreadsheet data.
Gridlines on a chart in Excel 2013 are: horizontal and vertical line that span across the
chart
compares groups set side by side Clustered column chart
relationship of individual data points Stacked column chart
to the whole
A(n) __ is a grid that contains the data data table
source values and labels.
