Excel Unit I

Question 1

A single instruction that expands automatically into a set of instructions to perform a particular task.

Answer 1

Macro

Question 2

Is a hidden workbook in your system that opens whenever you open the excel application it’s a place where you can store macro codes and then access these macros from any workbook.

Answer 2

Personal Macro Workbook

Question 3

A piece of code which is capable of copying itself and typically has a detrimental effect such as corrupting the system or destroying data.

Answer 3

Virus

Question 4

Time is a phase of a computer program in which the program is run or executed on a computer system.

Answer 4

Run

Question 5

Is a tool used to define performance indicators it is key to ensuring indicator data quality and consistency.

Answer 5

External Reference Indicator

Question 6

Is the set of instructions forming a computer program which is executed by a computer this source code is translated into machine code by a compiler or interpreter so that the computer can execute it to perform tasks.

Answer 6

Program Code

Question 7

A computer programming language that allows for the creation of user defined functions and the automation of specific computer processes and calculations.

Answer 7

Visual Basic for Applications

Question 8

Is a selection of independent electronic circuits packaged onto a circuit board to provide a basic function within a computer an example might be an inverter or flip flop which would require two or more transistors and a small number of additional supporting devices.

Answer 8

Module

Question 9

Is a tool used to create modify and maintain visual basic for applications procedures and modules in Microsoft office applications.

Answer 9

Visual Basic Editor