STA 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.

First Name

Last Name

Email

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 websites.

a. Microsoft Word

b. Microsoft Excel

c. Microsoft Access

d. Microsoft Publisher

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.

a. Microsoft Excel

b. Microsoft Outlook

c. Microsoft Access

d. Microsoft OneNote

3. ________ is a complete presentation graphics program that allows users to produce professional-looking presentations using a variety of media.

a. Microsoft Publisher

b. Microsoft Front Page

c. Microsoft Photo Draw

d. Microsoft PowerPoint

4. _________ is a desktop publishing (DTP) program that allows users to design and produce professional-quality documents (newsletters, flyers, brochures, business cards, websites, etc.) that combine text, graphics, and photographs.

a. Microsoft Outlook

b. Microsoft Publisher

c. Microsoft Access

d. Microsoft Excel

5. ________ is a webpage authoring and site management program that allows users to create and manage professional-looking websites on the internet or an intranet.

a. Microsoft PowerPoint

b. Microsoft PhotoDraw

c. Microsoft FrontPage

d. Microsoft Publisher

6. In Word 2016, to save an existing document with a different file name, click the ________________.

a. Save button on the Quick Access toolbar

b. Save As button on the drop-down File menu

c. Save As command on the Office button

d. New button on the drop-down File menu

7. How do you change the name of a Word 2016 file without creating a new copy of it?

a. Right click on the file icon on your desktop, or on the file name in a list, and select Rename.

b. Double click slowly into the file name field until it opens, change the wording, and hit enter.

c. Select File, then Save As and type in new file name.

d. A or B

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

a. Call the ITD Help Desk and ask for help.

b. Click the Forgot Password link on the PipelineMT login page.

c. Wait for a new semester to receive an email link to change password.

d. Download, print, and submit the Change Password form found on the ITD webpage.

9. To select any group of words in Word 2016, ___________.

a. click the Group button on the Formatting toolbar

b. double-click anywhere within the group to be selected

c. click on the first word then while holding the button drag through words to be selected, then release

d. right-click the first and last characters of the group to be selected

10. In Word 2016, you can add a graphic to your document by ____________.

a. clicking Insert, selecting the icon for the graphic source, finding the desired graphic and double-clicking it

b. clicking on the Drawing Object command on the Format menu

c. clicking the Frame command on the Insert tab

d. clicking the Picture command on the Format menu

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

true

false

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

a. Insert

b. Layout

c. Review

d. View

13. When using Outlook you can attach a photo or file to a message by _____________________.

a. clicking on File, then selecting Add Photo or File

b. clicking on Insert, selecting the Attach File icon, finding the photo or file, then double-clicking on it

c. dragging and dropping the photo or file from desktop into message field

d. B or C

14. To make a photo or graphic viewable in the body of an Outlook message, start a new message and _____________________.

a. click on File, then select Add Photo or File

b. click on Insert, select the Attach File icon, find the photo or file then double-click on it

c. drag and drop the photo or file from desktop into message field

d. select Insert, then the Pictures drop-down menu, then find and double-click on the desired photo or graphic

15. To stop bulleting a list in Word 2016, press the _______ twice.

a. Enter Key

b. Shift Key

c. Alt Key

d. Ctrl Key

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

true

false

17. In Word, 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.

true

false

18. In Word 2016, to add a row or column to a table, right click on the table and use the Insert dropdown menu.

true

false

19. To reduce the number of cells in a table inserted in a Word document:

a. select Draw, then Delete Cells.

b. highlight the cells to be deleted and hit Delete button.

c. highlight the cells to be deleted, right click, then select Delete Rows or Columns command.

d. None of the above, you can’t insert a table in a Word document.

20. To double-space the contents of a Word table, you would_____________.

a. place the insertion point at the top-right corner of the table

b. select the entire table

c. select the table title

d. press Ctrl-2

21. To convert a Word 2016 document to a PDF, ___________.

a. click on the Acrobat key on the menu bar

b. select File, Save As and change type of document to PDF

c. select File, then Export, then Create Adobe PDF

d. Any of the above

22. To insert a Header or Footer in Word 2016, select the Insert tab and select either header or footer.

true

false

23. To edit how a header displays its content: First insert a header and then go to the ______________ tab to make changes.

a. Page Layout

b. References

c. Design

d. Review

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

a. .exc

b. .wbk

c. .docx

d. .xlsx

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

a. end-of-cell mark

b. cell

c. gridline

d. style

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

a. colon (:)

b. hyphen (-)

c. slash (/)

d. tilde (~)

27. What is the easiest way to start creating formulas in Microsoft Excel?

a. Select Formulas then use drop-down menu options.

b. Type in () before the formula.

c. Type the formula in parenthesis ().

d. Type in = before the formula.

28. The ________not only deletes highlighted words or graphics in a Word or Excel document but also copies the range to the Office Clipboard for pasting.

a. Undo button or Undo command

b. Right-click Cut command or Ctrl-X

c. Delete button or Delete command

d. All of the above

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

a. MAX function

b. AVERAGE function

c. COUNT function

d. SUM function

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

true

false

31. To undo any previous function in Word or Excel involving typing, inserting objects, or formatting, simply type Ctrl-Z.

true

false

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

a. at sign (@)

b. dollar sign ($)

c. percent sign (%)

d. equal sign (=)

