Juan Tells You That Your Work in Excel Will Go

question 46

Multiple Choice

Juan tells you that your work in Excel will go a lot faster if you start using defined names instead of cell and range addresses. You believe him but you have been frustrated by defined names in the past because you did not know the rules for naming them and you have run into errors as a result. Juan offers to help you.
-Which of the following is a true statement Juan can make about defined names as he is explaining the rules to you?

• A)The name can include letters, numbers, periods, and underscores
• B)To distinguish multiword names, use a hyphen between the words
• C)Defined names are case sensitive
• D)The name should start with a hash tag

---

Definitions:

Welded Igneous Texture

Characteristic of volcanic rock that forms when hot volcanic ash and debris fuse together under high temperature and pressure.

Magma

Molten rock beneath the Earth's surface, which can cool and solidify to form igneous rocks.

Pyroclastic Eruption

A volcanic eruption where hot fragments and magma are thrown into the air; also refers to a deposit or rock produced by such an event.

Dissolved Gas

Gas that is mixed in a solution, often referring to gases mixed in liquids such as water, which can affect water quality and marine life.