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 the Center may only give this assessment during certain periods of the semester and at limited times; these testing windows are approved by the College of Business. 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.

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. No less than 6 days prior to the date the tester wishes to take the exam, they must make an appointment with the Testing Center by visiting RegisterBlast and completing the form located there; at the end of the form, they will be prompted to pay the proctoring fee. Once the appointment has been verified by a Center staff member, the tester will receive an email with detailed instructions.  Verification may take up to 48 hours to receive.
  2. Follow the instructions sent by the Center to set up the testing account through Canvas and purchase the exam.  These instructions will be emailed to the address provided in RegisterBlast and they are time sensitive.  Testers should watch their email closely and follow the instructions as soon as possible after receipt.

The CS150 Assessment will test a student’s ability to use various Excel functions.  Each test is comprised of a workbook with five pages; each page will contain one to six 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.  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

CategoryPossible 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

Testers should arrive no less than 15 minutes prior to their appointment time to complete check-in.  The test will begin at exactly the time registered for so students must be at their station, logged in and ready by that time.  Students must have photo ID on the day of the test; scrap paper and pencils will be provided by the Center.  No personal electronics are allowed.  Per the College of Business’s policy, those who arrive more than 5 minutes late for their test will not be allowed to take the exam as it would be a disruption to the other testers and will forfeit any fees paid.


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.


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 2-5 business days after review. On exam day, test takers 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.


CONTACT US.






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