MGT 2180 EXAM 3 QUESTIONS AND ANSWERS
When using the NPV function which of the following statements is not true? - Answers -
Cash flows are present payments
Which of the following refers to the task of obtaining data from another software
program or another file format? - Answers - Importing
Which of the following refers to a range of cells that includes a header row and rows of
data? - Answers - Database
Which of the following is a type of conditional formatting that displays cells with a fill
color, horizontal bar, or an icon? - Answers - Data visualization
Which of the following includes or refers to data from another workbook? - Answers -
Dependent workbook
Which of the following is a character such as an exclamation point that marks or
signifies a component of an external reference - Answers - Identifier
Which command links workbooks? - Answers - Consolidate
How does excel treat criteria entered on different rows? - Answers - OR condition
In excel table, which of the following represents a row of data - Answers - Record?
Which of the following guidelines will make your tables easier to use and navigate -
Answers - All of the above
Which of the following calculates the average deviation of the absolute values in a
range - Answers - AVEDEV
Which of the following statements is true about the subtotal command? - Answers - The
subtotal command is in the outline group on the data tab
How many rows must the criteria range of an Advanced Filter have? - Answers - At
least 2
Which of the following types of file might you see when downloading a blank statement?
- Answers - cvs
Which of the following should you use to perform a multiple column sort? - Answers -
Subtotal command
, Which of the following is criteria that determines which data is shown and which is
hidden? - Answers - Filter
When you first create an excel table, what name does excel give it initially? - Answers -
Table N, where N is a number
Which of the following is true about data bars? - Answers - By default, excel does not
include data tables with charts
When creating a consolidated worksheet, what must you do to the range of cells to be
consolidated - Answers - Delete
Which of the following refers to a series of equal payments made at the same time of
the month or year for a specified period of time? - Answers - Annuity
Which dialog box is used to update links in a workbook? - Answers - Edit links
Which of the following functions would enable you to calculate the average number of
on-site visits made by a particular sales rep? - Answers - AVERAGEIFS
Which of the following is a predesigned set of built-in format options - Answers - Table
style
Which of the following is a separate summary sheet in the workbook? - Answers -
Consolidation worksheet
Which of the following statements is not true? - Answers - You can import text from a
Word doc directly into excel
Which of the following calculates where a particular value appears in the dataset? -
Answers - RANK.EQ
Which consolidation method is used when data in multiple worksheets is arranged
differently but has the same row and column table? - Answers - Consolidation by
category
Which of the following can be built from a Pivottable? - Answers - Pivotcharts
Which of the following functions adds or totals cells only if they meet the specified
criteria? - Answers - SUMIFS
Which of the following shows the correct syntax for the OR function? - Answers -
OR(LogicalN)
Which of the following shows the correct syntax for the AND function? - Answers -
AND(logicalN)
When using the NPV function which of the following statements is not true? - Answers -
Cash flows are present payments
Which of the following refers to the task of obtaining data from another software
program or another file format? - Answers - Importing
Which of the following refers to a range of cells that includes a header row and rows of
data? - Answers - Database
Which of the following is a type of conditional formatting that displays cells with a fill
color, horizontal bar, or an icon? - Answers - Data visualization
Which of the following includes or refers to data from another workbook? - Answers -
Dependent workbook
Which of the following is a character such as an exclamation point that marks or
signifies a component of an external reference - Answers - Identifier
Which command links workbooks? - Answers - Consolidate
How does excel treat criteria entered on different rows? - Answers - OR condition
In excel table, which of the following represents a row of data - Answers - Record?
Which of the following guidelines will make your tables easier to use and navigate -
Answers - All of the above
Which of the following calculates the average deviation of the absolute values in a
range - Answers - AVEDEV
Which of the following statements is true about the subtotal command? - Answers - The
subtotal command is in the outline group on the data tab
How many rows must the criteria range of an Advanced Filter have? - Answers - At
least 2
Which of the following types of file might you see when downloading a blank statement?
- Answers - cvs
Which of the following should you use to perform a multiple column sort? - Answers -
Subtotal command
, Which of the following is criteria that determines which data is shown and which is
hidden? - Answers - Filter
When you first create an excel table, what name does excel give it initially? - Answers -
Table N, where N is a number
Which of the following is true about data bars? - Answers - By default, excel does not
include data tables with charts
When creating a consolidated worksheet, what must you do to the range of cells to be
consolidated - Answers - Delete
Which of the following refers to a series of equal payments made at the same time of
the month or year for a specified period of time? - Answers - Annuity
Which dialog box is used to update links in a workbook? - Answers - Edit links
Which of the following functions would enable you to calculate the average number of
on-site visits made by a particular sales rep? - Answers - AVERAGEIFS
Which of the following is a predesigned set of built-in format options - Answers - Table
style
Which of the following is a separate summary sheet in the workbook? - Answers -
Consolidation worksheet
Which of the following statements is not true? - Answers - You can import text from a
Word doc directly into excel
Which of the following calculates where a particular value appears in the dataset? -
Answers - RANK.EQ
Which consolidation method is used when data in multiple worksheets is arranged
differently but has the same row and column table? - Answers - Consolidation by
category
Which of the following can be built from a Pivottable? - Answers - Pivotcharts
Which of the following functions adds or totals cells only if they meet the specified
criteria? - Answers - SUMIFS
Which of the following shows the correct syntax for the OR function? - Answers -
OR(LogicalN)
Which of the following shows the correct syntax for the AND function? - Answers -
AND(logicalN)
