MGT 2180 Module 3 Exam | Questions and Answers

Document Content and Description Below

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 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 financial function arguments specifies the amount paid each period? Pmt which of the following is an example of a data visualization command? All of the above (Data Bars, Color Scales, Icon Sets) which of the following includes data that is referenced in a dependent workbook? source workbook Which kinds of source data can you import into Excel? All of the above When a screenshot graphic object is selected, which of the following context-sensitive tabs display? Picture Tools, Format tab Which of the following database functions counts cells with values in the field that meet the criteria? DCOUNT Which of the following is a character such as an exclamation point that marks or signifies a component of an external reference? Identifier which of the following database functions displays the largest value in the field that meets the criteria? DMAX which of the following should you use to calculate the standard deviation for an entire population instead of a sample? STDEV.P which of the following must you do for the Subtotal command to work? sort the rows by the field to be totaled Which of the following is a criteria that determines which data is shown and which is hidden Filter which function displays columnar data in rows and vice versa? TRANSPOSE which of the following moves the pointer to another workbook or web page? hyperlink [Show More]

Last updated: 6 months ago

Preview 3 out of 6 pages