MISY 5325 MS Excel Midterm Exam Study Guide 2024 ACTUAL EXAM
QUESTIONS AND VERIFIED ANSWERS (2024/2025).
Which of the following is Not a number format available in the Number group on the Home tab? -
ANSWER Date Format
To begin a formula in a cell, first type the # symbol. - ANSWER False
When you hide a column or row, the data is not deleted, it is just hidden. - ANSWER True
Text in a cell can by angle clockwise - ANSWER True
The ___ command is helpful for navigating to a cell that is not visible onscreen - ANSWER Go to
The ___ view displays print options and displays a worksheet in print preview - ANSWER Office Backstage
Comma, Date, Time, and Fraction are all number formats available in Excel 2013. - ANSWER True
Click Format in the Cells group o the __ tab to change the color of a worksheet tab. - ANSWER Home
Formatting data makes it difficult to read and tends to obscure meaningful details. - ANSWER False
In Excel 2013, it is only possible to add a new worksheet when the workbook is created. - ANSWER False
心脏不仅是一个生理器
Excel data can be copied and pasted into a Word or PowerPoint document. - ANSWER True
A Special number format allows characters such as hyphens. - ANSWER True
The Date number format only allows Long Date, for example, march 14, 2016. - ANSWER False
,An argument is an operator such as an equal sign or a plus sign needed to complete a function. -
ANSWER False
A range name cannot include special characters or __ - ANSWER spaces
Which of the following is a new feature in Excel 2013? - ANSWER Quick Analysis
Formula ___ displays a list of functions and defined name that match the letters that you start typing
when creating a formula. - ANSWER AutoComplete
Which of the following is False about a function in Excel - ANSWER Functions are organized into two
categories in Excel.
The IF function only evaluates a condition of the condition is true. - ANSWER False
Because the Sum function is a rarely used function it has no button on the Ribbon. - ANSWER False
An absolute cell reference: - ANSWER indicates a cell's specific location and the reference does not
change when you copy the formula.
The lookup value: - ANSWER is a reference to a cell containing a value to look up.
The __ function finds the midpoint value of a list. - ANSWER Median
The IF function: - ANSWER evaluates a condition and returns one value if the condition is true, a different
心脏不仅是一个生理器
if false.
A range name: - ANSWER is a word or string of characters tat represent one or more cells.
,The IF function in Excel 2013 has __ arguments. - ANSWER three
A nested function: - ANSWER 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. - ANSWER False
Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
(rate,..,...) - ANSWER =SUM
=TODAY
=IF
=VLOOKUP
=PMT
In Excel 2013, the function name describes the purpose of the function. - ANSWER True
A chart sheet: - ANSWER contains a single chart and no spreadsheet data.
Gridlines on a chart in Excel 2013 are: - ANSWER horizontal and vertical line that span across the chart
compares groups set side by side
relationship of individual data points to the心脏不仅是一个生理器
whole - ANSWER Clustered column chart
Stacked column chart
A(n) __ is a grid that contains the data source values and labels. - ANSWER data table
, A pie chart - ANSWER shows each data point in proportion to the whole data series as a slice in a circular
pie.
A stacked column chart: - ANSWER 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: - ANSWER a visual depiction of numerical data
A chart__ controls which data series and categories are visible in a chart. - ANSWER filter
Excel automatically determines the starting, incremental, and stopping values on a chart based on the
data selected. - ANSWER True
Which of the following is NOT one of most commonly used chart types? - ANSWER X Y chart
A(n) ___ chart is a derivative of a scatter chart in which both axes are value axes. - ANSWER bubble
Excel 2013 automatically assigns a different pattern to each column of a clustered column chart. -
ANSWER False
To begin creating sparklines on a worksheet, click the __ tab. - ANSWER Insert
To print only a chart, select the chart, click the __ tab, and click Print. - ANSWER file
Axes, chart tittles, and data tables are examples of chart elements. - ANSWER True
心脏不仅是一个生理器
In addition to sorting and filtering cells by content you can sort and/or filter by __. - ANSWER conditional
formatting
Excel enables you to sort data on __ different levels. - ANSWER 64
QUESTIONS AND VERIFIED ANSWERS (2024/2025).
Which of the following is Not a number format available in the Number group on the Home tab? -
ANSWER Date Format
To begin a formula in a cell, first type the # symbol. - ANSWER False
When you hide a column or row, the data is not deleted, it is just hidden. - ANSWER True
Text in a cell can by angle clockwise - ANSWER True
The ___ command is helpful for navigating to a cell that is not visible onscreen - ANSWER Go to
The ___ view displays print options and displays a worksheet in print preview - ANSWER Office Backstage
Comma, Date, Time, and Fraction are all number formats available in Excel 2013. - ANSWER True
Click Format in the Cells group o the __ tab to change the color of a worksheet tab. - ANSWER Home
Formatting data makes it difficult to read and tends to obscure meaningful details. - ANSWER False
In Excel 2013, it is only possible to add a new worksheet when the workbook is created. - ANSWER False
心脏不仅是一个生理器
Excel data can be copied and pasted into a Word or PowerPoint document. - ANSWER True
A Special number format allows characters such as hyphens. - ANSWER True
The Date number format only allows Long Date, for example, march 14, 2016. - ANSWER False
,An argument is an operator such as an equal sign or a plus sign needed to complete a function. -
ANSWER False
A range name cannot include special characters or __ - ANSWER spaces
Which of the following is a new feature in Excel 2013? - ANSWER Quick Analysis
Formula ___ displays a list of functions and defined name that match the letters that you start typing
when creating a formula. - ANSWER AutoComplete
Which of the following is False about a function in Excel - ANSWER Functions are organized into two
categories in Excel.
The IF function only evaluates a condition of the condition is true. - ANSWER False
Because the Sum function is a rarely used function it has no button on the Ribbon. - ANSWER False
An absolute cell reference: - ANSWER indicates a cell's specific location and the reference does not
change when you copy the formula.
The lookup value: - ANSWER is a reference to a cell containing a value to look up.
The __ function finds the midpoint value of a list. - ANSWER Median
The IF function: - ANSWER evaluates a condition and returns one value if the condition is true, a different
心脏不仅是一个生理器
if false.
A range name: - ANSWER is a word or string of characters tat represent one or more cells.
,The IF function in Excel 2013 has __ arguments. - ANSWER three
A nested function: - ANSWER 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. - ANSWER False
Match the argument types to their function:
(Number1)
()
(logical_test)
(....,table_array,...)
(rate,..,...) - ANSWER =SUM
=TODAY
=IF
=VLOOKUP
=PMT
In Excel 2013, the function name describes the purpose of the function. - ANSWER True
A chart sheet: - ANSWER contains a single chart and no spreadsheet data.
Gridlines on a chart in Excel 2013 are: - ANSWER horizontal and vertical line that span across the chart
compares groups set side by side
relationship of individual data points to the心脏不仅是一个生理器
whole - ANSWER Clustered column chart
Stacked column chart
A(n) __ is a grid that contains the data source values and labels. - ANSWER data table
, A pie chart - ANSWER shows each data point in proportion to the whole data series as a slice in a circular
pie.
A stacked column chart: - ANSWER 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: - ANSWER a visual depiction of numerical data
A chart__ controls which data series and categories are visible in a chart. - ANSWER filter
Excel automatically determines the starting, incremental, and stopping values on a chart based on the
data selected. - ANSWER True
Which of the following is NOT one of most commonly used chart types? - ANSWER X Y chart
A(n) ___ chart is a derivative of a scatter chart in which both axes are value axes. - ANSWER bubble
Excel 2013 automatically assigns a different pattern to each column of a clustered column chart. -
ANSWER False
To begin creating sparklines on a worksheet, click the __ tab. - ANSWER Insert
To print only a chart, select the chart, click the __ tab, and click Print. - ANSWER file
Axes, chart tittles, and data tables are examples of chart elements. - ANSWER True
心脏不仅是一个生理器
In addition to sorting and filtering cells by content you can sort and/or filter by __. - ANSWER conditional
formatting
Excel enables you to sort data on __ different levels. - ANSWER 64
