Case EX 2-2 Iris Has Created an Invoice Using Excel

question 4

Multiple Choice

Case EX 2-2 Iris has created an invoice using Excel. Now she needs to alter the structure of the worksheet by making changes to the rows and columns. When Iris deletes rows or columns from her worksheet, the rows beneath the deleted row and the columns to the right of the deleted column automatically shift ____ to fill the space.

• A) up or left
• B) up or right
• C) down or left
• D) down or right

---

Definitions:

Maturity Value

The amount payable to the investor at the end of a fixed-term investment, including both the principal and the interest.

Compounded Semi-Annually

This refers to the process of calculating interest on the initial principal and the accumulated interest over two periods within a year.

11%

11% typically refers to an interest or annual rate, indicating that 11 percent of the principal amount will be paid in interest over a year.

Nominal Rate

The promoted or declared rate of interest on a loan or investment, excluding the impacts of compounding and inflation.