Skills Assessment

The skills assessment will allow us to identify your skill and knowledge levels. This will in turn help us to place you in a position that will best utilize your abilities.

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