USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click and Sort button in the Sort & Filter group of the Data tab.
|
|
|
Click an AutoFilter button in the total row.
|
|
|
Click an Autofilter button in the field names row
|
|
|
Click the Sort A to Z button in the Sort & Filter group of the Data tab.
|
Detailed explanation-1: -which of the following procedures is not a way to sort a table by the contents of one column? click an autofilter button in the total row.
Detailed explanation-2: -Which of the following procedures is not a way to delete a worksheet from a workbook? Press Ctrl + A to select all cells in the worksheet and press Delete. Which of the following statements about hidden and unhidden worksheets is correct? A hidden worksheet cannot be inadvertently deleted.
Detailed explanation-3: -There is no difference between an AutoFiltered range of records in a list and a table. A table maintains its sort order after you close and then open it again. A table given a title enables its field names to be used in formulas in place of cell references.
Detailed explanation-4: -If you have a worksheet containing data you do not want to be sorted, what must you do before sorting? You are correct! Delineate the data you do not want to be sorted. Delineate the data you do not want to be sorted.