Flashcards
Macros
Cards in this deck (16)
- 1Macroa series of commands, actions, and functions that can be stored and initiated (run) whenever you want to perform a particular task.
- 2A macro is essentially...a program
- 3What does a macro do in Excel?macros provide a set of instructions to Excel that indicate which commands Excel should execute
- 4What programming language are macro instructions written in?visual basic
- 5In Visual Basic terminology macros are referred to as...procedures
- 6Why would a business use macros in Excel?to simplify data and alleviate tedious computer tasks
- 7Visual Basic for Applications (VBA)a programming language you can use to create macros
- 8What programming language is VBA a descendant of?BASIC (used in Microsoft Office)
- 9Visual Basic Editor (VBE)- all macros created in Excel are stored here - new macros can be created, and previously created macros can be edited or deleted here.
- 10What is VBE used for?VBE provides advanced editing capabilities including automatic syntax checking, tips and quick information, color coded programs for readability, etc
- 11Where can you access VBE?in the Developer tab within Excel
- 12Visual Basic Commandsthe steps of a macro that define the macro's functionality
- 13What is another name for Visual Basic Commands?macro code
- 14What do you use to create Visual Basic commands (macro code)?we use objects, properties, methods, and variables to create Visual Basic commands, or macro code
- 153 Main Objectives of Macros- Automate repetitive Excel tasks (improves efficiency)
- Automate and control input (improves efficiency and accuracy)
- Guide users through a spreadsheet (improves efficiency and accuracy) - 163 Methods for Creating Macros- Use the Macro Recorder to record a new macro
- Write a new macro in Visual Basic Editor
- Copy, paste, and edit/customize a previously created macro
Information
- Description
- Business/Economics Flashcards on Macros, created by Kennadie Long on 29/11/2018.
- Created by
- Kennadie Long
- Views
- 0
- Rating