VMerudi
8

Dear all,
How do we test whether a candidate is having good knowledge of MS Office before hiring them for a position which requires MS Office?
Are there different ways of testing computer literacy of applicants?
Please let me know.
Thanks and Regards
Vijaya

From India, Bangalore
VMerudi
8

Dear all,
I am sure soem of you would be testing the computer skills of candidates who are applying for job that requires computer skills.
Do share the various methods of testing this skill among job applicants.
Thanks and Regards

From India, Bangalore
sonanm
Yes one can easily grade a applicant on his/her MS-Office skills. One needs to assign some small office daily work and tell them to finish in front of you.
Recently i had to interview applicant for teacher''s job where in i have to check their competency in MS-office.
I simply put some exercise in front of them
1.Mail merge - When same mail content needs to be send to multiple people.Mostly used in results.
2.Prepare result in excel sheet - It will tell you whether applicant really make use to inbuilt functions.
3.proper documentation style.Give them a article and tell them to write in the same way.
There are more exercise you can create based on the position and compare who is quickly solving it .
Thanks

From India, Ahmadabad
veeraj
Take 3 different test modules. But I will suggest you to take the test as per your need. Say, if there is more work in outlook, ask them to prepare a V-card to store info, auto reply, signature, etc.
For word - Take test for page formatting like margins, paper size, head-footer etc.
For Excel - ask to calculate simple formulas like Sum, division, %age, average, auto fill, graphs, etc.
for PP - ask to create presentation.
Hope this will works out.

From India, Delhi
prashant_zcs
[
Dear Mr Vijay,
Please visit this link it might help you .
www.chaminade.org/MIS/Tutorials/Quizzes/BasicWordQuiz1.htm
Regards
Prashant
quote=VMerudi;527598]Dear all,
How do we test whether a candidate is having good knowledge of MS Office before hiring them for a position which requires MS Office?
Are there different ways of testing computer literacy of applicants?
Please let me know.
Thanks and Regards
Vijaya[/quote]

