Crowdly

Message

box stating “Pass”

Message

box stating “Distinction”

What

will the following VBA code do?

Range("A1:A5").Interior.Color = vbYellow

Change the background colour of cells A1:A5 to

yellow

Delete

the contents of cells A1:A5

Change

the font colour to yellow

Copy

the cells to another worksheet

For

the listed company that is Tesla. The company name Tesla can be declared as a

variable. What syntax should be used:

Dim Tesla as String

Dim

Tesla as Boolean

Dim

Tesla as Long

Dim

Tesla as Single

What

is not a benefit of VBA?

Increased efficiency

Low-cost solution

Increased accuracy

Increased emission

The

Tesla share price is currently trading at $405. The best variable to be used to

declare the share price would be:

Dim stockPrice as Single

Dim

stockPrice as Double

Dim

stockPrice as Currency

Dim

stockPrice as Integer

Which

VBA statement will correctly assign the value 250 to cell B5?

Range("5B")

= 250

Range(B5)

= 250

Cells(B,5)

= 250

Cells(5,2) = 250

What

is the purpose of the following VBA code?

Worksheets("Sheet1").Activate

Deletes

Sheet1

Makes Sheet1 the active worksheet

Hides

Sheet1

Renames

Sheet1

Why is adding comments to your code important?

To clarify the logic and purpose

of the code

ensure the code runs without errors

increase the execution speed of the program

automatically generate program documentation

To enable VBA to run in Excel files it should be

saved as:

.pdf

.xlsx

.csv

Define

what is an input box in VBA.

Represents

an independent variable that enters a formula.

A simple dialog box that allows a user to make a

single entry.

special type of Visual Basic window which can display a message to the user.

What

is put in by any process or system.