ISYS 2263 (with Accurate Answers)

In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns. correct answers range A data ____ table describes the fields you plan to maintain in a table. correct answers - Definition In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet. correct answers rows and columns When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data. correct answers - Table To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button. correct answers insert Excel assigns the name ____ to the first Excel table created in a workbook. correct answers table1 Which of the following is a valid table name? correct answers newtable a table name cannot include correct answers spaces The fields you use to order your data are called sort ____. correct answers fields You can access the Sort buttons in the ____ group on the HOME tab by clicking the Sort & Filter button and clicking a sort option. correct answers editing When you have more than one sort field, you should use the Sort ____ to specify the sort criteria. correct answers dialog box To add a sort field in the Sort dialog box, click the ____ button. - Add Level correct answers add level After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records. correct answers clear You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab. correct answers data The ____ condition requires that all of the selected criteria be true for the record to be displayed. correct answers and The ____ criteria filter requires the records displayed to start with the specified text string. correct answers begins with