MISY 5325 MS EXCEL MIDTERM EXAM SET |ACCURATE ANSWERS |COMPLETE

MISY 5325 MS EXCEL MIDTERM
EXAM SET |ACCURATE ANSWERS |
COMPLETE

Which of the following is Not a number format available in the Number
group on the Home tab? - ACCURATE ANSWERS✔✔ Date Format


To begin a formula in a cell, first type the # symbol. - ACCURATE
ANSWERS✔✔ False


When you hide a column or row, the data is not deleted, it is just hidden.
- ACCURATE ANSWERS✔✔ True


Text in a cell can by angle clockwise - ACCURATE ANSWERS✔✔
True


The ___ command is helpful for navigating to a cell that is not visible
onscreen - ACCURATE ANSWERS✔✔ Go to


The ___ view displays print options and displays a worksheet in print
preview - ACCURATE ANSWERS✔✔ Office Backstage


Comma, Date, Time, and Fraction are all number formats available in
Excel 2013. - ACCURATE ANSWERS✔✔ True

,Click Format in the Cells group o the __ tab to change the color of a
worksheet tab. - ACCURATE ANSWERS✔✔ Home


Formatting data makes it difficult to read and tends to obscure
meaningful details. - ACCURATE ANSWERS✔✔ False


In Excel 2013, it is only possible to add a new worksheet when the
workbook is created. - ACCURATE ANSWERS✔✔ False


Excel data can be copied and pasted into a Word or PowerPoint
document. - ACCURATE ANSWERS✔✔ True


A Special number format allows characters such as hyphens. -
ACCURATE ANSWERS✔✔ True


The Date number format only allows Long Date, for example, march 14,
2016. - ACCURATE ANSWERS✔✔ False


An argument is an operator such as an equal sign or a plus sign needed
to complete a function. - ACCURATE ANSWERS✔✔ False


A range name cannot include special characters or __ - ACCURATE
ANSWERS✔✔ spaces


Which of the following is a new feature in Excel 2013? - ACCURATE
ANSWERS✔✔ Quick Analysis

,Formula ___ displays a list of functions and defined name that match the
letters that you start typing when creating a formula. - ACCURATE
ANSWERS✔✔ AutoComplete


Which of the following is False about a function in Excel - ACCURATE
ANSWERS✔✔ Functions are organized into two categories in Excel.


The IF function only evaluates a condition of the condition is true. -
ACCURATE ANSWERS✔✔ False


Because the Sum function is a rarely used function it has no button on
the Ribbon. - ACCURATE ANSWERS✔✔ False


An absolute cell reference: - ACCURATE ANSWERS✔✔ indicates a
cell's specific location and the reference does not change when you copy
the formula.


The lookup value: - ACCURATE ANSWERS✔✔ is a reference to a cell
containing a value to look up.


The __ function finds the midpoint value of a list. - ACCURATE
ANSWERS✔✔ Median


The IF function: - ACCURATE ANSWERS✔✔ evaluates a condition
and returns one value if the condition is true, a different if false.

, A range name: - ACCURATE ANSWERS✔✔ is a word or string of
characters tat represent one or more cells.


The IF function in Excel 2013 has __ arguments. - ACCURATE
ANSWERS✔✔ three


A nested function: - ACCURATE ANSWERS✔✔ 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. - ACCURATE ANSWERS✔✔ False


Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
(rate,..,...) - ACCURATE ANSWERS✔✔ =SUM
=TODAY
=IF
=VLOOKUP
=PMT