Mice Operations Executive Interview Questions and Answers

A formula is an expression that performs calculations on values in a cell, while a function is a predefined formula that performs specific calculations.

• Formulas are user-created expressions, while functions are built-in formulas provided by Excel.

• Functions have specific names and syntax, such as SUM(), AVERAGE(), IF(), etc.

• Formulas can be simple or complex, combining operators, cell references, and values.

• Functions are designed to perform specific tasks, like summing a range ...read more

Freezing panes in Excel allows you to keep certain rows or columns visible while scrolling through a large spreadsheet.

• Go to the View tab on the Excel ribbon

• Click on the Freeze Panes option

• Select either Freeze Top Row, Freeze First Column, or Freeze Panes to freeze specific rows or columns

• To unfreeze panes, go back to the Freeze Panes option and select Unfreeze Panes