MISY 5325 MS Excel Midterm
Exam |2026 ACTUAL EXAM
QUESTIONS AND VERIFIED
ANSWERS /GET IT 100%
ACCURATE|ALREADY GRADED
A+
Which of the following is Not a number format available in the Number
group on the Home tab? - 🧠 ANSWER ✔✔Date Format
To begin a formula in a cell, first type the # symbol. - 🧠 ANSWER ✔✔False
,When you hide a column or row, the data is not deleted, it is just hidden. - 🧠
ANSWER ✔✔True
Text in a cell can by angle clockwise - 🧠 ANSWER ✔✔True
The ___ command is helpful for navigating to a cell that is not visible
onscreen - 🧠 ANSWER ✔✔Go to
The ___ view displays print options and displays a worksheet in print
preview - 🧠 ANSWER ✔✔Office Backstage
Comma, Date, Time, and Fraction are all number formats available in Excel
2013. - 🧠 ANSWER ✔✔True
Click Format in the Cells group o the __ tab to change the color of a
worksheet tab. - 🧠 ANSWER ✔✔Home
Formatting data makes it difficult to read and tends to obscure meaningful
details. - 🧠 ANSWER ✔✔False
In Excel 2013, it is only possible to add a new worksheet when the
workbook is created. - 🧠 ANSWER ✔✔False
Excel data can be copied and pasted into a Word or PowerPoint document.
- 🧠 ANSWER ✔✔True
,A Special number format allows characters such as hyphens. - 🧠 ANSWER
✔✔True
The Date number format only allows Long Date, for example, march 14,
2016. - 🧠 ANSWER ✔✔False
An argument is an operator such as an equal sign or a plus sign needed to
complete a function. - 🧠 ANSWER ✔✔False
A range name cannot include special characters or __ - 🧠 ANSWER
✔✔spaces
Which of the following is a new feature in Excel 2013? - 🧠 ANSWER
✔✔Quick Analysis
Formula ___ displays a list of functions and defined name that match the
letters that you start typing when creating a formula. - 🧠 ANSWER
✔✔AutoComplete
Which of the following is False about a function in Excel - 🧠 ANSWER
✔✔Functions are organized into two categories in Excel.
The IF function only evaluates a condition of the condition is true. - 🧠
ANSWER ✔✔False
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2026. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, Because the Sum function is a rarely used function it has no button on the
Ribbon. - 🧠 ANSWER ✔✔False
An absolute cell reference: - 🧠 ANSWER ✔✔indicates a cell's specific
location and the reference does not change when you copy the formula.
The lookup value: - 🧠 ANSWER ✔✔is a reference to a cell containing a
value to look up.
The __ function finds the midpoint value of a list. - 🧠 ANSWER ✔✔Median
The IF function: - 🧠 ANSWER ✔✔evaluates a condition and returns one
value if the condition is true, a different if false.
A range name: - 🧠 ANSWER ✔✔is a word or string of characters tat
represent one or more cells.
The IF function in Excel 2013 has __ arguments. - 🧠 ANSWER ✔✔three
A nested function: - 🧠 ANSWER ✔✔contains another function embedded
inside one or more of its arguments.
A range name contain up to 450 characters and it must begin with a
number. - 🧠 ANSWER ✔✔False
Exam |2026 ACTUAL EXAM
QUESTIONS AND VERIFIED
ANSWERS /GET IT 100%
ACCURATE|ALREADY GRADED
A+
Which of the following is Not a number format available in the Number
group on the Home tab? - 🧠 ANSWER ✔✔Date Format
To begin a formula in a cell, first type the # symbol. - 🧠 ANSWER ✔✔False
,When you hide a column or row, the data is not deleted, it is just hidden. - 🧠
ANSWER ✔✔True
Text in a cell can by angle clockwise - 🧠 ANSWER ✔✔True
The ___ command is helpful for navigating to a cell that is not visible
onscreen - 🧠 ANSWER ✔✔Go to
The ___ view displays print options and displays a worksheet in print
preview - 🧠 ANSWER ✔✔Office Backstage
Comma, Date, Time, and Fraction are all number formats available in Excel
2013. - 🧠 ANSWER ✔✔True
Click Format in the Cells group o the __ tab to change the color of a
worksheet tab. - 🧠 ANSWER ✔✔Home
Formatting data makes it difficult to read and tends to obscure meaningful
details. - 🧠 ANSWER ✔✔False
In Excel 2013, it is only possible to add a new worksheet when the
workbook is created. - 🧠 ANSWER ✔✔False
Excel data can be copied and pasted into a Word or PowerPoint document.
- 🧠 ANSWER ✔✔True
,A Special number format allows characters such as hyphens. - 🧠 ANSWER
✔✔True
The Date number format only allows Long Date, for example, march 14,
2016. - 🧠 ANSWER ✔✔False
An argument is an operator such as an equal sign or a plus sign needed to
complete a function. - 🧠 ANSWER ✔✔False
A range name cannot include special characters or __ - 🧠 ANSWER
✔✔spaces
Which of the following is a new feature in Excel 2013? - 🧠 ANSWER
✔✔Quick Analysis
Formula ___ displays a list of functions and defined name that match the
letters that you start typing when creating a formula. - 🧠 ANSWER
✔✔AutoComplete
Which of the following is False about a function in Excel - 🧠 ANSWER
✔✔Functions are organized into two categories in Excel.
The IF function only evaluates a condition of the condition is true. - 🧠
ANSWER ✔✔False
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2026. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, Because the Sum function is a rarely used function it has no button on the
Ribbon. - 🧠 ANSWER ✔✔False
An absolute cell reference: - 🧠 ANSWER ✔✔indicates a cell's specific
location and the reference does not change when you copy the formula.
The lookup value: - 🧠 ANSWER ✔✔is a reference to a cell containing a
value to look up.
The __ function finds the midpoint value of a list. - 🧠 ANSWER ✔✔Median
The IF function: - 🧠 ANSWER ✔✔evaluates a condition and returns one
value if the condition is true, a different if false.
A range name: - 🧠 ANSWER ✔✔is a word or string of characters tat
represent one or more cells.
The IF function in Excel 2013 has __ arguments. - 🧠 ANSWER ✔✔three
A nested function: - 🧠 ANSWER ✔✔contains another function embedded
inside one or more of its arguments.
A range name contain up to 450 characters and it must begin with a
number. - 🧠 ANSWER ✔✔False
