Question

Which is a true statement concerning basic formulas in Excel?

a. Formulas will not change automatically if the user utilizes the formula bar
b. The user needs to alter the formula when entering new data into applicable cells
c. Formulas will change automatically if the user utilizes the Formula Bar
d. The user does not need to alter the formulas when entering new data into the applicable cells

Answer 1

The true statement about basic formulas in Excel is that the user does not need to alter the formulas when new data is entered into the cells referenced by the formula. Excel will automatically recalculate the result.

Step-by-step explanation:

The correct statement concerning basic formulas in Excel is that the user does not need to alter the formulas when entering new data into the applicable cells.

Excel is designed to automatically recalculate formulas when the data in the cells that the formula references change. It means that if you have a sum formula in one cell, and you update the numbers that are being summed, the total will update without needing to edit the formula itself. This functionality is part of what makes Excel a powerful tool for data analysis and computations.

Whether you use the formula bar or not does not affect the automatic recalculations of formulas.