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