MISY 5325 MS Excel Midterm Exam
Questions and Guide Answers
100% Verified Graded A+
1. Which of the following is Not a number format available in the Number
group on the Home tab?
Answer: Date Format
2. To begin a formula in a cell, first type the # symbol.
Answer: False
3. When you hide a column or row, the data is not deleted, it is just hidden.
Answer: True
4. Text in a cell can by angle clockwise
Answer: True
5. The command is helpful for navigating to a cell that is not visible on-
screen
,Answer: Go to
6. The view displays print options and displays a worksheet in print preview-
Answer: Oflce Backstage
7. Comma, Date, Time, and Fraction are all number formats available in Excel
2013.
Answer: True
8. Click Format in the Cells group o the tab to change the color of a work-
sheet tab.
Answer: Home
9. Formatting data makes it difficult to read and tends to obscure meaningful
details.
Answer: False
10. In Excel 2013, it is only possible to add a new worksheet when the workbook
is created.
Answer: False
11. Excel data can be copied and pasted into a Word or PowerPoint document.-
,Answer: True
12. A Special number format allows characters such as hyphens.
Answer: True
13. The Date number format only allows Long Date, for example, march 14,
2016.
Answer: False
14. An argument is an operator such as an equal sign or a plus sign needed to
complete a function.
Answer: False
15. A range name cannot include special characters or
Answer: spaces
16. Which of the following is a new feature in Excel 2013?
Answer: Quick Analysis
17. Formula displays a list of functions and defined name that match the
letters that you start typing when creating a formula.
Answer: AutoComplete
18. Which of the following is False about a function in Excel
Answer: Functions are organized into two categories in Excel.
, 19. The IF function only evaluates a condition of the condition is true.
Answer: False
20. Because the Sum function is a rarely used function it has no button on the
Ribbon.
Answer: False
21. An absolute cell reference
Answer: indicates a cell's specific location and the reference does not change when you copy the
formula.
22. The lookup value
Answer: is a reference to a cell containing a value to look up.
23. The function finds the midpoint value of a list.
Answer: Median
24. The IF function
Answer: evaluates a condition and returns one value if the condition is true, a ditterent if false.
25. A range name
Answer: is a word or string of characters tat represent one or more cells.
26. The IF function in Excel 2013 has arguments.
Answer: three
Questions and Guide Answers
100% Verified Graded A+
1. Which of the following is Not a number format available in the Number
group on the Home tab?
Answer: Date Format
2. To begin a formula in a cell, first type the # symbol.
Answer: False
3. When you hide a column or row, the data is not deleted, it is just hidden.
Answer: True
4. Text in a cell can by angle clockwise
Answer: True
5. The command is helpful for navigating to a cell that is not visible on-
screen
,Answer: Go to
6. The view displays print options and displays a worksheet in print preview-
Answer: Oflce Backstage
7. Comma, Date, Time, and Fraction are all number formats available in Excel
2013.
Answer: True
8. Click Format in the Cells group o the tab to change the color of a work-
sheet tab.
Answer: Home
9. Formatting data makes it difficult to read and tends to obscure meaningful
details.
Answer: False
10. In Excel 2013, it is only possible to add a new worksheet when the workbook
is created.
Answer: False
11. Excel data can be copied and pasted into a Word or PowerPoint document.-
,Answer: True
12. A Special number format allows characters such as hyphens.
Answer: True
13. The Date number format only allows Long Date, for example, march 14,
2016.
Answer: False
14. An argument is an operator such as an equal sign or a plus sign needed to
complete a function.
Answer: False
15. A range name cannot include special characters or
Answer: spaces
16. Which of the following is a new feature in Excel 2013?
Answer: Quick Analysis
17. Formula displays a list of functions and defined name that match the
letters that you start typing when creating a formula.
Answer: AutoComplete
18. Which of the following is False about a function in Excel
Answer: Functions are organized into two categories in Excel.
, 19. The IF function only evaluates a condition of the condition is true.
Answer: False
20. Because the Sum function is a rarely used function it has no button on the
Ribbon.
Answer: False
21. An absolute cell reference
Answer: indicates a cell's specific location and the reference does not change when you copy the
formula.
22. The lookup value
Answer: is a reference to a cell containing a value to look up.
23. The function finds the midpoint value of a list.
Answer: Median
24. The IF function
Answer: evaluates a condition and returns one value if the condition is true, a ditterent if false.
25. A range name
Answer: is a word or string of characters tat represent one or more cells.
26. The IF function in Excel 2013 has arguments.
Answer: three
