Arithmetic operations, cell references, and __________ can be used in Excel formulas.
constants
macros
programs
procedures
is it A
2Using the mouse to select a specific cell is when creating a formula is called:
sizing.
moving.
accessing.
pointing.
is it D
3.To ensure that the reference to a specific cell does not change, use __________ cell referencing.
relative
absolute
abstract
mixed
Is it B
Yes
Yes, your answers are correct!
1. Arithmetic operations, cell references, and constants can be used in Excel formulas. Therefore, the answer to the first question is A) constants. When creating formulas in Excel, you can use arithmetic operations (such as addition, subtraction, multiplication, and division), cell references (to refer to the value in a particular cell), and constants (specific values that are entered directly into the formula).
2. When using the mouse to select a specific cell while creating a formula in Excel, this action is called pointing. Therefore, the answer to the second question is D) pointing. By using the mouse, you can click on a specific cell to reference it in a formula.
3. To ensure that the reference to a specific cell does not change when copying or moving a formula, you can use absolute cell referencing. Therefore, the answer to the third question is B) absolute. Absolute cell referencing involves adding a dollar sign ($) before the column letter and row number in a cell reference, which prevents the reference from changing when the formula is copied or moved to a different location.