VBA(Excel) tests

[titi.duru]

Hi,

I have to make 5-10 questions for a VBA(Excel) test. It will be used to
hire a person as a VBA programmer. Can you give me a model of some
questions? I must specificy that the test is on the paper, maximum
45-60 minutes.

I will appriciate your help!
Thanks,
D

 

[Jim Cone]

Sample questions:

What is a makro?

Identify the word that is spelled correctly...
seperete
seperate
separate
saparate

The best tool for writing VBA code is ...
xl97
Lotus123
WindowsXP
Notepad

When creating new code, one should always...
(pick all that are correct)
Reset the Window zoom property.
Declare all variables.
Make sure the code font is Tahoma.
Never identify the author of the code.
=========================

<[email protected]>
wrote in message
Hi,

I have to make 5-10 questions for a VBA(Excel) test. It will be used to
hire a person as a VBA programmer. Can you give me a model of some
questions? I must specificy that the test is on the paper, maximum
45-60 minutes.

I will appriciate your help!
Thanks,
D

 

[Guest]

1. Given the string

s = "C:\MyFolders\MySubFolder\MySubSubFolder\My File Name.xls"

write a short program to extract the name of the file and display it in a
msgbox.
The program must execute successfully in xl97.

2. A commandbutton is placed on a worksheet named Sheet1. the
commandbutton has the name CommandButton3
Write the click event for this button so that when it is clicked, it will
copy the value in cell B9 of Sheet1 and place it in cell F7 of a worksheet
named Sheet2.

3. Sheet1 in a workbook contains a database starting in A1 with headers in
row1 and data below. The sheet will always have a different number of rows
and columns, but the data will always be contiguous. The cells in column C
of the database will always contain the letters "yes" or the letters "no"
make a copy of all the rows that contain a "no" in column C in a worksheet
named Sheet2. The data should be placed with the upper left corner in cell
F5 of sheet2 with the headers in row 4.

4. Use the same scenario as in problem 3, but write code to delete the rows
that contain "no" in column C.

You didn't say what the person would be doing if hired. It might be best to
focus the test on the skills required, activities to be performed. For
example, do they need to pull data from sql server or msAccess?