SPECIAL FEATURES OF EXCEL SPREADSHEET

Question 1

What is Macro?

Answer 1

Is a set of instruction that you record in Excel
and later on, it can be executed or run when it
is needed.

Question 2

Why Macro is important?

Answer 2

Macros help you to save
time on repetitive tasks
involved in data
manipulation and data
reports that are required to
be done frequently.

Question 3

Steps to create A Marco

Answer 3

1. View 2. Macros 3. Record Macro 4. Macro Name and Shortcut Key 5. OK

Question 4

Steps To Run A Macro

Answer 4

1. View 2. Macros 3. View Macros 4. Select Macro Run 5. Run

Question 5

IF FUNCTION

Answer 5

If there is a condition, there will be 2 values, TRUE/ FALSE

The outcome will be TRUE value. If condition is not met, the
outcome will be FALSE value.

Question 6

NESTED IF FUNCTION

Answer 6

The IF function that becomes the TRUE value in another function