Working with Table Data Answers

7 verified answers2 views
1
Free Preview

Where is the row selector located in Datasheet view?

A
above the top row of data
B
below the last row of data
C
to the left of the leftmost data
D
to the right of the rightmost data
149902
Free Preview

Use the drop-down menus to describe the steps for sorting records alphabetically by last name.

Answers:
1. Open the table in view.:Datasheet
3. On the tab, in the Sort & Filter group, click .:Home
3. On the tab, in the Sort & Filter group, click .:Ascending
149903

Create File ✔ HomeReview

A
Create
B
File
C
✔ Home
D
Review
149904

Filter✔ AscendingDescendingAdvanced Sort

A
Filter
B
✔ Ascending
C
Descending
D
Advanced Sort
149905

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.
B
Their values are stored on the top row in a database.
C
Their values update when changes are made in a table.
D
Their values update only when they are manually refreshed.
E
Their values are automatically totaled when a total row is added.
149906

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.

A
In the navigation icons area, click Remove Filter.
B
In the Home tab, in the Sort & Filter group, click Cancel.
C
On the File tab, click Save Object As, and save the table.
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.
149907

Use the drop-down menus to describe the steps for sorting records alphabetically by last name.

Answers:
1. Open the table in view.:Datasheet
3. On the tab, in the Sort & Filter group, click .:Home
3. On the tab, in the Sort & Filter group, click .:Ascending

Did you find these answers helpful?