Skip to main content Skip to footer

CS150 Assessment

The Testing Center is pleased to offer the Scott L. Carmona College of Business’s CS150 Assessment.  This examination allows students to test out of CS150, a required business cognate course, by assessing their ability to use the various elements of an Excel program, including but not limited to math and text functions, chart design, goal seek and named ranges.  For a full list of possible test topics, please see below.

Please note that registration for this exam is time sensitive, and it is recommended that students begin the process at least seven days prior to the date that they wish to take their test.  Testers are required to present a physical photo ID (student ID, driver's license, passport, or state ID) on test day; electronic versions or "photos" of the original ID will not be accepted.  No exceptions can be made to this policy.

Schedule Your Test

CS150 Assessment Important Information

The total cost for the CS150 Assessment, which includes both the exam and the proctoring fee, is $59.99.  Payment will be collected in two stages during the registration process, half by the Center’s RegisterBlast site and half by ExPrep, the owner of the exam.  Failure to complete either step may result in an inability to take the test on the desired day.  There are no walk-ins for testing.  Directions for purchasing and scheduling:

  1. Testers must complete the Center's RegisterBlast appointment form 6 days prior to the desired test date; the first part of payment will be collected at the end of the form.
  2. Once Center staff have verified the appointment, the tester will receive an email with detailed instructions and an invite to the CS150 Assessment Canvas page.  Verification may take up to 48 hours to receive.
  3. No less than 4 days before the test date, examinees must follow the instructions sent by the Center which include:
    • Setting up their test through Canvas.
    • Purchasing their alphanumeric code from ExPrep (the second part of payment).
    • Submitting their alphanumeric code to complete their test purchase.

Failure to complete any portion of these steps will result in an inability to test on the desired day.


The CS150 Assessment will test a student’s ability to use various Excel functions.  Each test is comprised of a workbook with 5 pages; each page will contain 1 to 6 questions that require the tester to complete a variety of objectives within the 90 minutes allotted for the test.  Though students may not go online during the exam, there is no penalty for using the “help” option built into Excel, nor is there a penalty for the number of clicks it takes to complete the objective.  However, the student will lose points if the correct function is not used as the question directs even if there are a variety of ways to reach the right answer.  Scrap paper, pencils, and a directions sheet will be provided to each tester.  Possible exam topics are below; please note that the test will not cover every topic listed and that questions may come from a variety of categories/objectives.

Study Topics

Category Possible Objectives
Cells Understanding ribbon, cells and sheets; cell references; formatting versus rounding; adjusting row height/column width (including automatic column width adjustment and alignment tools) and inserting/deleting rows, columns and cells; transposing, changing orientation, hiding, freezing and applying borders to rows/cells; Relative, Anchoring, Absolute and Mixed Cell References
Printing & Various Formatting Spreadsheets, setting print regions, print page setup options, using page breaks in printing, adding headers/footers to printed reports; using icon and color scales formatting; Conditional Formatting and Formatting Rules/Rule Manager; Flash Fill
Tables/Charts Creating charts with Quick Analysis Tool; Chart Design tab; working with Sparklines; editing charts by adding/deleting items or moving/resizing; identifying chart parts, types, or using vocabulary; using table options, identifying styles, and editing table rows
Data Entry Working with Data Bars, fonts, and applying fills to cells; various function entry methods (manual typing, function insert button, Formula Tab, AutoSum, AutoFill); Date/Time Functions (Today, Now, Date, Day, EDate, EOMonth, Weekday, Year, YearFrac); sorting and filtering; basic/detailed versions of Find and Replace dialogs; numeric formats
Ranges Ranges and range selections including nonadjacent ranges; creating formulas containing named ranges; editing/deleting; copying, pasting and moving ranges
Lookup & Reference Functions H/V Lookup, Choose, FormulaText, Hyperlink, Index, Match
Math Functions Abs, Ceiling, Cos, Degrees Even, Exp, Fact, Floor, Int, Ln, Log, Log10, Mod, Odd, PI, Radians, Rand, RandBetween, Round Up/Down, Sign, Sin, Sqrt, Tan, Trunc, Subtotal Function, Circular Reference, Precedence
Statistical Functions Sum, Average, Median, Mean, Max, Min, Count/A/Blank, MODE.SNGL, MODE.MULT, STDEV.P, STDEV.S, VAR.P, VAR.S
Logical Functions IF and IFS, Comparison Operators, Logic Operators, And, False, IfError, IfNA, Not, Or, True, Xor
Financial Functions PMT, IPMT, PPMT, CUMIPMT, CUMPRINC, NPER, RATE, FV, PV, NPV; also functions related to depreciation, capital budgeting, etc; Goal Seek Examples
Ranking Functions RANK.EQ/AVG, PERCENTRANK.INC/ECX
Text Functions Clean, Concatenate, Find, Left, Len, Lower, Mid, Proper, Replace, Right, Search, Substitute, Text, Trim, Upper, Value

Upon completion, the test will be uploaded and then reviewed by the College of Business and ExPrep, the company who owns the examination.  Scores will be released to the Testing Center after review.  On exam day, examinees will be given the option to either have their scores sent to their SVSU email or to return to the Center to receive them verbally.  Students need a score of 75 or above to pass the assessment.

What if I don’t pass?

Students who do not receive a passing score may retake the CS150 Assessment one additional time.  However, they must wait until the following semester to retake the exam, meaning that if the assessment was taken in the summer semester, they must wait until the fall semester to try again.  After two attempts, the student must take the CS150 course.  The process to schedule a retake of the assessment is the same as the first attempt; students should register for an appointment and then follow the directions emailed by the Center staff.  It should be noted that Center staff cannot share the completed test or any test questions with students.

What if I do pass?

If a student receives a score of 75 or above, they do not have to take CS150 and may register for any class that requires that course as a prerequisite.  However, passing the assessment will not give the student the credit for CS150, meaning they must make up the 1 credit lost for this class in another way.  There are two options to do this:

  • They may make the credit up by taking another course. Students should speak with their Academic Advisor about which class would be most beneficial to their degree.
  • Students may take a CLEP exam to replace the credit; these exams give students college credit for various gen ed courses, including business.  For further information, please visit the Center’s CLEP website or contact the Center directly.

 


Because of the nature of this exam, students should contact the Testing Center immediately by either email (testing@svsu.edu) or telephone (989-964-2820) if they are unable to take their test at the day and time they have scheduled for.  A Center staff member will make every attempt to move the exam to another time slot.  If the student no longer wishes to take the exam, the Center’s cancellation policy will be adhered to.


CONTACT US.






The Testing Center @ SVSU
Zahnow 308
testing@svsu.edu
(989) 964-2820