Perficient Finance Executive Interview Questions and Answers

Macros in Excel are automated tasks that can be created using Visual Basic for Applications (VBA) to perform repetitive actions.

• Macros can be recorded or written manually using VBA code.

• They can automate tasks such as formatting, data manipulation, and report generation.

• Macros can be assigned to buttons or keyboard shortcuts for easy access.

• They can save time and reduce errors by automating repetitive tasks.

• Example: Cr...read more

Merging cells in Excel allows you to combine multiple cells into one larger cell.

• Select the cells you want to merge

• Right click and select 'Merge Cells' from the dropdown menu

• The content of the upper-left cell will be kept, while the rest of the cells' content will be deleted

• Merged cells cannot be unmerged, so be careful when merging