USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Click the criterion button on the slicer.
|
|
|
Right-click the cell whose contents you want for the criterion and click Filter in the menu.
|
|
|
Click the Filter button in the Sort & Filter group of the Data tab.
|
|
|
Click the AutoFilter button in the total row at the bottom
|
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: -You cannot sort a table in alphabetical or numerical order for one column, and by conditional formatting for another column, at the same time. When importing data from a text file, you can tell Excel to recognize a character other than a comma as a field delimiter.
Detailed explanation-3: -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-4: -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.