MISY 5325 MS EXCEL MIDTERM EXAM STUDY GUIDE
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
Print order: - Answer- is the sequence in which pages print.
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
Print order: - Answer- is the sequence in which pages print.
