Working with Table Data (Assignment)

What statements best describe total rows? Check all that apply. Their values are not stored in a database. Their values are stored on the top row in a database. Their values update when changes are made in a table. Their values update only when they are manually refreshed. Their values are automatically totaled when a total row is added.

(A) Their values are not stored in a database. (C) Their values update when changes are made in a table.

Where is the row selector located in Datasheet view? above the top row of data below the last row of data to the left of the leftmost data to the right of the rightmost data

(C). to the left of the leftmost data

Which methods will remove filters? Check all that apply. In the navigation icons area, click Remove Filter. In the Home tab, in the Sort & Filter group, click Cancel. On the File tab, click Save Object As, and save the table. On the Home tab, in the Sort & Filter group, click Remove Filter. Click the drop-down menu in the filtered column, then click Clear Filter. In the Record Navigation bar, click the Filter warning, and unclick Filter.

(D)On the Home tab, in the Sort & Filter group, click Remove Filter. (E)Click the drop-down menu in the filtered column, then click Clear Filter. (F)In the Record Navigation bar, click the Filter warning, and unclick Filter.

Use the drop-down menus to describe the steps for sorting records alphabetically by last name. 1. Open the table in DatasheetDesignPivotChartPivotTable view. 2. Place the cursor in the Last Name column. 3. On the Create File HomeReview tab, in the Sort & Filter group, click FilterAscendingDescendingAdvanced Sort.

1. datasheets 2.ascending 3. home