Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

1) Which of the descriptions listed below best describe what a macro in Excel does? Please reveal the details to choose .

  a) It is a type of formatting you can apply to enlarge the worksheet area. 

  b) It is a file type that you save a workbook as. 

  c) It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks. 

  d) It is a recording function that allows you to save worksheets, audio recordings and videos that are displayed on the screen. 

 

macro in excel

user-image
Question added by Ghada Eweda , Medical sales hospital representative , Pfizer pharmaceutical Plc.
Date Posted: 2016/06/24
Ghada Eweda
by Ghada Eweda , Medical sales hospital representative , Pfizer pharmaceutical Plc.

Oh! all answers are amazing.

Thank you Excel's professionals for sharing your knowledge.

Cheers

emoji

Cristian Florin Dascalu
by Cristian Florin Dascalu , IMG Executive (IT / Software) , Wipro Technologies

C- It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks.

A macro can be defined as the recording of a series of tasks. It’s the simplest form of automation – show a software program the steps you follow to get something done, and the software will follow along. When used right, macros can save you hours by automating simple, repetitive tasks.

 

Marcos in Excel are written in Excel VBA (Visual Basic for Applications). This is a version of Visual Basic (a prominent Microsoft programming language) developed specifically for use in Office-like applications. Creating simple macros – copy a formula from one cell to another, for instance – is fairly easy. Complicated macros require a bit more work. You’ll need to be quite intimate with Excel VBA to automate the more complex tasks in your workflow

mohamed Hakim CMA CPA Candidate
by mohamed Hakim CMA CPA Candidate , Accounting Manager , Andersen saudi arabia

Answer C. It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks. Like visual basic coding Microsoft programming language inside excel file I use it some times to reconcile large Dada files No one can use it effectively except programmers on visual basic

Deleted user
by Deleted user

thank you miss ghada It is the series of commands recorded in one macro to save your time and no need to repeat those things again. just only play macro to perform on behalf of you.  Option C

Bassam Ali Mohammed Al-mamari
by Bassam Ali Mohammed Al-mamari , مساعد الرصد والتقييم , برودجي سيستمز

If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks. A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes." according to the above defination, we can select option 'c'

  c) It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks. 

 

 

Gayasuddin Mohammed
by Gayasuddin Mohammed , Advocate , Practicing Law before High Court at Hyderabad

c) It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks.

Macro is a function written by the user/programmer with the set of instructions in one capsule to use it whenever is required or for repetitive tasks.

my 2 cents. thanks.

yasser talaat
by yasser talaat , accountant manager , الشركه المصريه

thankss to invitation me

i am agreement with others answers

Shameer Nazir Madari
by Shameer Nazir Madari , Assistant Finance Manager , METAL AND RECYCLING COMPANY K.S.C. (PUBLIC)

what a macro in Excel does

Answer is

c) It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks. 

 

 

By running a macro, users are able to trim down time normally consumed by repetitive tasks. Some macros, like the ones in MS Excel, may also contain functions. An Excel macro is typically created by recording a sequence of keyboard and mouse actions using the Macro Recorder. It can also be created using Visual Basic (because even a recorded macro is made up of Visual Basic code). A stored macro can then be accessed from a menu list or from the toolbar and run by simply clicking. You can also assign a hotkey to the macro for even faster access. Since macros can be called automatically as soon as a digital document is loaded, they have been employed by malicious individuals for creating macro viruses. In the 1990s, unsuspecting users were often terrorized by screens that seemingly displayed characters on their own or mouse pointers that clicked on buttons or highlighted text.

Hussein Mostafa Salem Radwan
by Hussein Mostafa Salem Radwan , مدير مالى , مجموعة شركات الترا اليتينج تكنولوجى ) لالضاءة – لالستيراد والتصدير – الترا باور – اوميجا – بيجا – ال

Thanks for the invitation

Certainly the answer is (c) 

 

 

 

 

manseer muhammed ali
by manseer muhammed ali , Accountant General , Royal Lighting L.L.C & Royal Furnishing LLC

macro in Excel  c ) It is a series of instructions contained in one command that you can use to automate complex and/or repetitive tasks. 

danish shafiq
by danish shafiq , Accountant , Anayat Fan

correct option is "C" which is "It is a series of instructions contained ......."

More Questions Like This