Working with Table Data Answers

14 verified answers2 views
1
Free Preview

Which symbol shows AutoCorrect is in use?

A
a white light bulb
B
a green plus sign
C
a flashing red circle
D
a yellow lightning bolt
149895
Free Preview

What should a user do to find and replace text throughout a field? Use the drop-down menus to complete the steps.

Answers:
2. In the Home tab, open the dialog box.:Find
3. On the tab, enter the text to search for and the replacement text.:Replace
4. After a few instances to make sure the text is being replaced correctly, you can then click to change all instances.:Replace All
149896

X FindGo To✔ ReplaceSpelling

A
X Find
B
Go To
C
✔ Replace
D
Spelling
149897

Change AllEdit AllX Find All✔ Replace All

A
Change All
B
Edit All
C
X Find All
D
✔ Replace All
149898

What steps will add a totals row to a database? Use the drop-down menus to complete them.

Answers:
2. Click the button and a totals row will be added to the of the database.:Totals
2. Click the button and a totals row will be added to the of the database.:bottom
4. For a count total of how many records qualify, select .:Count
5. For a total amount in currency column, select .:Sum
149899

leftrighttop✔ bottom

A
left
B
right
C
top
D
✔ bottom
149900

Average✔ CountMaximumSum

A
Average
B
✔ Count
C
Maximum
D
Sum
149901

AverageX CountMaximum✔ Sum

A
Average
B
X Count
C
Maximum
D
✔ Sum
149902

What does a pencil icon in the row selector area indicate?

A
The record is missing some text or data values in its fields.
B
The row is blank and is available for inserting a new record.
C
The row is being edited, and the changes are not yet saved.
D
The record has incorrect data values or conflicting data values.
149905

Where would you find the function to add a totals row to a Database?

A
Home tab, Find group
B
Home tab, Records group
C
Database Tools tab, Tools group
D
Database Tools tab, Relationships group
149906

What is the best description of filtering?

A
It moves records from one table to another existing table.
B
It copies and pastes the data from one table to a new table.
C
It shows records that match specific criteria and hides the others.
D
It copies records that match specific criteria and deletes the others.
149907

What steps will add a totals row to a database? Use the drop-down menus to complete them.

Answers:
2. Click the button and a totals row will be added to the of the database.:Totals
2. Click the button and a totals row will be added to the of the database.:bottom
4. For a count total of how many records qualify, select .:Count
5. For a total amount in currency column, select .:Sum

Did you find these answers helpful?