Studied by 1 person
Excel macro
action or a set of actions that you can record, give a name, save and run as many times as you want and whenever you want
run a saved macro
the recorded mouse clicks and keystrokes will be executed in the same sequence as they are recorded.
Visual Basic for Applications
VBA
Excel Visual Basic Editor
VBE
malicious code
As with the case of any other code, macro code is also susceptible to ____ that can run when you open a workbook.
Macro Security facility
Microsoft provided the ___ that helps you in protecting your computer from such macro viruses.
Absolute references
make your macro run at the same cells where you recorded the macro
relative references
make your macro run at the active cell.
shape, graphic, control
You can assign a macro to an object such as a __ or a -- or a ---.
several ways
Excel provides ___ to run a macro
Form
is normally used to collect required information.
Debugging
stands for the process of finding and fixing errors or bugs in the source code of any software.
TODAY
is a function that makes the dates in your Google Sheets update automatically.
TEXT
is a function to convert numbers into currency or to change a date string into a MM/DD format.
SPLIT
is a function that is used to split or divide data from single cells into multiple cells.
SEARCH
This Google Sheets formula allows you to check whether a value exists in a string.
CONCATENATE
is a function used to combine the contents of two or more cells into a third separate cell.
IMPORT RANGE
is a simple yet powerful function that helps you import a range of cells from a specified spreadsheet.
TRue
In Excel and Google sheets , you can change the macro security settings to control which macros run and under what circumstances when you open a workbook.
Very High
In the __ security level all Macros are disabled without any notification.
Medium
In the __ security level all Macros are disabled but with a notification.
Low
In the __ security level all macros are run without restrictions.Enabling all macros
Steps Excel
To record a new Macro in Microsoft Excel do the following – A)Click the VIEW tab on the Ribbon. B)Click Macros in the Macros group. C)Select Record Macro from the dropdown list.
Steps Google Sheets
To record a new Macro in Google Sheets do the following:
On your computer,
A)Open a spreadsheet at sheets.google.com.
B)At the top, click Extensions Macros. Record macro.
C)At the bottom, choose which type of cell reference you want your macro to use: ...
D)Complete the task you want to record. ...
E)Name the macro, create a custom shortcut, and click Save.
Dialog box steps
The Record Macro dialog box appears. Type MyFirstMacro in the Macro name box. Type the name of the macro(ex.Temp_Macro 2) in the Description box and click OK.
True
Whatever keystrokes and mouse clicks you do, will be recorded now.
Run macro Excel
To run the macro in Excel: Click on a new worksheet. Click the VIEW tab on the Ribbon. Click Macros. Select View Macros from the dropdown list
Run macro Sheets
To run a Macro in Sheets: click Extensions and then Macros and then the macro you want.(ex)Macro 1 ,Temp_Macro2
True
Only the macro that you recorded appears in the Macros list.
Uniform resource locators(URL)
192.10.1.2 or 172.10.22.1 are examples of ___,also known as web addresses.
Really Simple Syndication (RSS)
It is an easy way for people to keep up with news and information that is important to them.
GROWTH
The ___ function will help you fit an ideal exponential growth trend, and give you data about said growth trend.
SUBSTITUTE
The ___ function is used to change an existing text with new text in a particular string.
TRANSPOSE
function, lets you convert row-wise data into column-wise and vice versa.
Budget
A ___ is an estimate of income and expenditure for a set period of time.
Income
is money received, especially on a regular basis, for work or through investments.
expense
An ___ is the cost incurred in or required for something.
transaction
A ___ is an instance of buying or selling something.
Note 
Flashcard (20)