MISY 5325 MS Excel Midterm Exam Study Guide|2024-2025 UPDATE|COMPREHENSIVE FREQUENTLY A+
Which of the following is Not a number
format available in the Number group
on the Home tab?
Date Format
2.
To begin a formula
...
MISY 5325 MS Excel Midterm Exam Study Guide|2024-2025 UPDATE|COMPREHENSIVE FREQUENTLY A+
Which of the following is Not a number
format available in the Number group
on the Home tab?
Date Format
2.
To begin a formula in a cell, first type the
# symbol.
False
3.
When you hide a column or row, the
data is not deleted, it is just hidden.
True
4.
Text in a cell can by angle clockwise
True
5.
The ___ command is helpful for navigat
ing to a cell that is not visible onscreen
Go to
6.
The ___ view displays print options and
displays a worksheet in print preview
Office Backstage
7.
Comma, Date, Time, and Fraction are all
number formats available in Excel 2013.
True
8.
Click Format in the Cells group o the __
tab to change the color of a worksheet
tab.
Home
9.
Formatting data makes it difficult to
read and tends to obscure meaningful
details.
False
10. In Excel 2013, it is only possible to add
a new worksheet when the workbook is
created.
False
11. Excel data can be copied and pasted
into a Word or PowerPoint document.
True
12. A Special number format allows charac
ters such as hyphens.
True
1 / 44
2024 Newest|MISY 5325 MS Excel Midterm Exam Study Guide|2024-2025
UPDATE|COMPREHENSIVE FREQUENTLY MOST TESTED QUESTIONS
AND VERIFIED ANSWERS|GET IT 100% ACCURATE!!
Study online at https://quizlet.com/_g1dxer
13. The Date number format only allows
Long Date, for example, march 14, 2016.
False
14. An argument is an operator such as
an equal sign or a plus sign needed to
complete a function.
False
15. A range name cannot include special
characters or __
spaces
16. Which of the following is a new feature
in Excel 2013?
Quick Analysis
17. Formula ___ displays a list of functions
and defined name that match the letters
that you start typing when creating a
formula.
AutoComplete
18. Which of the following is False about a
function in Excel
Functions are organized into two
categories in Excel.
19. The IF function only evaluates a condi
tion of the condition is true.
False
20. Because the Sum function is a rarely
used function it has no button on the
Ribbon.
False
21. An absolute cell reference:
indicates a cell's specific loca
tion and the reference does not
change when you copy the for
mula.
22. The lookup value:
is a reference to a cell containing
a value to look up.
23. The __ function finds the midpoint val
ue of a list.
Median
[Show More]