1. __________ is a spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional-looking reports, publish organized data on the Web, and access real-time data from Web sites.
    
   1. Microsoft Word 2007
   2. Microsoft Excel 2007
   3. Microsoft Access 2007
   4. Microsoft Publisher 2007
       
2. ___________ is a comprehensive database management system (DBMS) that can be used to create a database; add, change, and delete data in a database; sort data in a database; retrieve data from the database; and create forms and reports using the data in a database.

1. Microsoft Excel 2007
2. Microsoft Outlook 2007
3. Microsoft Access 2007
4. Microsoft Front Page 2007

3.  ________ is a complete presentation graphics program that allows users to produce professional-looking presentations.
    
   1. Microsoft Publisher 2007
   2. Microsoft Front Page 2007
   3. Microsoft Photo Draw 2007
   4. Microsoft PowerPoint 2007
       
4.  _________ is a desktop publishing (DTP) program that allows users to design and produce professional-quality documents (newsletters, flyers, brochures, business cards, Web sites, and so on) that combine text, graphics, and photographs.

1. Microsoft Outlook 2007
2. Microsoft Publisher 2007
3. Microsoft Access 2007
4. Microsoft Excel 2007

5. ________ is a Web page authoring and site management program that allows users to create and manage professional-looking Web sites on the Internet or an intranet.

1. Microsoft PowerPoint 2007
2. Microsoft PhotoDraw 2007
3. Microsoft FrontPage 2007
4. Microsoft Publisher 20007

6.  In MS Office 2007, to save an existing document with a different file name, click the ________________.

1. Save button on the Quick Access toolbar
2. Save as on the File menu
3. Save As command on the office button
4. New button on office button

7. The first option for a student who wants to change the password of his/her frank account is:

1. Go to the OIT Office/call the helpdesk and ask for help.
2. Clicking the "I cannot remember my password" link on the Pipeline login page.
3. To forget about it and be miserable with his/her old password.
4. To download, print, and submit a change password from from the ITD web page.

8. When a student is going to print PowerPoint class notes, you make sure that it is printing six slides per page by:

1. Checking that the Slideshow option is working.
2. Going to Office Button|Print, selecting "Handouts" under "Print what" section, and selecting 6 slides per page.
3. Going to Office Button|Print, selecting "Slides" under "Print what" section, and selecting 6 slides per page.
4.  Going to Office Button|Print, checking the "Collate" box, and clicking on OK.

9. The select a group of words, ___________.

1. click the Group button on the Formatting toolbar
2. double-click anywhere within the group to be selected
3. drag through the characters to be selected
4. right-click the first and last characters of the group to be selected

10.  In MS office 2007, you can add a graphic to your document by using the ____________.

1. Picture command under the Insert Ribbon
2. Drawing Object command on the Format menu
3. Frame command on the Insert Ribbon
4. Picture command on the Format menu

    11.    To maintain the proportion of a graphic, press the SHIFT key while dragging a corner sizing handle.

1. true
2. false

    12.    In MS Word 2007, to change the default margin settings, Margins under the_______ tab on the ribbon menu.
 

1. Insert
2. Page Layout
3. Review
4. View
    

    13.    In Microsoft Word 2007, when _______ is selected in the Table AutoFormat dialog box, Word automatically adjusts the widths of the columns based on the amount of         text in the table.
 

1. AutoSize
2. AutoEnter
3. AutoFit
4. AutoCorrect
    

    14.    To instruct Word to stop bulleting paragraphs, the _______ is pressed twice.
 

1. ENTER key
2. SHIFT key
3. ALT key
4. CTRL key
    

    15.    In Excel 2007, the intersection of a row and a column is called a(n)__________.

1. end-of-cell mark
2. cell
3. gridline
4. style
    

    16.    In MS Word 2007, when you are at the rightmost cell in a row, press the _________ to move to the first cell in the next row.
 

1. SPACEBAR
2. SHIFT key
3. ENTER key
4. TAB key
    

    17.    In MS Word 2007, a decimal-aligned tab stop is used if you have a series of numbers that you want aligned on the decimal point.

1.  true
2. false
    

18. In MS Word 2007, to add a row or column to a table, click where you want to insert, click Layout Tab on the Table Tools  menu, point to insert, click the correct insert command in "Rows and Columns" section.
    1. true
    2. false
        
