Question

mention one benefit of using macros​

Answer 1

Answer:

One advantage is that You can use simple small names for a number of statements. You can even define macros for functions. When writing macros for functions, they saves a lot of time that is spent by the compiler for invoking / calling the functions. Hence, The advantage of a macro over an actual function, is speed.

Answer 2

Macros automate common and repetitive keystrokes that you use in Excel to create and edit spreadsheets. By reducing the number of keystrokes required to perform common commands, macros speed up your production and reduce the time you have to spend staring at an electronic spreadsheet each day.

Regards

Best of Luck