Skip Navigation

Brockport / Assessment and Testing / Practice Test

Practice Test




Computer Skills Practice Test

The Computer Skills practice test was created to help students prepare for our exam. We are currently testing computer skills using Microsoft Office 2010 applications (Word, PowerPoint, Excel). The tasks performed on this practice test are only some of the skills you may see on the actual exam.

When watching the videos use the back button to get back to the questions. Do not use the exit button in the upper right of the screen.

Section 1

Microsoft Word

Click Here To download Google Earth and Maps.docx
Use Save_As to save the document to your computer
 

1.

Change the margins to 1” on the top, bottom, left, and right.

 

VideoIcon

2.

Double-space the entire document

  VideoIcon

3.

Format the title text “Google Earth and Online Maps” as follows:

  • Center the title
  • Change the font size to16pt
  • Make the text bold
  • Change the text to any color other than black

PLEASE NOTE – this should be applied to the title text only.

 

 

VideoIcon

4.

Apply the Strong– style to the first subheading “Technological Challenges”.

 

VideoIcon

5.

Find the heading “Smile! You’re on Google Camera!”, format the third paragraph that begins with “Street View offers users…” so that it is indented 1 inch on each side, and then justify the text.

 

VideoIcon

6.

Find the subheading “Smile! You’re on Google Camera!” In the paragraph below the subheading, move the first sentence so that it is the last sentence in the paragraph.

 

VideoIcon

7.

Place your pointer to the left of the subheading “ Google Earth and then Insert the picture Google Earth and Maps which can be downloaded to your Downloads folder by clicking on the picture on the right and then when the picture appears on your screen you would right click on the picture and use Save Picture As to save the picture in your downloads folder. Format the picture so that the paragraph text wraps square around the picture.

Google Earth Video

8.

Use the Find and Replace feature to replace all instances of the words “conjunction” and replace them with “collaboration”.

 

VideoIcon

9.

Create a header and enter a right aligned inserted page number.

 

 

10.

Create a footer and insert today’s date on the left side of the footer. Change the setting so that the date updates automatically.

 

VideoIcon

11.

Find the subheading “Top Four Mapping Software Applications” and change the list below the subheading to a Numbered list

 

VideoIcon

12.

Above the subheading Market Share, find the text “mapping tools”.  Change the text to a hyperlink. http://maps.google.com

 

VideoIcon

13.

Find the document table shown below and then merge the two cells in the first row. Center the title in the cell.

Mapping Sites

 

Name

Market Share

mapquest.com

50.2%

maps.google.com

22.2%

local.live.com

3.86%

 

 

 

VideoIcon

14.

Change the background shading of the first row (title row) to any color.

 

 

15.

Add a new row just above the last row of the table and enter the following:

Maps.yahoo.com

13.4%

 

 

 

16.

Using the Autofit tool, change the table to “Autofit to Contents”.

 

 

17.

Insert a Page break after the table and BEFORE the Works Cited list so that Works Cited appears on a separate page.

 

VideoIcon

18.

Format the Works Cited list using a ½” hanging indent.

 

VideoIcon

 

Section 2

   
 

PowerPoint

   
  Click Here To download Google Earth and Maps.pptx
   
   Use Save_As to save the presentation to your computer    
       
1. Change the slide layout of slide 1 from a parent slide to the Title Slide layout.  Add “Google Earth and Maps as the title and your name as the subtitle.     Video Icon
2. Apply the “Solstice” Design  to all the slides in your presentation.  

VideoIcon

3. Insert a slide number on each of the slides.  

VideoIcon

4. Apply the “Fade” transition to all slides.  

VideoIcon

5. Change the speed of all transitions to 1 Second.  

 

6. Add a 5th slide using any layout to the end of the presentation. Add “Google Sky” as the title.   

VideoIcon

7. Reorder the slides so that the new slide is slide number 4.  

 

     

 

 

Section 3

   
 

Excel

   
  Click Here To download Google Earth and Maps.xlsx    
   Use Save_As to save the worksheet to your computer    
       
1. Format the range D6 through D9 so that each value has Three decimals.  

VideoIcon

2. In cell D11 use the SUM function to find the total Initial value  

VideoIcon

3. In cell G6 create a formula to show what percent cell F6 is of the total number of shares in F11.  

VideoIcon

4. In cell D13 use the Average function to find the average Initial value in cells D6 through D9.  

VideoIcon

5. Create a Column chart that shows the name of the site in column C, the initial value in column D and the current value in column E.  

VideoIcon

       
 

Section 4

   
 

Information Literacy

   
 

You will need to research information for many projects while you are in college.  The information literacy skills that you have now must continue to develop to assist you in finding that needed information.  It is also important that you have a basic understanding of copyright information and the Digital Milennium Copyright Act as it relates to file sharing of music, video, software and games.

To learn more about copyright information click here.

   

Last Updated 9/4/14