Question Title

* 1. Please type your name and/or organization.

Question Title

* 2. What computer area are you interested in?

Below are questions to rate your expertise in the following Microsoft 2010 programs: Microsoft Excel, Microsoft Word, Microsoft PowerPoint and Microsoft Outlook.

Please only answer questions you know, if you do not know an answer check 'I Don't know' as this will help determine the computer lessons that are needed. This test is designed to be completed within one half hour.

Thank you for your time.
Microsoft Excel

Question Title

* 3. Which key(s) do you press (while clicking the mouse) to select two or more nonadjacent cells?

Question Title

* 4. Which function would you use to change text in a cell so the first letters are capitalized?

Question Title

* 5. If you wanted cell contents to change to red every time a value drops below a certain value. What feature would you use?

Question Title

* 6. When working with Charts, what is a Data Table?

Question Title

* 7. You have created a long, detailed worksheet. To get the first row and first column to repeat on every page when printed. What feature would you use?

Question Title

* 8. To quickly populate a series of cells with the months of the year, what feature would be best to use without having to type all twelve months?

Question Title

* 9. To create a drop-down list, where people can select an item from options provided what feature should be used?

Question Title

* 10. You created a spreadsheet that lists all of the sales for all sales regions for XYZ company. You would like to subtotal these values by region. How would you most efficiently do this.

Question Title

* 11. A company has changed its name from XYZ Company to XYZ Inc. To quickly change all 150 instances of this in the spreadsheet, one should:

Microsoft Word

Question Title

* 12. You are revising a Microsoft® document that a team member created, and you want its author to be able to review your suggested changes before they become part of the document. What feature do you use?

Question Title

* 13. You want to create an organizational chart in your document. What feature will enable you to do this the fastest and most efficiently?

Question Title

* 14. To insert a watermark that says "Draft" in a document. You would go to:

Question Title

* 15. You have a document with a lot of text that would look more organized in a table. How could you most efficiently get the content into a table?

Question Title

* 16. If you've just formatted some text so that it stands out, how could you quickly copy that formatting to use on other text?

Question Title

* 17. You inserted a picture into a document. You would like the text to wrap around the picture. The best way to do this is to:

Question Title

* 18. You've used Word Heading Styles to format the title and sub-title text throughout a document. You would like to create a table of contents that automatically pulls in the title/sub-title text. How could this be done?

Question Title

* 19. You are creating a thank you letter. You would like to personalize each letter so that it says each client's name in the salutation. What feature do you use?

Question Title

* 20. You've created a document and would like to have 1.5 spacing between each line of text. How can you do this?

Question Title

* 21. You have a block of text along with a confidentiality statement you use repeatedly. What is the best way to automate the process without having to type it over and over again?

Microsoft® PowerPoint

Question Title

* 22. In Microsoft® PowerPoint 2010, Save, Save As, Print Preview, Print, Options, and Recent can be found:

Question Title

* 23. Microsoft® PowerPoint 2010 has a feature called Themes that affects colors, fonts and effects. To create your own Theme, you need to:

Question Title

* 24. When working in PowerPoint in Normal view, how do you access the Outline panel?

Question Title

* 25. To apply a Theme to all your slides, you would need to select the ____________ tab first.

Question Title

* 26. Which key do you press to go into Slide Show view and start your presentation on the first slide?

Question Title

* 27. How do you print your slides in a handout that includes lines for notes?

Question Title

* 28. You would like to change the formatting of the bullets on every slide. You need to change the size, color, and type of the font. What is the most efficient and quickest way to do this?

Question Title

* 29. How do you make an inserted sound file play continuously over several slides?

Question Title

Image

Question Title

* 30. You would like to create the graphic above. What is the most efficient way to do this?

Question Title

* 31. Which of the following can you NOT access from the 'Animations' tab on the Ribbon:

Question Title

* 32. Using an animation effect, how do you make text change to a Red color on a slide?

Question Title

* 33. You would like to animate each line of text on a slide. Can you save time and do this on the Slide Show tab.

Question Title

* 34. How do you insert a picture of part of a website into a presentation?

Question Title

* 35. You have typed an outline of content in Microsoft Word. The easiest way to get this content into your PowerPoint is to:

Question Title

* 36. You want to create a Chart on a PowerPoint slide, what is the easiest way to do this?

Question Title

* 37. You have a large PowerPoint presentation with over 300 slides. You have to give a modified version of this presentation for a new work group. Rather than creating or saving a new presentation, you can use this presentation and create _____________________ to show the desired slides for each unique presentation you give.

Question Title

* 38. You want the company logo to display at the bottom of each slide. Where do you do this?

Microsoft Outlook

Question Title

* 39. To send a business letter to a group of contacts you should

Question Title

* 40. You can request a receipt to show an email has been read by...

Question Title

* 41. You need to ensure all mail from a particular client is stored in that clients folder on our folder list - how would you do this?

Question Title

* 42. How can you ensure that a particular meeting on the calendar is only visible to you?

Question Title

* 43. You can show tasks by many different date periods - how would you change the work week for employees that work from Tuesday to Saturday?

Question Title

* 44. You need to arrange a meeting for all employees in a particular department - do you

Question Title

* 45. On the task list, to arrange tasks in date order, then in alphabetical order you would

Question Title

* 46. To mark all contents of a folder as read, you would

Question Title

* 47. You want to set up a button to automatically send an email you've received on to your manager, rather than have to manually choose their name every time. Would you

Question Title

* 48. What are categories?

Question Title

* 49. An appointment that happens every year, for example a birthday, is input as

Thanks for completing the Microsoft Office Assessment.

T