UH WebMail | LILO | Laulima | MyUH Portal | WCC | UNIVERSITY OF HAWAII   
   

Windward Community College Computer & Information Literacy Graduation Requirement
spacer   spacer
 Sample Exams \ Spreadsheet Skills List


Skills Needed to Complete the Spreadsheet
Component of the CIL Exam

Skills List | Exam Sample Print Spreadsheet Sample Exam | Scoring Rubric

Locate a particular file on a CD-ROM of the local computer.

Open a particular file into a spreadsheet program (MS Excel).

Use "save as" to rename and save a file to a floppy disk on the local computer.

Select columns in a spreadsheet.

Delete columns.

Enter text into a cell.

Use functions and formulas to make calculations.

Copy and paste functions into other cells.

Modify text within specific cells.

Format numbers within cells to display a comma separator.

Merge and Center a range of cells.

Create an outline border around a range of cells.

Make text in a cell boldfaced.

Adjust column widths to fit contents.

Use Cell References to insert data in cells.

Create a chart using data from a range of cells, and format the chart using specific criteria.

Move a chart.

Resize a chart.

Modify page orientation.

Format page margins.

Customize a header to contain text and a date.

Print a worksheet.


Skills List | Exam Sample Print Spreadsheet Sample Exam | Scoring Rubric
spacer
 
OVERVIEW | FAQ | HOME | THE TESTING CENTER (TTC)
WCC LIBRARY | UH USERNAME | COMPUTER HELPLINE
 


Windward Community College • 45-720 Kea‘ahala Rd • Kāne‘ohe, HI 96744

Page last updated: September 29, 2009