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.