CSIS-SSX Spreadsheet Competency Examination

EXAMINATION INFORMATION - CSIS-SSX Spreadsheet Competency Examination

Date	Day	Time	Location	Roger Bacon Third Floor
2 November	Wed	8:30 pm	Roger Bacon 330
7 November*	Mon	8:15 am	Roger Bacon 304
9 November*	Wed	8:15 am	Roger Bacon 304
13 November	Sun	2:00 pm	Roger Bacon 304
18 November	Fri	2:30 pm	Roger Bacon 304
15 January 2012	Sun	2:00 pm	Roger Bacon 304
* limited space/PCs/seats
- Please arrive at the exam 5-10 MINUTES EARLY. - Please bring tour Siena ID card. - If the doors to Roger Bacon are not open on the "Quad", go the rear of Roger Bacon (near Foy or near Morrel). - If you arrive late for the exam, you will not be allowed to start the exam late.
Send a email message to csis.ssx@siena.edu if you would like to reserve a spot at an examination. Please indicate in your email message the date that you want to take the exam.
Within a few days of sending your reservation email message, you should receive a very brief email message that indicates that "Your reservation is Confirmed".
Please show up on time for the exam (be 5-10 minutes early, to be safe). If you are late, and other students have already started the exam, you will have to schedule another exam by coming to the web site and sending in another reservation.
- You will have 2.0 hours to take the exam. - You must earn a grade greater than 60% to pass the exam. - You may take the exam only one time.

 

Excel Topics Covered on the Examination

PLEASE NOTE - THE EXAMINATION USES EXCEL 2007
PLEASE NOTE - THE "HELP" FEATURE WILL NOT BE AVAILABLE

PLEASE NOTE - THIS EXAMINATION IS FOR STUDENTS WHO HAVE ALREADY LEARNED EXCEL 2007 AND WHO REGULARY USE THE FOLLOWING FEATURES IN EXCEL 2007:

• Use of Range Names (Named ranges)
• Apply Number Formatting
• Apply Font & Alignment Formatting
• Sorting data (multi-level sorts)
• Copy a Chart Move Data, Add Borders, Rotate Text
• Move, Copy, Paste cell contents
• Display & Print Formulas
• Scale a Worksheet for Printing – fit-to-page; print a single page
• Use of common Functions (SUM, IF, COUNTIF, AVERAGE, VLOOKUP)
• Create & Sort a Table of data
• Convert a Table to a range of data
• Using a Custom AutoFilter with a Table
• Subtotal of data in a List of Data and in a Table
• Importing a Text File
• Create a Two-Variable Data Table
• Identify & Remove Duplicate Rows
• Apply Conditional Formatting, using Custom Formats & Data bars
• Insert, Move, Name, a Rename a Worksheet
• Copy Formulas
• Insert Columns & Insert Rows
• Freeze & Unfreeze panes
• Display multiple worksheets and workbooks in the same window
• Insert a Comment

- You will have 2.0 hours to take the exam.
- You must earn a grade greater than 60% to pass the exam.
- You may take the exam only one time.

this web page is maintained by Br. Walter Liss, Computer Science, Siena College