MGT 2180 Module 3 Exam
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
Which of the following is criteria that determines which data is shown and which is
hidden?
Filter
Which of the following statements is true about Highlight Cells Rules?
A. Highlight Cells Rules formatting uses relational operators,
B. Highlight Cells Rules formatting uses comparison operators
C. You can create your own rule using other operators or a formula
D. all of the above
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data?
REPLACE function
When you first create an Excel table, what name does Excel give it initially?
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?
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?
EXACT function
Which of the following should you use to perform a multiple column sort?
Sort Dialog Box
Which of the following is NOT a procedure to prepare a consolidation worksheet?
Delete formulas that will be used on the consolidated worksheet
, Which of the following is commonly used in legacy or mainframe computers?
Fixed width text file
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data?
REPLACE function
Which of the following is not a popular image format used in Excel?
TXT
which of the following is an illustration, which often includes text that can be placed in
Excel worksheets?
SmartArt graphic
Which of the following functions joins or combines data strings?
CONCAT function
What would a text file be called that uses a character, such as a comma or a tab, to
separate the fields?
delimited text file
In the Excel table, which of the following contains descriptive titles or labels?
header row
What do AutoFilter arrows replace when you scroll down in a table with many records?
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?
NPV function
Which of the following error values indicates that the formula divides by zero or an
empty cell?
#DIV/0!
which of the following is a picture of a full or partial computer screen inserted as an
object in a worksheet?
Screenshot
which of the following commands can you apply to grouped sheets that are not
identical?
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?
#NAME"
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
Which of the following is criteria that determines which data is shown and which is
hidden?
Filter
Which of the following statements is true about Highlight Cells Rules?
A. Highlight Cells Rules formatting uses relational operators,
B. Highlight Cells Rules formatting uses comparison operators
C. You can create your own rule using other operators or a formula
D. all of the above
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data?
REPLACE function
When you first create an Excel table, what name does Excel give it initially?
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?
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?
EXACT function
Which of the following should you use to perform a multiple column sort?
Sort Dialog Box
Which of the following is NOT a procedure to prepare a consolidation worksheet?
Delete formulas that will be used on the consolidated worksheet
, Which of the following is commonly used in legacy or mainframe computers?
Fixed width text file
Which of the following functions allows you to substitute characters for a specified
number of characters in existing data?
REPLACE function
Which of the following is not a popular image format used in Excel?
TXT
which of the following is an illustration, which often includes text that can be placed in
Excel worksheets?
SmartArt graphic
Which of the following functions joins or combines data strings?
CONCAT function
What would a text file be called that uses a character, such as a comma or a tab, to
separate the fields?
delimited text file
In the Excel table, which of the following contains descriptive titles or labels?
header row
What do AutoFilter arrows replace when you scroll down in a table with many records?
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?
NPV function
Which of the following error values indicates that the formula divides by zero or an
empty cell?
#DIV/0!
which of the following is a picture of a full or partial computer screen inserted as an
object in a worksheet?
Screenshot
which of the following commands can you apply to grouped sheets that are not
identical?
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?
#NAME"
