Excel VBA Excel VBA Data Manipulation & Arrays 2

Question 1

Which VBA method copies a range of cells to another location?

Accepted Answer

Range.Copy()

Answer

Range.Transfer()

Answer

Range.Move()

Answer

Range.Clone()

Question 2

How do you find the last used row in column A using VBA?

Accepted Answer

Cells(Rows.Count, 1).End(xlUp).Row

Answer

Range("A1").LastRow

Answer

Cells.LastRow(1)

Answer

ActiveSheet.UsedRange.Rows

Question 3

Which VBA property returns the number of rows in a worksheet?

Accepted Answer

Rows.Count

Answer

Rows.Total

Answer

ActiveSheet.RowCount

Answer

Sheet.MaxRows

Question 4

What does the Range.AutoFilter method do in VBA?

Accepted Answer

Applies or removes dropdown filter controls on a range

Answer

Sorts the range alphabetically

Answer

Fills missing values automatically

Answer

Groups rows by value

Question 5

In VBA, which method deletes all content and formatting from a range?

Accepted Answer

Range.Clear()

Answer

Range.Delete()

Answer

Range.Erase()

Answer

Range.Reset()

Question 6

What does the Transpose function do when used with VBA Range data?

Accepted Answer

Converts rows to columns and columns to rows

Answer

Sorts data in reverse order

Answer

Removes duplicate values

Answer

Formats data as a table