Skip to main content Skip to footer

CS150 Assessment

The Testing Center offers the Scott L. Carmona College of Business’s CS150 Assessment.  This examination allows students to waive the CS150 course requirement by demonstrating proficiency in Microsoft Excel.  Potential topics include formulas and functions, charts, Goal Seek, name ranges, and more.  For a full list of possible test topics, please see below.

Registration for this exam is time sensitive and includes 2 steps: making an appointment and then purchasing the exam.  It is recommended that students begin the process at least seven days before their desired test date.  Please see below for more details.  Testers are required to present a physical photo ID (student ID, driver's license, passport, or state ID) on test day; electronic IDs or "photos" of an ID will not be accepted.  No exceptions can be made to this policy.

Schedule Your Test

CS150 Assessment Important Information

The total cost of the CS150 Assessment is $65, which includes the exam fee and the proctoring fee.  Students will make two separate payments during the registration process.  The first payment ($30) is collected when making the appointment.  The second payment ($35) is made directly to ExPrep after the student receives access to the CS150 Assessment Canvas page and completes the exam setup instructions.  Registration is not complete until both payments have been made.  There are no walk-ins for testing.

To register:

  1. Make an appointment and pay the $30 registration fee no less than seven days before the desired test date.
  2. Wait for an email from the Center with setup instructions and access to the CS150 Canvas page.  This email may take up to 48 hours to arrive.
  3. No less than 4 days before the test date, follow the instructions in Canvas to:
    • Set up the exam.
    • Purchase the exam access code ($35).
    • Submit the access code to complete registration.

Important information: All registration steps must be completed by the stated deadlines.  Students who do not meet these requirements will not be allowed to test on their selected date.  On test day, testers should arrive no less than 15 minutes before their appointment time to complete the check-in process to ensure they are seated in time for their test to begin (the exam will open exactly at the time they chose for their appointment).


The CS150 Assessment measures a student's ability to use various Microsoft Excel functions.  The exam is 90 minutes long and consists of a workbook with five pages, each with multiple tasks to complete.  Internet access is not permitted during the test though students may use Excel's built-in help feature without penalty.  However, points will be deducted if the required function or method posed by the question is not used.  Scrap paper, pencils, and a directions sheet will be provided to each tester.  Possible exam topics are below; not every topic will appear on the exam, and questions may draw from a variety of content areas.

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

After the exam is completed, it is reviewed by the College of Business and ExPrep.  Once scored, results are sent to the Testing Center.  On test day, students may choose to have their results emailed to them or return to the Center to receive them in person.  A score of 75 or higher is required to pass the assessment.

What if I don’t pass?

Students who do not earn a passing score may retake the assessment once during a future semester.  After two unsuccessful attempts, students must take the CS150 course.  The registration process for the retake is the same as the initial exam.  Students must schedule a new appointment and follow the instructions provided by the Testing Center.  Students may receive their score, but exam questions and answers cannot be released.

What if I pass?

Students who earn a score of 75 or higher satisfy the CS150 requirement and may enroll in courses that list CS150 as a prerequisite.  However, passing the test does not award credit for CS150, meaning they must make up the 1 credit lost for this class in one of two ways:

  • Take another course.  Students should consult with their advisor regarding appropriate options.
  • Earn credit through the CLEP exam.  Information is available on the Center's CLEP website or students can contact the Center directly to learn more.

 


Students who are unable to attend this exam at their scheduled date and time should contact the Testing Center immediately by email (testing@svsu.edu) or phone (989-964-2820).  Staff will make every effort to reschedule the appointment.  If the exam is no longer needed, the Center’s cancellation policy will apply.


CONTACT US.






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