Which of the Following Happens When You Enter the Formula

question 62

Multiple Choice

Which of the following happens when you enter the formula =G15 into a cell?

• A) Excel recalculates all formulas in the worksheet
• B) Excel assigns the sum of the values in the previous 15 cells to the active cell
• C) Excel assigns the value in cell G15 to the active cell
• D) Nothing;=G15 is an invalid formula

---

Definitions:

Discount Rate

The interest rate charged to commercial banks and other depository institutions on loans they receive from their regional Federal Reserve Bank's lending facility.

Money Market Instruments

Short-term financial instruments that are highly liquid and designed for cash management by investors, including treasury bills, commercial paper, and certificates of deposit.

Government Bond

Securities issued by governments to finance public expenditure, typically with a promise of future repayment and interest payments.

State Income Taxes

Taxes levied by individual states on the income of residents and businesses within their jurisdiction.