What is the purpose of a this assessment?

Heinen's Corporate Office is offering on-site training classes in Word, Excel, and Outlook. In order to ensure that all associates derive the maximum benefits of classroom training, we are conducting this assessment to determine exactly what topics to include in each class. Please answer the questions below to the best of your ability and click the Submit button to enter your assessment data. Guesses will yield inaccurate results, therefore; if you're not sure of the correct answer, select the Not Sure option. If you have any questions, please contact Patti Luchsinger of Professional Educators at 440-967-9368 or at educators@adelphia.net.   

 Office Skills Assessment

 

Office Web-Based Skills Assessment
First Name: Last Name: 
Email Address: Location:
Department: Title:
Phone:
  1. The ____________ in Outlook indicates the total number of messages in the current folder.
task bar
status bar
folder list
Not Sure
  1. The blue digit enclosed in parenthesis next to a folder name in Outlook indicates...
total messages in the folder
total unread messages in the folder
total low priority messages in the folder
Not Sure
  1. The messages that you send in Outlook are temporarily stored in this folder until they sent.
Drafts Sent Items
Outbox Not Sure
  1. Which of the following commands in Outlook will resend a message?
Tools, Resend Message, Resend
Actions, Resend Not Sure
  1. What happens when you mark a task complete in Outlook?
The strikethrough format is applied to text
The font color of the text turns red
The font color of the text turns green
Not Sure
  1. A blue down arrow in Outlook displays next to an incoming message to indicate...
the message was sent low priority
the sender requested a receipt
the message is marked private
Not Sure
  1. Which of the following procedures in Outlook provides a quick way to add the sender of a message to your Contacts?
Click the Tools, Add Sender to Contacts command
Click the Insert, Add Sender to Contacts command
Right-click on the sender's email address
Not Sure
  1. When you schedule a meeting in the Outlook Calendar, how can you tell that an employee is out of the office at the designated meeting time?
the employee's time bar is blue
the employee's time bar is purple
the employee's time bar is white
Not Sure
  1. Create these in Outlook if you send messages to the same group of people on a regular basis.
Groups Distribution Lists
Recipient Lists Not Sure
  1. If you request a ____________ receipt before sending a message, Outlook will send you a message to indicate that the recipient received and read your message.
Delivery Confirmation
Read Not Sure
  1. Which of the following procedures in Word will display non-printing characters for editing purposes?

     
Click the Tools, Show menu command
Click the View, Show menu command
Click the Show/Hide tool
Not sure
  1. Which of the following formats can be set using the ruler in Word?
tabs, indents, and automatic numbering
indents, tabs, and line spacing
indents, tabs, and margins
Not Sure
  1. What is characteristic of the mouse pointer in Word when it is positioned in the selection bar?
It changes to a hand
It changes to an I-beam
It slants to the right
Not Sure
  1. Which of the following tools in Word will copy existing text formats to new text?
the Style tool
the Format Painter tool
the Copy tool
Not Sure
  1. The most efficient way to insert frequently used text in Word is to: 
Create an AutoText entry
Create an AutoFormat
Use the Edit, Copy and Edit, Paste menu commands
Not Sure
  1. Word has several different views-- Print Layout, Normal, Outline, and Web Layout. Which of the following is characteristic of Normal view?
It displays your document exactly as it prints
You cannot see headers and footers in Normal view
It does not display page breaks
Not Sure
  1. Which procedure in Word is the most efficient way to go to the beginning of a document?
Press the [Ctrl] + [Enter] quick keystroke
Press the [Ctrl] + [Home] quick keystroke
Press the [Ctrl] + [Page Up] quick keystroke
Not Sure
  1. Which keystroke will repeat your last action in Word?
[Shift] + [R]
[Ctrl] + [R]
[F4]
Not Sure
  1. Which of the following is required to specify different margin settings in a multi-page Word document?
Margin break Section break
Column break Not Sure
  1. Which feature is the most efficient way in Word to arrange information into columns and rows?
tabs newspaper style columns
tables Not Sure
  1. An Excel workbook contains __________ worksheets by default.
three five
256 Not Sure
  1. Every formula in Excel must be preceded by...
 A plus symbol + An Asterisk *
An equals sign = Not Sure
  1. Which of the following is not a valid function formula in Microsoft Excel?
LOW MIN
Max Not Sure
  1. Which of the following Excel function formulas is correct:
+SUM(A5;A10) SUM(a5-a10)
=sum(a5:a10) Not Sure
  1. Microsoft Excel displays pound symbols (########) in a cell when...
The cell contains an invalid formula
The cell format is incorrect
The cell is not wide enough
Not Sure
  1. Which of the following procedures in Excel will place the contents of a cell in edit mode?
Double-click on the cell
Press the [F6] keystroke
Press the [Ctrl] + [E] keystroke
Not Sure
  1. What does a dollar sign $ indicate in a cell reference of an Excel formula?
The cell reference is an absolute reference
The cell reference is a relative reference
The result of the formula will be in currency format
Not Sure
  1. Which of the following accurately describes a workbook in Microsoft Excel?
A file that contains function formulas
A worksheet that is split into multiple panes
A file that has more than one worksheet
Not Sure
  1. When you apply the currency format to a cell, Microsoft Excel will add...
A dollar sign and two decimal places
A dollar sign and one decimal place
A dollar sign and zero decimal places
Not Sure
  1. What keystroke in Microsoft Excel will insert the current date into the active cell?
[Ctrl] + [D] [Ctrl] + [Shift] + [D]
[Ctrl] + [;] Not Sure
 
  1. Which Excel features would you like to learn more about?
Create Workbooks Charting
Advanced Formulas Macros
Pivot Tables Templates
Other Excel Features:
 
  1. Which Outlook features would you like to learn more about?
Favorite Folders Signatures and Stationary
Calendar Message Delivery Options
Find Messages Attachments
Tasks Manage Contacts
Other Outlook Features:
 
  1. Which Word features would you like to learn more about?
Tables Styles
Bullets and Numbering Envelopes and Labels
Section Breaks Merging
Forms and Templates Table of Contents
Macros Master Document
Other Word Features:
 
  1. Which other features would you like to learn more about?
Create folders to store files
Move and copy files between folders and disk drives
Delete unwanted files and folders
Rename files and folders
Create shortcuts on the desktop to files and folders
Run multiple applications simultaneously
Search for files on your hard drive or network drive
Other Features:

Thank you for completing our on-line assessment. Please click the Submit button below to enter your data.


Download Course Descriptions

Each seminar participant
will receive a Study Guide for quick reference.


Download a Study Guide

 Bookmark This Page

  Professional Educators © 2004 | All Rights Reserved | | Top of Page