1. When a macro/module is running, what command do you use to stop the screen from changing?
Application.ScreenUpdating = False
Application.Echo = False
Application.ScreenFixed = True
Application.FreezePanes = True


2. In VBA, how do you select a worksheet called "Sheet1"?  
Workbooks.Worksheet.Activate("Sheet1")
With.Selection("Sheet1").Activate
Sheets("Sheet1").Select
Application("Sheet1").Select


3. What line of code would you use to select cells F3:G5, if they were a range named "MyRange"?
Range(Cells(3,6),Cells(5,7)).Select
Range("MyRange").Select
Range("F" & "3:G" & "5").Select
All of the above


4. Look at the code below:

 Sub Cleveregg()
   Range("A1").Select
   For i = 1 To 9
     ActiveCell.Value = i
     Activecell.Offset(0,1).Select
   Next i
 End Sub

Where would the cell cursor be after this module runs?
A1
J1
A10
K10


5. Using the code above, what value would be in the cell F1?
1
5
6
9


6. If you want to make the Sheet tabs disappear at the bottom of the workbook, which would you use?
Workbooks.SheetTabs = Hidden
ActiveWindow.DisplayWorkbookTabs = False
CurrentWorkbook.Tabs.Hide = True
Activeworksheet.DisplayTabs = False


7. In a workbook with 2 sheets, if you wanted to hide the sheet "Sheet2" programatically, what statement would you use?
Sheet2.Visible = -1
Sheet2.Invisible = True
Sheet2.Visible = xlSheetHidden
Sheet2.VeryHidden = True


8. You want to run another module called 'CalcSheet' from within a subroutine, what statement do you use?
Branch CalcSheet
Run CalcSheet
Call CalcSheet
Goto CalcSheet


9. To add a sheet called "MySheet" to the current workbook, which piece of code would you use?
Sheets.Add("MySheet")
Worksheet("MySheet").Add
Worksheet.New("MySheet").Add
Worksheets.Add().Name = "MySheet"


10. To put the value "99" in cell A1 of the current worksheet, what answer is correct?
A1 = 99
Range.A1 = 99
Range("A1").Value = 99
Range("A1").Cell.Value = 99