NEW
Font size
WorksheetsG08- ICT Q1 Reviewer
Total questions: 20
Worksheet time: 10mins
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
What is the main benefit of using Worksheet and Cell Objects in Excel VBA?
It helps you export data to external databases.
It allows you to create new Excel formulas.
It enables you to change the appearance of Excel toolbars.
It lets you interact with and manipulate data within Excel worksheets.
When reading data from cells, why is it recommended to specify the worksheet?
To slow down the code execution
To avoid using the Range object
To improve memory usage
To avoid ambiguity between worksheets
How can you create a Workbook Object to open an existing workbook?
Using the Workbook keyword
Using the Worksheet keyword
Using the Range keyword
Using the Chart keyword
To access the content of a specific cell in Excel VBA, you use the __________ object.
Workbook
Cell
Worksheet
Range
What is a key benefit of reading data from cells using VBA?
Creating new worksheets
Automating data extraction and analysis
Deleting entire rows
Changing cell formatting
When using the Cells property, what does the second argument represent?
The cell address
The column number
The worksheet index
The row number
Which of the following is an example of a function?
Sub Print Sheet () End Sub
Function Calculate Average () As Double End Function
Sub Format Text () End Sub
Sub Copy Range () End Sub
The Worksheet and Cell Objects are most commonly used for:
Writing reports and essays
Automating tasks and data manipulation
Creating new Excel functions
Customizing the Excel interface
What is VBA?
A new version of Microsoft Office
A programming language for Excel
A web browser
A type of virus
What can you access and modify using the Workbook Object?
Only cell values
Only formatting options
Aspects of a workbook like worksheets and properties
Only VBA code modules
