When You Create a Formula That References All or Parts

question 67

Short Answer

When you create a formula that references all or parts of an Excel table you can replace the specific cell or range address with a(n)_________________________ reference the actual table name or column header.

---

Definitions:

Quasi In Rem Jurisdiction

A legal principle allowing a court to exercise jurisdiction over an out-of-state defendant's property within the jurisdiction for the purpose of the lawsuit.

Subject Matter Jurisdiction

The authority of a court to hear cases pertaining to a specific type of issue or within a particular category of legal matters.

Concurrent Federal Jurisdiction

A situation where both federal and state courts have the authority to hear and decide on the same case.

Diversity of Citizenship Jurisdiction

Jurisdiction in federal courts arising from cases between citizens of different U.S. states or between U.S. citizens and foreign nationals or entities, intended to prevent state bias.