MISY 5325 MS Excel Midterm Exam
2026 Questions and Answers 100% Pass
Guaranteed
Which of the following is Not a number format available in the Number group on
the Home tab? - Correct answer-Date Format
To begin a formula in a cell, first type the # symbol. - Correct answer-False
When you hide a column or row, the data is not deleted, it is just hidden. - Correct
answer-True
Text in a cell can by angle clockwise - Correct answer-True
The ___ command is helpful for navigating to a cell that is not visible onscreen -
Correct answer-Go to
The ___ view displays print options and displays a worksheet in print preview -
Correct answer-Office Backstage
Comma, Date, Time, and Fraction are all number formats available in Excel 2013.
- Correct answer-True
©COPYRIGHT 2025, ALL RIGHTS RESERVE 1
,Click Format in the Cells group o the __ tab to change the color of a worksheet tab.
- Correct answer-Home
Formatting data makes it difficult to read and tends to obscure meaningful details. -
Correct answer-False
In Excel 2013, it is only possible to add a new worksheet when the workbook is
created. - Correct answer-False
Excel data can be copied and pasted into a Word or PowerPoint document. -
Correct answer-True
A Special number format allows characters such as hyphens. - Correct answer-True
The Date number format only allows Long Date, for example, march 14, 2016. -
Correct answer-False
An argument is an operator such as an equal sign or a plus sign needed to complete
a function. - Correct answer-False
A range name cannot include special characters or __ - Correct answer-spaces
Which of the following is a new feature in Excel 2013? - Correct answer-Quick
Analysis
Formula ___ displays a list of functions and defined name that match the letters
that you start typing when creating a formula. - Correct answer-AutoComplete
©COPYRIGHT 2025, ALL RIGHTS RESERVE 2
,Which of the following is False about a function in Excel - Correct answer-
Functions are organized into two categories in Excel.
The IF function only evaluates a condition of the condition is true. - Correct
answer-False
Because the Sum function is a rarely used function it has no button on the Ribbon.
- Correct answer-False
An absolute cell reference: - Correct answer-indicates a cell's specific location and
the reference does not change when you copy the formula.
The lookup value: - Correct answer-is a reference to a cell containing a value to
look up.
The __ function finds the midpoint value of a list. - Correct answer-Median
The IF function: - Correct answer-evaluates a condition and returns one value if the
condition is true, a different if false.
A range name: - Correct answer-is a word or string of characters tat represent one
or more cells.
The IF function in Excel 2013 has __ arguments. - Correct answer-three
A nested function: - Correct answer-contains another function embedded inside one
or more of its arguments.
©COPYRIGHT 2025, ALL RIGHTS RESERVE 3
, A range name contain up to 450 characters and it must begin with a number. -
Correct answer-False
Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
(rate,..,...) - Correct answer-=SUM
=TODAY
=IF
=VLOOKUP
=PMT
In Excel 2013, the function name describes the purpose of the function. - Correct
answer-True
A chart sheet: - Correct answer-contains a single chart and no spreadsheet data.
Gridlines on a chart in Excel 2013 are: - Correct answer-horizontal and vertical
line that span across the chart
©COPYRIGHT 2025, ALL RIGHTS RESERVE 4
2026 Questions and Answers 100% Pass
Guaranteed
Which of the following is Not a number format available in the Number group on
the Home tab? - Correct answer-Date Format
To begin a formula in a cell, first type the # symbol. - Correct answer-False
When you hide a column or row, the data is not deleted, it is just hidden. - Correct
answer-True
Text in a cell can by angle clockwise - Correct answer-True
The ___ command is helpful for navigating to a cell that is not visible onscreen -
Correct answer-Go to
The ___ view displays print options and displays a worksheet in print preview -
Correct answer-Office Backstage
Comma, Date, Time, and Fraction are all number formats available in Excel 2013.
- Correct answer-True
©COPYRIGHT 2025, ALL RIGHTS RESERVE 1
,Click Format in the Cells group o the __ tab to change the color of a worksheet tab.
- Correct answer-Home
Formatting data makes it difficult to read and tends to obscure meaningful details. -
Correct answer-False
In Excel 2013, it is only possible to add a new worksheet when the workbook is
created. - Correct answer-False
Excel data can be copied and pasted into a Word or PowerPoint document. -
Correct answer-True
A Special number format allows characters such as hyphens. - Correct answer-True
The Date number format only allows Long Date, for example, march 14, 2016. -
Correct answer-False
An argument is an operator such as an equal sign or a plus sign needed to complete
a function. - Correct answer-False
A range name cannot include special characters or __ - Correct answer-spaces
Which of the following is a new feature in Excel 2013? - Correct answer-Quick
Analysis
Formula ___ displays a list of functions and defined name that match the letters
that you start typing when creating a formula. - Correct answer-AutoComplete
©COPYRIGHT 2025, ALL RIGHTS RESERVE 2
,Which of the following is False about a function in Excel - Correct answer-
Functions are organized into two categories in Excel.
The IF function only evaluates a condition of the condition is true. - Correct
answer-False
Because the Sum function is a rarely used function it has no button on the Ribbon.
- Correct answer-False
An absolute cell reference: - Correct answer-indicates a cell's specific location and
the reference does not change when you copy the formula.
The lookup value: - Correct answer-is a reference to a cell containing a value to
look up.
The __ function finds the midpoint value of a list. - Correct answer-Median
The IF function: - Correct answer-evaluates a condition and returns one value if the
condition is true, a different if false.
A range name: - Correct answer-is a word or string of characters tat represent one
or more cells.
The IF function in Excel 2013 has __ arguments. - Correct answer-three
A nested function: - Correct answer-contains another function embedded inside one
or more of its arguments.
©COPYRIGHT 2025, ALL RIGHTS RESERVE 3
, A range name contain up to 450 characters and it must begin with a number. -
Correct answer-False
Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
(rate,..,...) - Correct answer-=SUM
=TODAY
=IF
=VLOOKUP
=PMT
In Excel 2013, the function name describes the purpose of the function. - Correct
answer-True
A chart sheet: - Correct answer-contains a single chart and no spreadsheet data.
Gridlines on a chart in Excel 2013 are: - Correct answer-horizontal and vertical
line that span across the chart
©COPYRIGHT 2025, ALL RIGHTS RESERVE 4
