DATABASE FUNDAMENTALS
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: -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: -Detailed Solution. The correct answer is “ALT".