Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA(Excel) tests
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA(Excel) tests
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. ========================= wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA(Excel) tests
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? -- Regards, Tom Ogilvy " wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel tests | Excel Worksheet Functions | |||
Anova tests in excel | Excel Discussion (Misc queries) | |||
Allow more than 7 nested IF THEN tests in EXCEL. Allow 30 or more | Excel Worksheet Functions | |||
Tests for Normality in Excel | Excel Discussion (Misc queries) | |||
Average a group of tests for grade, some tests not taken by all. | Excel Discussion (Misc queries) |