Which of the Following Formulas Contains an Absolute Cell Reference

question 45

Multiple Choice

Which of the following formulas contains an absolute cell reference?

• A) =$B4
• B) =B$4
• C) =$B$4
• D) =B4

---

Definitions:

High Frequency

Pertaining to or involving very short intervals of time or occurring at a rapid rate.

Automatic System

Cognitive processes that occur without conscious control or deliberation, typically fast and efficient, handling tasks such as perception, encoding, and simple decision-making.

Unconscious

The part of the mind that contains thoughts, memories, and desires not within the realm of current awareness.

Brain

The organ located in the head of an animal that coordinates its behavior and processes sensory information; it's the center of the nervous system in humans and other vertebrates.