Quiz 1 - What is VBA

In Switching a range to cells, a column is

(x)

In Switching a range to cells, a row is

(y)

In switching a range to cells, what is formula?

(y, x)

What is the Offset formula?

=OFFSET(ref cell (origination),row, column)

What does starting a line with an apostrophe mean in VBA code?

A comment and shows in green font

What is a dot(.) in hierarchy?

A key word

In Object Hierarchy, an application is

An empty cell

What symbol do you use to make an Assignment in VBA?

Equal Sign =

What does adding Select do in VBA?

It means highlight

What does OOP stand for?

Object Oriented Programming

What does an Assignment in VBA do

Pushes the value from the right to the left

What is a Loan Object Method?

Returns values, runs actions

What does the F8 button on the keyboard do?

Runs one line at a time in the code

How do you refer to a specific Sheets in VBA?

Sheets("Sheet1")

What is a Loan Object Property?

Stores values, no actions

How do you refer to a specific workbook in VBA?

Workbooks("FileName.xlxm")

How do you refer to a specific Worksheet in VBA?

Worksheets("Worksheets"Sheet1")

Can there be multiple lines of comments in VBA code

Yes

If a function has dots like NORM.S.DIST what do you do to dots in VBA?

change to underscores

In Object Hierarchy, a workbook is

single excel file