Cell references that remain fixed when a formula is copied to a new location are called _________.
A. phantom references
B. relative references
C. absolute references
D. pointer references

Fill in the blank(s) with the appropriate word(s).


absolute references

Rationale: Cell references that remain fixed when a formula is copied to a new location are called absolute references. In Excel, absolute references have a $ (dollar sign) before each column and row designation. See 14-1: Using Relative, Absolute, and Mixed Cell References in Formulas

Computer Science & Information Technology

You might also like to view...

The function what() is defined in ______________.

A. underflow_error B. overflow_error C. exception D. bad_exception E. runtime_error

Computer Science & Information Technology

Which port number is used by the Telnet protocol?

A. 20 B. 21 C. 22 D. 23

Computer Science & Information Technology

A(n) ____ is an application software designed to maintain information on computer systems, user questions, problem solutions, and other information that members of the organization can reference.

A. customer relationship manager B. enterprise resource planning system C. database manager D. help desk system

Computer Science & Information Technology

You should press the SPACEBAR to clear a cell.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology