©Themoon EXAM SOLUTIONS
16/11/2024 17:33PM
MISY 5325 MS Excel Midterm Exam Study
Guide Solutions
Which of the following is Not a number format available in the Number group on the Home tab?
- Answers✓✓Date Format
To begin a formula in a cell, first type the # symbol. - Answers✓✓False
When you hide a column or row, the data is not deleted, it is just hidden. - Answers✓✓True
Text in a cell can by angle clockwise - Answers✓✓True
The ___ command is helpful for navigating to a cell that is not visible onscreen -
Answers✓✓Go to
The ___ view displays print options and displays a worksheet in print preview -
Answers✓✓Office Backstage
Comma, Date, Time, and Fraction are all number formats available in Excel 2013. -
Answers✓✓True
Click Format in the Cells group o the __ tab to change the color of a worksheet tab. -
Answers✓✓Home
, ©Themoon EXAM SOLUTIONS
16/11/2024 17:33PM
Formatting data makes it difficult to read and tends to obscure meaningful details. -
Answers✓✓False
In Excel 2013, it is only possible to add a new worksheet when the workbook is created. -
Answers✓✓False
Excel data can be copied and pasted into a Word or PowerPoint document. - Answers✓✓True
A Special number format allows characters such as hyphens. - Answers✓✓True
The Date number format only allows Long Date, for example, march 14, 2016. -
Answers✓✓False
An argument is an operator such as an equal sign or a plus sign needed to complete a function. -
Answers✓✓False
A range name cannot include special characters or __ - Answers✓✓spaces
Which of the following is a new feature in Excel 2013? - Answers✓✓Quick Analysis
Formula ___ displays a list of functions and defined name that match the letters that you start
typing when creating a formula. - Answers✓✓AutoComplete
Which of the following is False about a function in Excel - Answers✓✓Functions are organized
into two categories in Excel.
The IF function only evaluates a condition of the condition is true. - Answers✓✓False
, ©Themoon EXAM SOLUTIONS
16/11/2024 17:33PM
Because the Sum function is a rarely used function it has no button on the Ribbon. -
Answers✓✓False
An absolute cell reference: - Answers✓✓indicates a cell's specific location and the reference
does not change when you copy the formula.
The lookup value: - Answers✓✓is a reference to a cell containing a value to look up.
The __ function finds the midpoint value of a list. - Answers✓✓Median
The IF function: - Answers✓✓evaluates a condition and returns one value if the condition is
true, a different if false.
A range name: - Answers✓✓is a word or string of characters tat represent one or more cells.
The IF function in Excel 2013 has __ arguments. - Answers✓✓three
A nested function: - 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. - Answers✓✓False
Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
, ©Themoon EXAM SOLUTIONS
16/11/2024 17:33PM
(rate,..,...) - Answers✓✓=SUM
=TODAY
=IF
=VLOOKUP
=PMT
In Excel 2013, the function name describes the purpose of the function. - Answers✓✓True
A chart sheet: - Answers✓✓contains a single chart and no spreadsheet data.
Gridlines on a chart in Excel 2013 are: - Answers✓✓horizontal and vertical line that span across
the chart
compares groups set side by side
relationship of individual data points to the whole - Answers✓✓Clustered column chart
Stacked column chart
A(n) __ is a grid that contains the data source values and labels. - Answers✓✓data table
A pie chart - Answers✓✓shows each data point in proportion to the whole data series as a slice
in a circular pie.
A stacked column chart: - Answers✓✓places stacks of data in segments on top of each other in
one column, with each category in the data series represented by a different color.
A chart is: - Answers✓✓a visual depiction of numerical data
16/11/2024 17:33PM
MISY 5325 MS Excel Midterm Exam Study
Guide Solutions
Which of the following is Not a number format available in the Number group on the Home tab?
- Answers✓✓Date Format
To begin a formula in a cell, first type the # symbol. - Answers✓✓False
When you hide a column or row, the data is not deleted, it is just hidden. - Answers✓✓True
Text in a cell can by angle clockwise - Answers✓✓True
The ___ command is helpful for navigating to a cell that is not visible onscreen -
Answers✓✓Go to
The ___ view displays print options and displays a worksheet in print preview -
Answers✓✓Office Backstage
Comma, Date, Time, and Fraction are all number formats available in Excel 2013. -
Answers✓✓True
Click Format in the Cells group o the __ tab to change the color of a worksheet tab. -
Answers✓✓Home
, ©Themoon EXAM SOLUTIONS
16/11/2024 17:33PM
Formatting data makes it difficult to read and tends to obscure meaningful details. -
Answers✓✓False
In Excel 2013, it is only possible to add a new worksheet when the workbook is created. -
Answers✓✓False
Excel data can be copied and pasted into a Word or PowerPoint document. - Answers✓✓True
A Special number format allows characters such as hyphens. - Answers✓✓True
The Date number format only allows Long Date, for example, march 14, 2016. -
Answers✓✓False
An argument is an operator such as an equal sign or a plus sign needed to complete a function. -
Answers✓✓False
A range name cannot include special characters or __ - Answers✓✓spaces
Which of the following is a new feature in Excel 2013? - Answers✓✓Quick Analysis
Formula ___ displays a list of functions and defined name that match the letters that you start
typing when creating a formula. - Answers✓✓AutoComplete
Which of the following is False about a function in Excel - Answers✓✓Functions are organized
into two categories in Excel.
The IF function only evaluates a condition of the condition is true. - Answers✓✓False
, ©Themoon EXAM SOLUTIONS
16/11/2024 17:33PM
Because the Sum function is a rarely used function it has no button on the Ribbon. -
Answers✓✓False
An absolute cell reference: - Answers✓✓indicates a cell's specific location and the reference
does not change when you copy the formula.
The lookup value: - Answers✓✓is a reference to a cell containing a value to look up.
The __ function finds the midpoint value of a list. - Answers✓✓Median
The IF function: - Answers✓✓evaluates a condition and returns one value if the condition is
true, a different if false.
A range name: - Answers✓✓is a word or string of characters tat represent one or more cells.
The IF function in Excel 2013 has __ arguments. - Answers✓✓three
A nested function: - 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. - Answers✓✓False
Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
, ©Themoon EXAM SOLUTIONS
16/11/2024 17:33PM
(rate,..,...) - Answers✓✓=SUM
=TODAY
=IF
=VLOOKUP
=PMT
In Excel 2013, the function name describes the purpose of the function. - Answers✓✓True
A chart sheet: - Answers✓✓contains a single chart and no spreadsheet data.
Gridlines on a chart in Excel 2013 are: - Answers✓✓horizontal and vertical line that span across
the chart
compares groups set side by side
relationship of individual data points to the whole - Answers✓✓Clustered column chart
Stacked column chart
A(n) __ is a grid that contains the data source values and labels. - Answers✓✓data table
A pie chart - Answers✓✓shows each data point in proportion to the whole data series as a slice
in a circular pie.
A stacked column chart: - Answers✓✓places stacks of data in segments on top of each other in
one column, with each category in the data series represented by a different color.
A chart is: - Answers✓✓a visual depiction of numerical data