19. In MS Word 2007, to remove a custom tab stop, point to the tab marker on the ruler and then drag the tab marker down and out of the ruler.
    1. true
    2. false

     

20. If you want Word 2007 to automatically wrap text around the table, hold down the __________while you draw the table.
     
    1. CTRL
    2. SHIFT
    3. TAB
    4. SPACEBAR

    
     

21. To single-space the contents of a table, you first would_____________.

1. place the insertion point at the top-right corner of the table
2. select the entire table
3. select the table title
4. press CTRL+1

    22.     In MS Word 2007, to select text in a previous cell in a table, ___________.
 

1. press the SHIFT+TAB keys
2. press the TAB key
3. press the ENTER key
4. press the SPACEBAR
    

    23.    To insert a Header or Footer in MS Word 2007, you select the Insert Tab on the ribbon menu and then select either header or footer.

1. true
2. false
    

    24.    When a file is saved, Excel 2007 automatically appends the extension________ to the entered file name, which stands for Excel workbook.

1.  .exc
2.  .wbk
3.  .docx
4.  .xlsx

    25.    In Excel 2007, a range can be entered by typing the beginning cell reference, a _________, and the ending cell reference.

1. colon (:)
2. hyphen (-)
3. slash (/)
4. tilde (~)
    

    26.    The ________not only deletes the contents from a range, but also copies the range to the Office Clipboard.

1. Undo button or Undo command
2. Cut button or Cut command
3. Delete button or Delete command
4. All of the above

    27.    Excel’s ___________provides a convenient means to add the numbers in a range of cells.
 

1. MAX function
2. AVERAGE function
3. COUNT function
4. SUM function
    

    28.     If a print area is not selected, Excel automatically selects a print area on the basis of used cells.
 

1. true
2. false
    

    29.    To toggle between the values version and the formulas version of a worksheet, press ______.
 

1. CTRL+LEFT SINGLE QUOTATION MARK (‘)
2. CTRL+RIGHT SINGLE QUOATATION MARK (’)
3. ALT+LEFT SINGLE QUOTATION MARK (‘)
4. ALT+RIGHT SINGLE QUOTATION MARK (’)
    

    30.    The __________preceding a formula is an important part of the formula, because it alerts Excel that a formula or function is being entered and not text.
 

1. at sign (@)
2. dollar sign ($)
3. percent sign (%)
4. equal sign (=)
    

    31.    In Excel 2007, to set a column width to best fit, ____________boundary of the column heading above row 1.
 

1. click the left
2. double-click the left
3. click the right
4. double-click the right
    

    32.    To select the nonadjacent range F11, H11, and I11, select cell F11, and then, while holding down the ________ drag through the range H11:I11.
 

1. SHIFT
2. ALT
3. CTRL
4. HOME
    

    33.    In Excel 2007, to start a new line in a cell, press ___________after each line, except for the last line, which is completed by clicking the Enter box or pressing the ENTER key.
 

1. ALT+ENTER
2. CTRL+ENTER
3. SHIFT+ENTER
4. TAB+ENTER
    

    34.    Borders can be removed by selecting the range, selecting the DESIGN Tab on the TABLE TOOLS Menu, and clicking the NO BORDER Button from the BORDERS Drop Down Menu.
 

1. true
2. false
    

    35.     In Access 2007, if a key appears in front of a field in the Table window, such as that shown in the accompanying figure, it means the field is the _________ for the table.
 

1. primary key
2. row selector
3. page header
4. detail line
    

    36.     In Access 2007, to view and then print a report from the Database window, click the REPORT Button on the CREATE Tab, and then click _____________ on the shortcut menu.
 

1. View Report
2. Open
3. Print
4. Print Preview
    

    37.    In Access 2007, to move from the upper pane, the one where fields are defined, in the Table window to the lower pane, the one where field properties are defined, press the ___________key.
 

1. F8
2. F7
3. F6
4. F5

    38.     In Access 2007, to change to landscape orientation to print a table, click the OFFICE BUTTON | PRINT Menu | PRINT PREVIEW Button and then click on the         LANDSCAPE Button.
 

