Excel : Active Cell and workBook

Full Name

Student ID

What is the meaning of Range("A1").Cells in Excel VBA?

• Range

• Property of Object

• Property of Range object

• Method of Range object

Which of the following statements correctly describes the difference between Range("E11") and Cells(11, 5) in Excel VBA?

• Range("E11") is more flexible for dynamic referencing than Cells(11, 5).

• Range("E11") references a cell using A1 notation, while Cells(11, 5) references a cell using row and column numbers.

• Range("E11") and Cells(11, 5) refer to different cells in the worksheet.

• Range("E11") is used for multiple cells, while Cells(11, 5) is used for a single cell.

How do you offset rows in Excel VBA to select a range of cells starting from the active cell and extending 2 rows down?

• Range(ActiveCell.Offset(1, 0), ActiveCell.Offset(2, 0)).Select

• Range(ActiveCell.Offset(0, 1), ActiveCell.Offset(1, 2)).Select

• Range(ActiveCell.Offset(1, 0), ActiveCell.Offset(2, 1)).Select

• Range(ActiveCell.Offset(2, 0), ActiveCell.Offset(1, 1)).Select

How can you move the active cell to the next empty cell in the current column?

• ActiveCell.End(xlDown).Activate

• ActiveCell.Offset(1, 0).Activate

• ActiveCell.End(xlDown).Select

• ActiveCell.SpecialCells(xlCellTypeBlanks).Activate

Which of the following is NOT a valid Orientation property for a PivotField?

• xlPageField

• xlRowField

• xlColumnField

• xlDataCache

Which of the following statements will change the caption of a PivotField in a pivot table?

• .PivotFields("Sum of Sales").Name = " Sales"

• .PivotFields("Sum of Sales").Label = " Sales"

• .PivotFields("Sum of Sales").Caption = " Sales"

• .PivotFields("Sum of Sales").FieldName = " Sales"

Which argument is used in the Group method to specify the grouping date data in a pivot table?

• Start

• End

• By

• Periods