While writing a formula, what are some ways to insert a cell reference into the formula? Check all that apply.hovering the mouse pointer over the cell to referencetyping the cell name, such as “B4”clicking the cell to referencezooming in on the cell to reference
Answer
A
hovering the mouse pointer over the cell to reference
B
typing the cell name, such as “B4”
C
clicking the cell to reference
D
zooming in on the cell to reference
Explanation
You can insert a cell reference by typing its address, such as B4, directly into the formula. You can also click the cell while entering the formula, and its reference will be added. Hovering over a cell or zooming in does not insert its reference.
AI-written and checked against the verified answer.