1. true
2. false

    39.    In Access 2007, to preview what printed copy will look like, use Print Preview.
 

1. true
2. false
    

    40.     In PowerPoint 2007, the __________ button allows you to display a presentation in black and white before you print.
 

1. Grayscale
2. Grayshade
3. Black and White
4. Monochrome
    

    41.    In PowerPoint 2007, to check a presentation for spelling errors, click the _________ button on the Review Tab.
 

1. Error Checker
2. Spelling
3. AutoCorrect
4. Style Checker
    

    42.    In PowerPoint 2007, the extension of _______ is added automatically to a file name when you save a PowerPoint presentation.
 

1. .pptx
2. .txt
3. .pow
4. .docx
    

    43.    PowerPoint can produce slides from an outline created in Microsoft Word, if you save the outline as a(n) ________ file.
 

1. plain text
2. RTF
3. BMP
4. either a or b
    

    44.    In PowerPoint 2007, animation effects can be applied to text but not to objects
 

1. true
2. false
    

    45.    In PowerPoint 2007, if you select an incorrect box style or want to return to the previous style after selecting a style, you can pres __________.
 

1. CTRL+Z
2. F1
3. ESC
4. CTRL+R
    

46. When MS PowerPoint 2007 prints out black slides, which of the following should you do?
     
    1. Try printing in Gray scale
    2. Change the background by selecting another design template
    3. Select Format | Remove Background option
    4. A or B
        
47. What is the correct way to enter formulas in Microsoft Excel 2007?
     
    1. Select Insert | Formula
    2. Type in () before the formula
    3. Type the formula in parenthesis ()
    4. Type in = before the formula
        
48. What are the ways you can open Windows Explorer?
     
    1. Right click on MY COMPUTER, and select EXPLORE
    2. Press Ctrl + E
    3. Press Windows key + E
    4. A and C
        

    49.    When opening a file with MS Word 2007, you cannot find the file in the list of files displayed. What do you do?
 

1. Change the File list to All
2. Select File | Display All Files
3. Change the "Files of Type" to All Files
4. Select File Type | All
    

    50.    How do you change the name of a file?
 

1. Select File | Change Name
2. Right click on the file and select Rename
3. Select File |Change
4. Right click on the file and select Change name

    51.    In PowerPoint 2007, what can you do to change the page layout, when pages print sideways on paper?
 

1. Click on the OFFICE BUTTON| PAGE SELECT
2. Click on the PAGE SETUP Button on the HOME Tab
3. Click the OFFICE BUTTON| PRINT Menu | PAGE SETUP
4. Click the PAGE SETUP Button on the DESIGN Tab
    

    52.     In PowerPoint 2007, beside clip art, you can insert other types of pictures into your presentation.
 

1. true
2. false
    

    53.    _____________, can be used to discard unneeded documents or files.
 

1. My Documents
2. Recycle Bin
3. My Computer
4. Network Neighborhood
    

    54.    A student doesn’t know where the document was saved. Where is the option located that will help you find the document?
 

1. Start button
2. Taskbar button area
3. Quick Launch toolbar
4. Tray status area
    

    55.    What is a Flash Drive?  

1. A device that allows a camera to have a flash for dark pictures
2. An electronic storage device
3. Another name for a floppy drive
4. A propulsion system faster than a HyperDrive

    56.    In Windows XP, a driver CD must be used to install a Flash Drive before it can be used.

1. true
2. false
    

    57.    In Windows 2000/XP, how can you tell all the programs actively running in the computer, even in the background?
 

1. Click on Start | Programs
2. See the icons on the taskbar
3. Click on Control Panel | Add Remove programs
4. Press Alt-Ctrl-Del to run the Task Manager
    

    58.     _________ means press and release the left mouse button.
 

1. Point
2. Click
3. Drag
4. Double-click
    

59. Scrolling can be accomplished in all of the following ways except ____________.
     
    1. click the scroll arrows
    2. click the scroll bar
    3. dragging the scroll box
    4. dragging the scroll arrows
        
60. To rename a file, point to the file name in the Contents pane of the Exploring – My Files Window, ________, type the new file name, and then press the ENTER key.
     
    1. click the file name
    2. double-click the file name
    3. click the file name twice (but do not double-click)
    4. drag the file name into the Folders pane