MGT 2180 Test 4 | Questions and Answers

MGT 2180 Test 4 | Questions and Answers Which of the following is a step-by-step procedure to find a solution? Algorithm What name is assigned to the person who shares a workbook? the owner Which of the following is always the first key in a macro shortcut? Ctrl Which of the following best describes a Trusted Location in Excel? a folder Which of the following tabs is used to edit or delete a comment? Review tab Which of the following is a pop up text box attached to a cell? Comment Which of the following extensions identifies a macro-enabled workbook? .xlsm What is the maximum number of fields or columns that can be displayed in a data input form? 32 Which of the following is not true when assigning a macro to a button? You can resize a button, but you cannot move the button. Which of the following is a form control that runs a macro with a single click? Button Which of the following can be used to limit the length of a text entry such as a state abbreviation? Validation settings Which of the following is a worksheet with an excel table and a chart that illustrates past data and predicts future values generated from data in the worksheet? forecast sheet Which of the following are the rules applied to data as it is entered? validation settings Which of the following is information used by Solver to find a solution? Parameter Which of the following statements is not true when building validation lists? In the Data Validation dialog box, you can require users to select an entry from a list Which of the following statements is not true about VBA? VBA is not a programming language Which of the following statements is not true for comments? comments print by default When using solver, which of the following parameters is a cell with a formula to be calculated to reach a desired result? Objective cell Which of the following is a visual filter for a date field in a PivotTable? Timeline Which of the following operations in the Add Constraints dialog box limits the value to a whole number? Int In a data input form, how are labels and entry boxes for data displayed? vertical layout Which of the following is a saved set of values in a worksheet? Scenario Which of the following buttons creates a slicer? Insert slicer button which of the following displays in the upper right corner of a cell after a comment has been added? small red triangle When troubleshooting a macro, which of the following should you do if another macro is currently running? End the current macro before running or recording another macro Which of the following won't ever cause an error in a Visual Basic macro? Comments Which of the following statements about working with data tables is not true?