2024 Newest|MISY 5325 MS Excel Midterm Exam Study Guide|2024-202
UPDATE|COMPREHENSIVE FREQUENTLY MOST TESTED QUESTIONS
AND VERIFIED ANSWERS|GET IT 100% ACCURATE!!
Study online at https://quizlet.com/_g1dxer
1. Which of the following is Not a number Date Format
format available in the Number group
on the Home tab?
2. To begin a formula in a cell, first type the False
# symbol.
3. When you hide a column or row, the True
data is not deleted, it is just hidden.
4. Text in a cell can by angle clockwise True
5. The ___ command is helpful for navigat- Go to
ing to a cell that is not visible onscreen
6. The ___ view displays print options and Office Backstage
displays a worksheet in print preview
7. Comma, Date, Time, and Fraction are all True
number formats available in Excel 2013.
8. Click Format in the Cells group o the __ Home
tab to change the color of a worksheet
tab.
9. Formatting data makes it difficult to False
read and tends to obscure meaningful
details.
10. In Excel 2013, it is only possible to add False
a new worksheet when the workbook is
created.
11. Excel data can be copied and pasted True
into a Word or PowerPoint document.
12. A Special number format allows charac- True
ters such as hyphens.
, 2024 Newest|MISY 5325 MS Excel Midterm Exam Study Guide|2024-202
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 False
Long Date, for example, march 14, 2016.
14. An argument is an operator such as False
an equal sign or a plus sign needed to
complete a function.
15. A range name cannot include special spaces
characters or __
16. Which of the following is a new feature Quick Analysis
in Excel 2013?
17. Formula ___ displays a list of functions AutoComplete
and defined name that match the letters
that you start typing when creating a
formula.
18. Which of the following is False about a Functions are organized into two
function in Excel categories in Excel.
19. The IF function only evaluates a condi- False
tion of the condition is true.
20. Because the Sum function is a rarely False
used function it has no button on the
Ribbon.
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- Median
ue of a list.
, 2024 Newest|MISY 5325 MS Excel Midterm Exam Study Guide|2024-202
UPDATE|COMPREHENSIVE FREQUENTLY MOST TESTED QUESTIONS
AND VERIFIED ANSWERS|GET IT 100% ACCURATE!!
Study online at https://quizlet.com/_g1dxer
24. The IF function: evaluates a condition and returns
one value if the condition is true,
a different if false.
25. A range name: is a word or string of characters
tat represent one or more cells.
26. The IF function in Excel 2013 has __ three
arguments.
27. A nested function: contains another function em-
bedded inside one or more of its
arguments.
28. A range name contain up to 450 charac- False
ters and it must begin with a number.
29. Match the argument types to their func- =SUM
tion: =TODAY
(Number1) =IF
() =VLOOKUP
(logical_test) =PMT
(....,table_array,...)
(rate,..,...)
30. In Excel 2013, the function name de- True
scribes the purpose of the function.
31. A chart sheet: contains a single chart and no
spreadsheet data.
32. Gridlines on a chart in Excel 2013 are: horizontal and vertical line that
span across the chart
33. compares groups set side by side Clustered column chart
relationship of individual data points to Stacked column chart
the whole
34. data table
, 2024 Newest|MISY 5325 MS Excel Midterm Exam Study Guide|2024-202
UPDATE|COMPREHENSIVE FREQUENTLY MOST TESTED QUESTIONS
AND VERIFIED ANSWERS|GET IT 100% ACCURATE!!
Study online at https://quizlet.com/_g1dxer
A(n) __ is a grid that contains the data
source values and labels.
35. A pie chart shows each data point in propor-
tion to the whole data series as a
slice in a circular pie.
36. A stacked column chart: places stacks of data in seg-
ments on top of each other in one
column, with each category in the
data series represented by a dif-
ferent color.
37. A chart is: a visual depiction of numerical
data
38. A chart__ controls which data series filter
and categories are visible in a chart.
39. Excel automatically determines the True
starting, incremental, and stopping val-
ues on a chart based on the data select-
ed.
40. Which of the following is NOT one of X Y chart
most commonly used chart types?
41. A(n) ___ chart is a derivative of a scatter bubble
chart in which both axes are value axes.
42. Excel 2013 automatically assigns a dif- False
ferent pattern to each column of a clus-
tered column chart.
43. To begin creating sparklines on a work- Insert
sheet, click the __ tab.
44. To print only a chart, select the chart, file
click the __ tab, and click Print.
UPDATE|COMPREHENSIVE FREQUENTLY MOST TESTED QUESTIONS
AND VERIFIED ANSWERS|GET IT 100% ACCURATE!!
Study online at https://quizlet.com/_g1dxer
1. Which of the following is Not a number Date Format
format available in the Number group
on the Home tab?
2. To begin a formula in a cell, first type the False
# symbol.
3. When you hide a column or row, the True
data is not deleted, it is just hidden.
4. Text in a cell can by angle clockwise True
5. The ___ command is helpful for navigat- Go to
ing to a cell that is not visible onscreen
6. The ___ view displays print options and Office Backstage
displays a worksheet in print preview
7. Comma, Date, Time, and Fraction are all True
number formats available in Excel 2013.
8. Click Format in the Cells group o the __ Home
tab to change the color of a worksheet
tab.
9. Formatting data makes it difficult to False
read and tends to obscure meaningful
details.
10. In Excel 2013, it is only possible to add False
a new worksheet when the workbook is
created.
11. Excel data can be copied and pasted True
into a Word or PowerPoint document.
12. A Special number format allows charac- True
ters such as hyphens.
, 2024 Newest|MISY 5325 MS Excel Midterm Exam Study Guide|2024-202
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 False
Long Date, for example, march 14, 2016.
14. An argument is an operator such as False
an equal sign or a plus sign needed to
complete a function.
15. A range name cannot include special spaces
characters or __
16. Which of the following is a new feature Quick Analysis
in Excel 2013?
17. Formula ___ displays a list of functions AutoComplete
and defined name that match the letters
that you start typing when creating a
formula.
18. Which of the following is False about a Functions are organized into two
function in Excel categories in Excel.
19. The IF function only evaluates a condi- False
tion of the condition is true.
20. Because the Sum function is a rarely False
used function it has no button on the
Ribbon.
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- Median
ue of a list.
, 2024 Newest|MISY 5325 MS Excel Midterm Exam Study Guide|2024-202
UPDATE|COMPREHENSIVE FREQUENTLY MOST TESTED QUESTIONS
AND VERIFIED ANSWERS|GET IT 100% ACCURATE!!
Study online at https://quizlet.com/_g1dxer
24. The IF function: evaluates a condition and returns
one value if the condition is true,
a different if false.
25. A range name: is a word or string of characters
tat represent one or more cells.
26. The IF function in Excel 2013 has __ three
arguments.
27. A nested function: contains another function em-
bedded inside one or more of its
arguments.
28. A range name contain up to 450 charac- False
ters and it must begin with a number.
29. Match the argument types to their func- =SUM
tion: =TODAY
(Number1) =IF
() =VLOOKUP
(logical_test) =PMT
(....,table_array,...)
(rate,..,...)
30. In Excel 2013, the function name de- True
scribes the purpose of the function.
31. A chart sheet: contains a single chart and no
spreadsheet data.
32. Gridlines on a chart in Excel 2013 are: horizontal and vertical line that
span across the chart
33. compares groups set side by side Clustered column chart
relationship of individual data points to Stacked column chart
the whole
34. data table
, 2024 Newest|MISY 5325 MS Excel Midterm Exam Study Guide|2024-202
UPDATE|COMPREHENSIVE FREQUENTLY MOST TESTED QUESTIONS
AND VERIFIED ANSWERS|GET IT 100% ACCURATE!!
Study online at https://quizlet.com/_g1dxer
A(n) __ is a grid that contains the data
source values and labels.
35. A pie chart shows each data point in propor-
tion to the whole data series as a
slice in a circular pie.
36. A stacked column chart: places stacks of data in seg-
ments on top of each other in one
column, with each category in the
data series represented by a dif-
ferent color.
37. A chart is: a visual depiction of numerical
data
38. A chart__ controls which data series filter
and categories are visible in a chart.
39. Excel automatically determines the True
starting, incremental, and stopping val-
ues on a chart based on the data select-
ed.
40. Which of the following is NOT one of X Y chart
most commonly used chart types?
41. A(n) ___ chart is a derivative of a scatter bubble
chart in which both axes are value axes.
42. Excel 2013 automatically assigns a dif- False
ferent pattern to each column of a clus-
tered column chart.
43. To begin creating sparklines on a work- Insert
sheet, click the __ tab.
44. To print only a chart, select the chart, file
click the __ tab, and click Print.
