If a Cell Containing the Formula =$B$14 Is Not Copy

question 73

Multiple Choice

If a cell containing the formula =$B$14 is not copy and pasted, but moved four columns over and four rows down, what would the resultant cell reference become?

• A)=F18
• B)=$F$18
• C)=B14
• D)=$B$14

---

Definitions:

Validation Rule

A constraint applied to a database field to ensure data integrity by restricting the type of data or values that can be entered.

Table Design

An aspect of database management that involves specifying the structure, relationships, and constraints of data stored in tables.

Caption Property

A property used in database management and user interfaces to provide a readable label or title for an object, field, or control.

Query Datasheet

A view that displays the results of a database query in a grid-like format, similar to a table or spreadsheet.