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:

Previous Cell

In spreadsheet applications, it refers to the cell that is immediately before the current cell in relation to the spreadsheet's grid layout.

SHIFT+TAB

A keyboard shortcut typically used to navigate back or move to the previous field or option in a GUI.

Custom Tab Stops

User-defined points in a text document where the cursor moves when the tab key is pressed, enabling customized alignment of text.

ENTER Key

A key on the keyboard used to input data, execute commands, or to move the cursor to a new line in text.