Peak Inside Sales CSR Assessment
Evaluate your fit for Inside Sales CSR roles with precision, powered by Steel Spine™ and NeuroSell™.
Contact: team@peaktcs.com or 706-228-PEAK.
How to Use
- Enter your details and agree to the terms.
- Confirm you are not a robot to proceed.
- Complete the behavioral assessment sections.
- Review your score, recommendations, and visual results.
- Proceed to the Excel tasks (30-minute limit) and review results.
- Submit for evaluation and provide feedback.
Terms and Conditions
By participating, you agree: Responses are used solely for evaluation and not shared without consent. Peak Talent Capital Solutions is not responsible for technical issues. All information provided is accurate as of 03:59 PM EDT, September 29, 2025. Results are informational and do not guarantee employment. Contact team@peaktcs.com for full terms.
Behavioral Assessment Results
Below are your scores and recommendations based on your behavioral assessment.
Score Breakdown
Steel Spine (40%): 0/50
NeuroSell (30%): 0/50
CSR Traits (30%): 0/50
Total Behavioral Score: 0/100
Recommendation: Needs Development
Subcategory Scores
Resilience: 0/15
Conflict Resolution: 0/20
Motivation: 0/15
Emotional Connection: 0/15
Sales Strategy: 0/25
Trust Building: 0/10
Planning: 0/10
Process Execution: 0/30
Collaboration: 0/10
Visual Results
Recommendations
Excel Assessment
Perform the 25 tasks below using the interactive spreadsheet. Edit cells, add formulas (e.g., =SUM(A1:A10)), and describe chart/PivotTable steps in cells. Some tasks will be manually reviewed.
Time limit: 30 minutes recommended. Timer starts now.
25 Excel Actions/Tasks:
- In Orders sheet, add a column "Total Revenue" and use formula to calculate Quantity * Price for each row (e.g., =D2*E2).
- In Customers sheet, format LastOrderDate column as Short Date (mm/dd/yyyy).
- In Products sheet, add a column "Profit Margin %" and calculate (SellingPrice - Cost)/SellingPrice * 100 (e.g., = (E2-D2)/E2 * 100).
- In Orders sheet, use SUMIF to calculate total revenue from CustomerID "C001" (place in a summary cell).
- Create a PivotTable from Orders sheet to show total Quantity by Category (from Products sheet; describe steps in a cell).
- In Customers sheet, use COUNTIF to count customers in "Chicago".
- In Orders sheet, filter to show only orders after 2025-01-01.
- In Products sheet, sort by SellingPrice descending.
- In Orders sheet, use AVERAGEIF to find average Quantity for ProductID starting with "P0".
- Add a chart: Bar chart of TotalSpend by Location from Customers sheet (describe in a cell).
- In Orders sheet, use VLOOKUP to add Product Category from Products sheet (lookup ProductID).
- Calculate total orders value: Use SUM on Total Revenue column.
- In Customers sheet, use MAX to find highest TotalSpend.
- Use conditional formatting in Orders sheet to highlight Quantities >50 in yellow.
- In Products sheet, use IF to flag products where Cost >400 as "High Cost" in a new column.
- Create a formula in Orders sheet to calculate days since order: =TODAY() - F2 (format as number).
- Use COUNTIFS in summary: Count orders where Quantity >20 and Category="Additive".
- In Customers sheet, rank customers by TotalSpend using RANK.EQ.
- Merge Customers and Orders using VLOOKUP to add Customer Location to Orders sheet.
- Create a PivotChart: Line chart of total revenue by month from Orders Date (describe in a cell).
- In Products sheet, use MIN to find lowest SellingPrice.
- Use TEXTJOIN or concatenate to create a list of all Product Names in one cell.
- In Orders sheet, use SUBTOTAL to sum Quantity while filtering.
- Add data validation to a new sheet for Prospect Status (dropdown: New, Contacted, Quoted).
- Forecast: Use FORECAST.LINEAR in a summary to predict next TotalSpend for a customer based on historical (assume trend from Dates).
Spreadsheet Workspace
Excel Assessment Results
Preliminary score based on automated checks. Tasks like PivotTables, charts, formatting, and data validation require manual review.
Score Breakdown
Tasks Completed (Automated): 0/25
Preliminary Excel Score: 0/100
Final Combined Score: 0/100
Recommendation: Needs Review
Visual Results
Recommendations
Feedback
Rate your experience (1–5):
Thank You!
Your assessment has been submitted. A Peak representative will review and contact you.