MISY 5325 MS EXCEL MIDTERM EXAM
STUDY GUIDE 2026 COMPREHENSIVE
STUDY GUIDE 2026 QUESTIONS WITH
VERIFIED ANSWERS GRADED A+
⩥ 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
⩥ 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
⩥ Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
(rate,..,...) Answer: =SUM
=TODAY
=IF
=VLOOKUP
=PMT
STUDY GUIDE 2026 COMPREHENSIVE
STUDY GUIDE 2026 QUESTIONS WITH
VERIFIED ANSWERS GRADED A+
⩥ 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
⩥ 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
⩥ Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
(rate,..,...) Answer: =SUM
=TODAY
=IF
=VLOOKUP
=PMT
