MGT 2180 MODULE 3 EXAM QUESTIONS AND
ANSWERS
Which of the following is a task you can perform using the Table Style Options group of
commands?
A. Show or hide various parts of a table
B. hide the header row or display a total row
C. hide the AutoFilter arrows
D. All of the above - Answers - D. All of the above
Which of the following is criteria that determines which data is shown and which is
hidden? - Answers - Filter
Which of the following statements is true about Highlight Cells Rules? - Answers - All of
the above
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data? - Answers - REPLACE function
When you first create an Excel table, what name does Excel give it initially? - Answers -
TableN, where N is a number
Which of the following is a specific item name in a structured reference that Excel
automatically places in a table? - Answers - All of the above (#All, #Data, #Headers)
which of the following functions compares two text strings, values, or characters to
determine if they are identical? - Answers - EXACT function
Which of the following should you use to perform a multiple column sort? - Answers -
Sort Dialog Box
Which of the following is NOT a procedure to prepare a consolidation worksheet? -
Answers - Delete formulas that will be used on the consolidated worksheet
Which of the following is commonly used in legacy or mainframe computers? - Answers
- Fixed width text file
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data? - Answers - REPLACE function
Which of the following is not a popular image format used in Excel? - Answers - TXT
, which of the following is an illustration, which often includes text that can be placed in
Excel worksheets? - Answers - SmartArt graphic
Which of the following functions joins or combines data strings? - Answers - CONCAT
function
What would a text file be called that uses a character, such as a comma or a tab, to
separate the fields? - Answers - delimited text file
In the Excel table, which of the following contains descriptive titles or labels? - Answers
- header row
What do AutoFilter arrows replace when you scroll down in a table with many records? -
Answers - column headings
Which of the following functions calculates the net present value of an investment using
a discount rate and a series of future payments and receipts? - Answers - NPV function
Which of the following error values indicates that the formula divides by zero or an
empty cell? - Answers - #DIV/0!
which of the following is a picture of a full or partial computer screen inserted as an
object in a worksheet? - Answers - Screenshot
which of the following commands can you apply to grouped sheets that are not
identical? - Answers - header and footer command
Which of the following error values indicates that the formula uses unrecognized text
such as misspelled function, sheet, or range name? - Answers - #NAME"
which of the following financial function arguments specifies the amount paid each
period? - Answers - pmt
which of the following is an example of a data visualization command? - Answers - All of
the above
which of the following includes data that is referenced in a dependent workbook? -
Answers - source workbook
Which kinds of source data can you import into Excel? - Answers - All of the above
When a screenshot graphic object is selected, which of the following context-sensitive
tabs display? - Answers - Picture Tools, Format tab
ANSWERS
Which of the following is a task you can perform using the Table Style Options group of
commands?
A. Show or hide various parts of a table
B. hide the header row or display a total row
C. hide the AutoFilter arrows
D. All of the above - Answers - D. All of the above
Which of the following is criteria that determines which data is shown and which is
hidden? - Answers - Filter
Which of the following statements is true about Highlight Cells Rules? - Answers - All of
the above
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data? - Answers - REPLACE function
When you first create an Excel table, what name does Excel give it initially? - Answers -
TableN, where N is a number
Which of the following is a specific item name in a structured reference that Excel
automatically places in a table? - Answers - All of the above (#All, #Data, #Headers)
which of the following functions compares two text strings, values, or characters to
determine if they are identical? - Answers - EXACT function
Which of the following should you use to perform a multiple column sort? - Answers -
Sort Dialog Box
Which of the following is NOT a procedure to prepare a consolidation worksheet? -
Answers - Delete formulas that will be used on the consolidated worksheet
Which of the following is commonly used in legacy or mainframe computers? - Answers
- Fixed width text file
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data? - Answers - REPLACE function
Which of the following is not a popular image format used in Excel? - Answers - TXT
, which of the following is an illustration, which often includes text that can be placed in
Excel worksheets? - Answers - SmartArt graphic
Which of the following functions joins or combines data strings? - Answers - CONCAT
function
What would a text file be called that uses a character, such as a comma or a tab, to
separate the fields? - Answers - delimited text file
In the Excel table, which of the following contains descriptive titles or labels? - Answers
- header row
What do AutoFilter arrows replace when you scroll down in a table with many records? -
Answers - column headings
Which of the following functions calculates the net present value of an investment using
a discount rate and a series of future payments and receipts? - Answers - NPV function
Which of the following error values indicates that the formula divides by zero or an
empty cell? - Answers - #DIV/0!
which of the following is a picture of a full or partial computer screen inserted as an
object in a worksheet? - Answers - Screenshot
which of the following commands can you apply to grouped sheets that are not
identical? - Answers - header and footer command
Which of the following error values indicates that the formula uses unrecognized text
such as misspelled function, sheet, or range name? - Answers - #NAME"
which of the following financial function arguments specifies the amount paid each
period? - Answers - pmt
which of the following is an example of a data visualization command? - Answers - All of
the above
which of the following includes data that is referenced in a dependent workbook? -
Answers - source workbook
Which kinds of source data can you import into Excel? - Answers - All of the above
When a screenshot graphic object is selected, which of the following context-sensitive
tabs display? - Answers - Picture Tools, Format tab
