Use the Following Information to Answer the Question(s)below

question 53

Multiple Choice

Use the following information to answer the question(s) below.Consider the following four alternatives:
1.$132 received in two years.
2.$160 received in five years.
3.$200 received in eight years.
4.$220 received in ten years.
-The ranking of the four alternatives from most valuable to least valuable if the interest rate is 7% per year would be:

• A)1,2,3,4.
• B)4,3,2,1.
• C)3,4,2,1.
• D)3,1,2,4.

---

Definitions:

Named Range

A feature in spreadsheet software that allows users to assign a name to a cell range for easier reference.

Dialog Box

A small window that appears in a user interface to communicate information to the user and solicit a response.

User Name

A unique identifier selected by or assigned to an individual user to gain access to a computer system or online service.

Encrypt

The technique of converting data or information into an encoded format to block unauthorized access.