• Important Dates  
  • Events Calendar
  • Workshop Schedule
  • Exam Schedule
• Sample Exams  
  • Email w/ attachments
  • Word Processing
  • Information Literacy
  • Spreadsheet
• Learning Resources  
  • Workshops
  • Tutoring
  • Credit Courses
  • Noncredit Courses
  • Self Directed
    • Email w/attachments
    • File Management
    • Word Processing
    • Information Literacy
    • Spreadsheet
• Blog

Skills Needed to Complete the Spreadsheet
Component of the CIL Exam

Skills List | Exam Sample | 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 | Scoring Rubric

Computer & Information Literacy (CIL) Associate Coordinator • Bryan Shon
Phone: 808.236.9243 • Email: bshon@hawaii.edu • Office: Na‘auao 143
Windward Community College • 45-720 Kea‘ahala Rd • Kāne‘ohe, HI 96744

Page last updated: September 3, 2008