Computer / II Semester I Partial

**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.