From India, Madras
spkguj2002@yahoo.com
Dear Vijaya
Testing of MS office Skills are simple. Just give the candidate a letter (drafted by your self, put some mistakes by way of spellings and un-even paragraphs and let the candidate to type that letter / paragraph. If completes it with proper way (that should upto your mark) then ok.
Same way give him a ready made excel sheet and ask him to put formulas whereever it needed.
Shyam Kulkarni

From India, Bardoli
lunaluna
Hi,
I work with tests... I give them a test (IT, Office, Outlook, whatever) and then I can see the mistakes the have made.. If its good, its good, if its not... Then someone has been 'pimping' their CV!
It works efficient... Standardized tests make a big difference i have noticed!

From Netherlands, Amsterdam
prashant_zcs
Dear Vijaya,
Find enclosed questiones which are downloaded from below mentioned web link
1. In order to save an existing document with a different name you need to: Retype the document and give it a different name
Use the Save as.. command
Copy and paste the original document to a new document and then save
Use Windows Explorer to copy the document to a different location and then rename it
2. Which keyboard shortcut bolds selected text?
Ctrl+B
Alt+B
File/Format/Bold
None of the above
3. How can you highlight text without using the mouse?
It is impossible
Use the F5 key
Use the arrow keys while holding down a Ctrl key
Use the arrow keys while holding down a Shift key
4. What would you see while spell checking the phrase "My father was write"?
The word "write" is misspelled
No errors
The verb of the phrase will be highlighted
A blue squiggly underline under the word "write"
5. Suddenly Word does not display your favorite toolbar. What has happened?
Your program has been infected by a macro virus
This version of Word does not support toolbars
Your toolbar option has been deleted from the menus
Your toolbar has been unchecked under the View/Toolbars menu
6. In page preview mode:
You can see all pages of your document
You can only see the page you are currently working
You can only see pages that do not contain graphics
You can only see the title page of your document
7. Which elements of a Word document can be displayed in color?
Only graphics
Only text
All elements
All elements, but only if you have a color printer
8. In order to create columnar data in Word you need to:
Tab consecutively until you cursor reaches the desired place
Set tabs or use the Table menu
You need to use Excel
Press the space bar until your cursor reaches the desired place
9. The background of any Word document:
Is always white color
Is the color you preset under the Options menu
Is always the same for the entire document
Can have any color you choose
10. In Word you can force a page break:
By positioning your cursor at the appropriate place and pressing the F1 key
By using the Insert/Section Break
By positioning your cursor at the appropriate place and pressing Ctrl+Enter
By changing the font size of your document
1. Why the document you created at home displays with a different font at school?
Because you have a different printer at school than at home
Because you have a different monitor at school than at home
Because the font you used at home is not installed on your school computer
Because the version of Windows is different
2. Which keyboard shortcut centers selected text?
Ctrl+C
Alt+C
There is no keyboard shortcut for this operation
Ctrl+E
3. What is the default file extension for all Word documents?
TXT
WRD
FIL
DOC
4. Which key moves your cursor from one cell to the next in a table?
Tab
Shift
Enter
Ctrl+Enter
5. How many different documents can you have open at one time?
No more that three
Only one
As many as your computer memory will hold
No more than your Taskbar can display
6. In order to email a Word document from within Word:
Go to File/Send To/Mail Recipient
Save the file as an email attachment
Start Outlook and attach the file while open in Word
This is an impossible operation
7. Which keystroke will take you at the beginning or the end of a long document?
Ctrl+PageUp and Ctrl+PageDown
Shift+Home and Shift+End
Ctrl+Home and Ctrl+End
The only way is by using the right scroll bar
8. How many margins are on a page?
Two (header and footer)
Four (top, bottom, right, left)
Two (landscape and Portrait)
Two (top and bottom)
9. In order to save a Word document as a web page you need to:
Put the appropriate graphics and links on the document
Save the document in simple text format
Use your web browser as an editor and save as URL
Save as HTML
10. A document in portrait prints:
The same characters per line with the same document in landscape
More characters per line than the same document in landscape
Less characters per line than the same document in landscape
Smaller fonts in order to fit the same amount of characters per line with landscape
1. Which of the following font sizes are not supported by Word?
12
72
533
All of font sizes above can be used by Word
2. The best way to automatically include your headlines in a table of contents is to:
Manually type them
Use Word's built-in heading styles
You can not automatically create a table of contents in Word
Choose Style, Add to TOC
3. Pressing the [Tab] key while in the last cell of a table will:
Add a new row
Take you to the top of the table
Delete the table
Add a tab character
4. If you [Apple] click (Mac) or [Ctrl] click (PC) a sentence, what happens?
Nothing
The sentence is selected
The sentence is deleted
The sentence is copied to the clipboard
5. By default, how much will the Increase Indent tool indent your paragraphs?
1 inch
1/2 inch
1/4 inch
3/4 inch
6. How many master documents can you have per document?
1
2
3
4
7. Which of the following can't be included in a character style sheet
Keyboard Shortcuts
Line Spacing
Font color
Font Size
8. You use sections to:
Create newspaper-style layouts
Vary page numbering
Have multiple headers and footers
All of the above
9. Which of the following views will NOT show your headers and footers?
Page Layout
Print Preview
Normal
All of the views show headers and footers
10. During a mail merge, which document contains the information that will not change?
Main
Data
Merge
None of the above
11. What kind of style is NOT supported by Word?
Character
Printer
Paragraph
None of the above
12. Pick the kind of tab that Word does not support:
Left
Center
Decimal
Flush
13. Where should a template be stored?
Somewhere on the hard drive
The templates folder
It doesn't matter as long as you know where and can open them
Word's Reference Files folder
14. Selecting all of your text and then pressing [F9] on your keyboard will:
do nothing
Update all field codes
Convert your document to HTML
Set the default Font Size to to 9
15. Which of the following color models does Word support:
RGB
CMYK
All of the above
MS Excel
1. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
Right click on the spreadsheet tab and select DELETE
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
2. What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells ?
F3 F5 F7 F9 F11 F13
3. Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?
Count Average Sum
4. Which of these will NOT select all the cells in a document ?
Clicking three times with the right mouse button in the spreadsheet
Using the Edit - Select All menu item
Pressing CTRL + A on the keyboard
5. Which of the following describes how to select all the cells in a single column ?
Right click on column and select Pick From List
Use the Data - Text to Columns menu item
Left click on the gray column title button
Pressing CTRL + A on the keyboard
6. When you see a cell with a red triangle in the top right corner, what does this signify ?
[IMG]file:///C:/DOCUME%7E1/PRASHA%7E1/LOCALS%7E1/Temp/msoclip1/01/clip_image001.gif[/IMG]
There is an error in the cell
There is a comment associated with the cell
The font colour for text in the cell is red
A formula cannot be entered into the cell

7. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values ?
[IMG]file:///C:/DOCUME%7E1/PRASHA%7E1/LOCALS%7E1/Temp/msoclip1/01/clip_image002.gif[/IMG]
[IMG]file:///C:/DOCUME%7E1/PRASHA%7E1/LOCALS%7E1/Temp/msoclip1/01/clip_image003.gif[/IMG]
[IMG]file:///C:/DOCUME%7E1/PRASHA%7E1/LOCALS%7E1/Temp/msoclip1/01/clip_image004.gif[/IMG]

8. Which of the following will NOT set text in selected cells to ITALICS ?
Pressing CTRL + I on the keyboard
Using the Tools - Wizard - Web Form menu item
Using the Format - Cells - Font menu item
9. Is it possible to insert an image from a file into an Excel spreadsheet ?
Yes No
10. Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?
Yes No
1. On an Excel sheet the active cell is indicated by ____.
a. a dark wide border
b. a dotted border
c. a blinking border
d. none of the above
2. To select a column the easiest method is to _____.
a. double-click any cell in the column
b. drag from the top cell in the column to the last cell in the column
c. click the column heading
d. click the column label
3. If you press _____, the cell accepts your typing as its contents but the focus stays in the cell.
a. ENTER
b. CTRL + ENTER
c. TAB
d. INSERT
4. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.
a. B1-G10
b. B1.G10
c. B1;G10
d. B1:G10
5. The view that puts a blue line around each page that would be printed is the _____.
a. Print Preview
b. Normal
c. Page Break Preview
d. Split View
6. To select several cells or ranges that are not touching each other, you would _____ while selecting.
a. hold down the CTRL key
b. hold down the SHIFT key
c. hold down the ALT key
d. hold down CTRL + SHIFT
7. To create a chart with the Chart Wizard, you would use which button?
a. [IMG]file:///C:/DOCUME%7E1/PRASHA%7E1/LOCALS%7E1/Temp/msoclip1/01/clip_image005.gif[/IMG]
b. [IMG]file:///C:/DOCUME%7E1/PRASHA%7E1/LOCALS%7E1/Temp/msoclip1/01/clip_image006.gif[/IMG]
c. [IMG]file:///C:/DOCUME%7E1/PRASHA%7E1/LOCALS%7E1/Temp/msoclip1/01/clip_image007.gif[/IMG]
d. [IMG]file:///C:/DOCUME%7E1/PRASHA%7E1/LOCALS%7E1/Temp/msoclip1/01/clip_image008.gif[/IMG]
8. Using the AutoSum button will place in the selected cell _____.
a. the sum of values in the cell's column
b. nothing until you select a range of cells
c. the sum of the cell's row unless you change the range
d. a formula which will add values in the range Excel guesses you want to add
9. AutoCalculate will quickly add selected cells if you _____ .
a. right-click on the status bar and select SUM
b. click the AutoCalculate button on the toolbar
c. use the key combo CTRL + $
d. double-click the selection
10. A certain spreadsheet shows in Page Break Preview that cells in Rows 1 - 25 have white background. The cells in Row 26 that contain data have a dark gray background. When you click the Print button, _____.
a. nothing will print because some cells with data have been omitted
b. only the cells with gray background will print
c. the whole sheet will print
d. only the cells with white background will print.
MS Powerpoint
1. How many Notes pages can you have per slide?
1
2
3
4
2. When you apply a template to a presentation, which of the following elements is NOT changed?
Color
Slide Graphics
Master Elements
Bullet Styles
3. Which of the following is NOT true about Slide Sorter View?
You can edit slide text
You can assign slide timings
You can reorder your slides
You can pick up and apply slide color schemes
4. What do end-users need to run your presentation?
PowerPoint
The PowerPoint Viewer
specialized hardware
slide show processor
5. In Slide Sorter View, what would :05 indicate under a slide?
5 second timing
5 second hold
5 second transition
Nothing
6. What can't you do to a grouped, linked graphic.
rotate it
move it
resize it
delete it
7. Pick the kind of tab that PowerPoint does NOT support:
Left
Center
Decimal
Flush
8. The best way to quickly show two subordinates within an Org chart is to:
Quickly draw two boxes
Double-click the Subordinate tool and then click a box
Shift-Click the Subordinate tool and then click a box
Drag the Subordinate tool over any box
9. Pulling a wedge away from a pie chart is known as:
shuffling
animating
pulling
exploding
10. Pressing the TAB key in front of bulleted text will:
do nothing
demote the bullet
promote the bullet
None of the above
11. The best way to get a slide show to stop is to:
press ESCAPE
exit PowerPoint
click the STOP button
None of the above
12. The animation effects will:
allow you to control animation on an object-by-object basis
allow you to control animation on a slide-by-slide basis
set slide tranisitions
do nothing
13. Which of the following is NOT a PowerPoint view:
Slide Sorter
Slide Preview
Notes Page Master
Slide Master
14. To turn off the bullets for every slide, you would have to:
go to any slide, click the No Bullets Every Slide option
edit the Master slide
click the fuzzy border around any text block and click the Bullets tool
PowerPoint does not support bullets
15. The best way to stop slides from showing up during a slide show is to:
delete them
use the Stall tool on them
hide them
all of the above


Regards
Prashant

quote=VMerudi;527598]Dear all,

How do we test whether a candidate is having good knowledge of MS Office before hiring them for a position which requires MS Office?
Are there different ways of testing computer literacy of applicants?
Please let me know.

Thanks and Regards
Vijaya[/quote][/quote]

From India, Madras
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.