Tables can be created using the Crosstab query type

An absolute cell reference

A) contains both an absolute and a relative cell reference. B) indicates a cell's specific location and the reference does not change when you copy the formula. C) occurs when a formula directly or indirectly refers to the cell containing the formula. D) causes a potential error.

When you double-click a field in a field list in Query Design View, it is ____.

A. deleted from the query B. added to the next available position in the query design grid C. used as the first sort order D. set as the primary key field