Which of the Following Procedures Must Be Used to Create

question 35

Multiple Choice

Which of the following procedures must be used to create a named range for data in Microsoft Excel?

• A) highlight the required data → click the Formulas tab → click Define Name in the Defined Names section → enter a suitable name
• B) highlight the required data → click the Home tab → click Insert Name in the Cells section → enter a suitable name
• C) highlight the required data → click the Data tab → click Connections in the Connections section → enter a suitable name
• D) highlight the required data → click the Design tab → click Property Sheet in the Show/Hide section → enter a suitable name

---

Definitions:

Purchase-Money Security Interest

A legal claim granted to lenders over items purchased, serving as collateral for the loan used to purchase the goods.

Possession Of Collateral

Holding or control over property or assets pledged as security for a loan or obligation.

Private Sale

A transaction of goods or property conducted directly between individuals or parties without the involvement of a public auction or open market.

Public Sale

The process of selling goods or assets to the highest bidder in an open and public manner.