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:

Multiple Intelligences

Describes a theory by Howard Gardner that suggests human intelligence is composed of various distinct faculties beyond just a single, general ability.

Verbal-Linguistic

This relates to the understanding and manipulation of language and words as a way of communication, learning, and reasoning.

Fixed Battery Approach

A standardized assessment method in which the same set of tests is administered to all examinees.

Neuropsychology

A domain of psychology that examines brain–behavior relationships.