Formulas are used in MS Excel due to their trait of performing several tasks and operations automatically. Also, the users are allowed to use cell references or type numbers directly into the formulas. This lets the formulas to use whatever data is contained in the reference cells.

BY Best Interview Question ON 01 Apr 2019