Question: 85. Consider the function = INDEX(array,row_number,column_num). Which of the arguments is a cell range to be searched? INDEX array row_num O column_num 86. Which of

85. Consider the function = INDEX(array,row_number,column_num). Which of the arguments is a cell range to be searched? INDEX array row_num O column_num 86. Which of the following can be used to limit the length of a text entry such as a state abbreviation? Form controls Validation settings Warning box ActiveX controls 87. When you build a data validation list, what does the user see when he or she selects the cell on the worksheet? Comment box Drop-down arrow Data Validation dialog box Warning box 88. Which of the following is required before workbooks can be compared and merged? The original shared workbook must have the change history active Each copy of the workbook must have been made from the original shared workbook. Each copy of the workbook must have a different file name and cannot have any passwords. All of the above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
