G08- ICT Q1 Reviewer

What is the purpose of a function in VBA?

• To calculate and return a value

• To perform a specific task without returning a value

• To format cells in Excel

• To create charts in Excel

What does the Workbook Object allow you to do in MS Excel VBA?

• Interact with worksheets

• Resize column widths

• Change font colors

• Create new formulas

To access the first cell in a worksheet, you can use:

• ws.Range("A1")

• ws.FirstCell

• ws.TopLeftCell

• ws.Cells(1, 1)

Which loop structure can you use to write data to a range of cells in a column?

• Do until

• For each

• For

• While

Which of the following is NOT a characteristic of a subroutine?

• It groups instructions together

• It can return a value

• It performs a specific task

• It is used for calculations

When reading data from cells in Excel VBA, which property is commonly used?

• Value

• Text

• Data

• Content

What does the Workbook Object represent in Excel VBA?

• A VBA code module

• A specific range of data

• An Excel file containing worksheets

• A single cell in a worksheet

When using the Cells property, what does the first argument represent?

• The worksheet index

• The row number

• The column number

• The cell address

What is an argument in a function?

• A keyword in Excel

• A value passed to the function

• A variable used in calculations

• A value returned by the function

A key benefit of writing data to cells using VBA is __________ tasks that require changing cell values.

• Resuming

• Formatting

• Automating

• Deleting