Exam 3 Flashcards

1
Q

The leftmost worksheet

A

Worksheets(1)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Close active worksheet

A

ActiveSheet.Delete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Delete worksheet Sheet5

A

Worksheets(“Sheet5”).Delete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Copy Sheet3 to a new workbook

A

Worksheets(“Sheet3”).Copy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Copy active worksheet and place after Sheet3

A

ActiveSheet.Copy After=“Sheet3”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Make Chart3 the active sheet

A

Sheets(“Chart3”).Activate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Create a new worksheet

A

Worksheets.Add

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Select cell B1

A

Range(“B1”).Select

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Auto fit columns A,B,C on first sheet

A

Worksheets(1).Columns(“A:C”).AutoFit

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Put value 30 in cell A1

A

Range(“A1”) = 30

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Rename the active sheet Results

A

ActiveSheet.Name = “Results”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Put an “x” in same row, 1 column to the right of the active cell

A

ActiveCell.Offset(0,1) = “x”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Select the cell 1 row below, in the same column as active cell

A

ActiveCell.Offset(1,0).Select

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Add the formula SUM(B2:C2) to cell D2

A

Cells(2,4).Formula = “=SUM(B2:C2)”

D2 is the second row, 4th column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Clear values from cell A2

A

Range(“A2”).Clear

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

X= array(“data”, 1,2,3)

A

Stores values into array x

X(0)= data
X(1)= 1
17
Q

Declare myrow as an array with 3 values

A

Dim myrow(3) as Variant

18
Q

Align selected cell to the right of cell

A

Selection.HorizontalAlignment= xlRight

19
Q

Ask user “How old are you?” And set value they enter to q

A

q= InputBox(“How old are you?”)

20
Q

Select Sheet3 as the Active Sheet

A

Worksheets.(“Sheet3”).Activate

21
Q

Display a message box asking to continue and end if the selection is no

A

If MsgBox(“Continue?”,4) = vbNo Then End