MISY 5325 MS Excel Midterm Exam Questions With Complete Solution | Latest 2024/2025 (100% CORRECT)
Which of the following is Not a number format
... [Show More] 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
MISY 5325 MS Excel Midterm Exam
Questions With Complete Solution | Latest
2024/2025 (100% CORRECT)
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. [Show Less]