33. In Excel, to set a column width to the exact width of its contents ____________boundary of the column heading above row 1.

a. click the left

b. double-click the left

c. click the right

d. double-click the right

34. To move or copy an Excel spreadsheet to another spreadsheet you should _________________.

a. Click Home>Format>Move or Copy Sheet

b. Click Home>Forms>New Form

c. Click Insert>Tables>Create

d. You cannot move a single sheet from a work book.

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

a. Alt+Enter

b. Ctrl+Enter

c. Shift+Enter

d. Tab+Enter

36. Borders can be removed from an Excel spreadsheet by selecting the range, selecting the Borders Button Tab on the home/font Menu, and clicking the NO BORDER Button from the BORDERS Drop Down Menu.

true

false

37. In Access, 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.

a. View Report

b. Open

c. Print

d. Print Preview

38. In PowerPoint, the __________ tab gives you options to display a presentation in black and white or grayscale.

a. Review

b. Design

c. View

d. Home

39. When printing PowerPoint class notes, a student can make sure it is printing four slides per page by____________________.

a. checking that the Slideshow option is working

b. going to File, selecting Print, then under Settings selecting the four-slides-per-page icon

c. going to Office Button > Print, selecting "Slides" under "Print what" section, and selecting 6 slides per page

d. going to Office Button > Print, checking the "Collate" box, and clicking on OK

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

a. Error Checker

b. Spelling

c. AutoCorrect

d. Style Checker

41. In PowerPoint, you can select whether to change slides by mouse click or time elapse using the ______________ tab.

a. Slide Show

b. Acrobat

c. Transitions

d. Review

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

a. plain text

b. RTF

c. BMP

d. A or B

43. Microsoft Sway is an alternative to PowerPoint for quickly creating multi-media presentations and sharing them digitally?

true

false

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

a. Ctrl+Z

b. F1

c. ESC

d. Ctrl+R

45. When PowerPoint prints out black slides, which of the following should you do?

a. Try printing in Gray scale.

b. Change the background by selecting another design template.

c. Select Format > Remove Background option

d. A or B

46. OneDrive is an example of ____________ storage.

a. Local Area Network or LAN

b. Ethernet

c. USB

d. Cloud

47. MB equals 1,000 KB?

true

false

48. To find a Word 2016 file if you do not know the file name, ________________.

a. open Word and view list of Recent files

b. search through the OneDrive list of recently opened files

c. change the Files Type to All Files

d. Alt-Shift-Delete then select Find

49. If you recently deleted a file but want to retrieve it, you can likely find it in __________________.

a. My Documents

b. Recycle Bin

c. My Computer

d. Network Neighborhood

50. To download Windows updates go to ____________.

a. Control Panel>Windows Updates

b. The Quick Launch bar>Security updates

c. Preferences>Software updates

d. Network and Sharing Center>Adapter Settings

51. To view all active and running programs in Windows, __________________.

a. click on Start>Programs

b. see the icons on the taskbar

c. click on Control Panel>Add/Remove programs

d. press Ctrl-Alt-Del to run the Task Manager

52. To change the response speed of a mouse __________________.

a. install a wireless mouse

b. click on the Windows icon, go to Devices and Printers, right click on the mouse icon and follow directions

c. Type in Ctrl-Alt-Delete on the desktop and find mouse settings

d. Right click on the desktop and find the mouse settings function

53. Scrolling through a page can be accomplished in all the following ways except ____________.

a. clicking on the scroll arrows

b. clicking and holding on the scroll bar while moving your cursor up and down

c. clicking between the scroll box and arrows

d. dragging the scroll arrows

54. Using the zip function on a file will _____________.

a. make it accessible only by you

b. make it accessible only with a password

c. make the contents more compressed and easier to email

d. encrypt the contents

55. To transfer files that are too large to email, use__________ .

a. a flash drive

b. the Dropbox website

c. OneDrive

d. A or B

56. In Windows, additional installation may be required to properly load a flash drive.

a. true

b. false

57. What does more RAM allow a computer to do?

a. Store more data on its hard drive.

b. Transfer more files through the cloud.

c. Run more programs and applications at the same time.

d. A and B

58. To find and clear Temporary Internet Files and Cookies in Internet Explorer________________.

a. click on the Windows button and go to C for cookies

b. do a word search for “cookies”

c. type CTRL-shift-delete

d. from a webpage click on the Tools icon, select Internet Options, then use the buttons

59. To take screen shots from your desktop that can be saved or emailed, ____________________.

a. open Snipping Tool by selecting the Start Window, typing Snipping Tool, and then selecting it in the search results

b. right click on your desktop and click on Screen Shot

c. type Ctrl-Shift-Delete then enter

d. click and drag around the object you want a screen grab of

60. To create the most secure password you should______________.

a. make sure that it includes only special characters and numbers

b. make sure it includes your name so you can remember it

c. make it long but memorable for you

d. make sure it is as long as possible

ITD Help Desk

Sun: 12pm – 6pm
Mon-Thurs: 8am – 9pm
Fri: 8am – 4:30pm
Sat: 10am – 4:30pm

For students and staff who are unable to access the main Help Desk located in KUC 320, please call or email to schedule a meeting at our satellite office located in the ROTC Annex.

(615) 898-5345
help@mtsu.edu
Submit Work Order

Request Equipment (Faculty / Staff ONLY)