Computer Skills Review

Online Computer Skills Test Review: 

Online Computer Skills Test Review

HELPFUL HINTS: 

HELPFUL HINTS Complete the directions in the least amount of steps possible Don’t play with the program (no doodling) If you don’t know how to do the task: Use the Menu bar to look for the solution Use Help Work the task and then when you have figured it out, use the Restore button and solve the task in the least amount of steps possible. Restore, Restore, Restore!!!! Use Help

SPREADSHEET TASKS: 

SPREADSHEET TASKS Insert a row or column Delete a row or column Change the cell format Sort the spreadsheet Insert a function (SUM, AVERAGE, MIN, MAX) Create a formula (Ex. =B2*B3) Create a chart

SPREADSHEET – Media Budget (Day 13): 

SPREADSHEET – Media Budget (Day 13) Open SPREADSHEET. Retrieve the file “Media Budget”. Insert a new row between “Epson Scanner” and “Sony MiniDV Camcorder”. Add the following information in Row 9: ITEM DESCRIPTON: Sony Mavica Digital Camera QUANTITY: 4 UNIT PRICE: 316.99 Format Cell C9 for currency. Arrange the items in alphabetical order. Create a formula in D9 to calculate the EXTENDED PRICE. Insert a function in B13 to calculate the total number of items purchased. Insert a function in C13 to calculate the average UNIT PRICE.

DATABASE TASKS: 

DATABASE TASKS Insert a record or field Delete a record or field Sort records by field (ascending or descending) Copy a record and paste the information in a new record Modify a record Change the field name Enter data into the database Filter the database using criteria

TURTLES - DATABASE (Day 14) : 

TURTLES - DATABASE (Day 14) Directions: Open DATABASE. Retrieve the file “Turtles”. Insert a new record in the database. Copy the record for the “Loggerhead Sea Turtle” and paste it into the new record. Make the following changes to the pasted record: NAME: Green Sea Turtle LOCATION: Hawaii SCIENTIFIC NAME: Chelonia Mydas Modify the HOUSEHOLD PET field to True/False. Delete the “Madagascar Turtle-Dove” record from the database since it is a bird and not a turtle. Arrange the database in alphabetical order by NAME. Filter the database to locate the turtles that make good pets and live no more than 50 years.

DATABASE – NC Counties A to C (Day 13): 

DATABASE – NC Counties A to C (Day 13) Open DATABASE. Retrieve the file “NC Counties A to C”. Delete the “SQUARE MILES” field. Filter the database to locate the counties where the % WHITE is at least 50, the % BLACK is at most 30, and the % HISPANIC is no more than 2. Filter the database to locate the Counties where the POP is more that 40000, the % BELOW POVERTY, 1997 is less than 10, and are located in the Piedmont REGION.

EDITOR TASKS: 

EDITOR TASKS Format font (Font Type, Size, Style – Bold, Italic, Underline, Strike-through, Subscript, Superscript) Format alignment (Left, Center, Right) Format line spacing (Single, Double, 1.5 – Note: the 1.5 option is not on the tool bar, must go to Format menu – Paragraph, to locate 1.5 line spacing) Insert an image Cut, copy, paste Delete text or replace text Modify paragraphs (Ex. Make the first four sentences, paragraph one and the last three sentences, paragraph two.) Spell check

EDITOR – Rockefeller Story (Day 13): 

EDITOR – Rockefeller Story (Day 13) Open Editor. Retrieve the file “ Rockefeller Story”. Center the title of the article and change the font to Verdana, size 18, and the style to bold and italics. Change the font of the entire article to Verdana, size 12. Reformat the article to 1.5 line spacing. Left align and indent the paragraph. Make a second paragraph using the last two sentences of the article. Indent the new paragraph. Select and italicize the quote by Rockefeller’s son, Nelson.

WINDOWS MANAGER TASKS: 

WINDOWS MANAGER TASKS Cut, copy, paste Note: Pay attention to where the task ask you to paste the item Minimize, maximize windows

WINDOWS MANAGER – Hydrologic Cycle (Day 11): 

WINDOWS MANAGER – Hydrologic Cycle (Day 11) Open Windows Manager. Retrieve the file “Hydrologic Cycle”. Copy the information in Document 2 and paste it at the bottom of Document 1. (Continue the formatting of Document 1) Minimize the Document 2 window.

MAIL TASKS: 

MAIL TASKS Addressing an email (To: field) Copying the email to another address CC: stands for Carbon Copy Attach a file Delete a file Add a Subject line Send the Email

MAIL – Inventions (Day 18): 

MAIL – Inventions (Day 18) DIRECTIONS: Open MAIL. Retrieve the file “Volcano.” Address the email to “scientist@volcanoworld.edu”. Send a copy of the email to “teacher@myschool.edu”. Add “Mt. St. Helens” to the Subject line. Attach the file called “Report.doc” as an attachment. Add the name “Student” as the signature. Send your email.