Robert Half Skills Assessment — Questions and Answers

Question 1: In an Excel table, what automatically happens when you add a new row directly below the last data row?

A warning dialog appears
A new worksheet is created
The new row is ignored by formulas
The table expands to include the new row (Correct answer)

Correct answer: The table expands to include the new row

Excel tables automatically extend their range, formatting, and structured references to include new adjacent rows.

Question 2: A client is verbally aggressive toward you during a call, despite you having fulfilled all obligations. What is the best response?

Hang up the call immediately
Remain calm, acknowledge their frustration, address the facts, and involve a supervisor if needed (Correct answer)
Apologize repeatedly even though you did nothing wrong
Match their tone to assert yourself

Correct answer: Remain calm, acknowledge their frustration, address the facts, and involve a supervisor if needed

De-escalating with calm professionalism and factual responses is the most effective way to handle aggressive clients.

Question 3: Which financial statement shows a company's revenues and expenses over a specific period?

Cash Flow Statement
Balance Sheet
Income Statement (Correct answer)
Statement of Retained Earnings

Correct answer: Income Statement

The income statement (also called a profit and loss statement) summarizes revenues, costs, and expenses to show net profit or loss.

Question 4: The assumption that a business will continue to operate for the foreseeable future and will not be forced to liquidate its assets is known as the:

Periodicity Assumption
Going Concern Assumption (Correct answer)
Historical Cost Principle
Materiality Principle

Correct answer: Going Concern Assumption

The Going Concern Assumption is the fundamental concept that a business will remain in operation for the foreseeable future. This assumption allows for the recording of assets at their historical cost and depreciating them over their useful lives, as it's assumed the business will last long enough to realize their full value.

Question 5: A long-term asset's cost is expensed.

As the asset benefits the company (Correct answer)
When it is paid for
In the period in which its is acquired
In the period in which it is disposed of

Correct answer: As the asset benefits the company

The matching principle in accounting dictates that expenses should be recognized in the same period as the revenues they help generate. For long-term assets, their cost is expensed through depreciation (or amortization for intangibles) over their useful life, reflecting the periods in which the asset provides economic benefits to the company. This ensures that the financial statements accurately portray the company's profitability.

Question 6: What is a 'remittance advice' in the context of accounts payable?

An internal AP report showing total amounts owed by vendor
A document the vendor sends listing overdue balances
Information a buyer sends with a payment specifying which invoices are being paid (Correct answer)
A bank notice that a check has cleared

Correct answer: Information a buyer sends with a payment specifying which invoices are being paid

A remittance advice accompanies or precedes a payment and tells the vendor exactly which invoices are being settled, facilitating accurate cash application on the vendor's side.

Question 7: Which option under Paste Special allows you to paste only the calculated values without the underlying formulas?

All
Values (Correct answer)
Formats
Formulas

Correct answer: Values

Paste Special > Values pastes the computed results as static data, removing formula dependencies.

Question 8: When sending a business proposal via email, what attachment format is most professional?

A Google Docs link so the recipient can edit it
A PDF to preserve formatting across all devices (Correct answer)
A .txt file for universal compatibility
A screenshot of the document

Correct answer: A PDF to preserve formatting across all devices

PDFs preserve formatting and appear professional regardless of the recipient's software or device.

Question 9: You receive constructive criticism from your manager about a report you submitted. You disagree with some of the feedback. What is the most professional initial response?

Accept the feedback without question and change the report, even though you believe your original version was better.
Say nothing during the meeting, but privately complain to your coworkers about the unfair feedback.
Immediately defend your work and explain in detail why the manager's points are incorrect.
Thank your manager for the feedback and ask clarifying questions to fully understand their perspective. (Correct answer)

Correct answer: Thank your manager for the feedback and ask clarifying questions to fully understand their perspective.

This approach is the most professional because it shows you are receptive to feedback, value your manager's opinion, and are committed to understanding their perspective before reacting. It opens a constructive dialogue rather than creating a defensive or confrontational atmosphere. After understanding their viewpoint, you can then professionally discuss any points of disagreement.

Question 10: You are helping a customer and realize mid-interaction that you gave them incorrect information earlier. What should you do?

Blame the system for the error
Hope they don't notice and finish the interaction
Continue with the incorrect information to avoid confusion
Correct the error immediately and apologize (Correct answer)

Correct answer: Correct the error immediately and apologize

Owning and correcting mistakes promptly builds trust and prevents compounding the problem.

Question 11: You are entering Social Security Numbers and must type 500 records. What habit most reduces the chance of transposition errors in 9-digit sequences?

Enter all numbers in a single unbroken flow without pausing
Break the number into its standard XXX-XX-XXXX groups and verify each segment (Correct answer)
Read only the last four digits since they are most unique
Type each SSN twice in rapid succession

Correct answer: Break the number into its standard XXX-XX-XXXX groups and verify each segment

Mentally segmenting an SSN into its three standard groups reduces working memory load and makes it easier to spot transpositions.

Question 12: You are cleaning a dataset and want to highlight all cells in column C that contain a value greater than 500. Which Excel feature would you use to accomplish this automatically?

Chart
Sort
Conditional Formatting (Correct answer)
Filter

Correct answer: Conditional Formatting

Conditional Formatting allows you to apply specific formatting, such as changing the cell color, to cells that meet certain criteria. In this case, you would create a rule to highlight cells with values greater than 500. While Filter can hide rows that don't meet the criteria, it doesn't change the formatting of the cells themselves. Sort arranges data, and Chart visualizes it.

Question 13: The customer service and Upgrading Representative is the primary point of contact for consumers to address and rapidly resolve issues and concerns. Experience with client concerns and finding solutions is necessary for this position. <br> <br> Answer: Customer Success Specialist

TRUE
FALSE (Correct answer)

Correct answer: FALSE

The provided description focuses on a 'Customer Service and Upgrading Representative' who primarily addresses and resolves customer issues and concerns. While a Customer Success Specialist also focuses on customer satisfaction, their role typically involves proactive engagement, fostering long-term relationships, and driving product adoption and value, which goes beyond just reactive problem-solving. Therefore, the description is not a precise match for a Customer Success Specialist.

Question 14: A data entry operator is tasked with inputting a large batch of sales invoices. To ensure the highest level of accuracy, which of the following is the most effective initial step to take?

Begin entering the data immediately to maximize speed.
Set a high Keystrokes per Hour (KPH) target to stay motivated.
Review the source documents for clarity, completeness, and consistency before starting. (Correct answer)
Memorize the keyboard shortcuts for the data entry software.

Correct answer: Review the source documents for clarity, completeness, and consistency before starting.

Ensuring the source data is 'good'—clear, complete, and consistent—is the most critical first step in preventing errors. Starting with flawed source documents will inevitably lead to inaccurate entries, regardless of typing speed or software proficiency.

Question 15: Which of the following is the correct order for sorting names in an alphabetical filing system?

First name, then last name, then middle initial
Last name, then first name, then middle initial (Correct answer)
Last name, then middle initial, then first name
Middle initial, then last name, then first name

Correct answer: Last name, then first name, then middle initial

Standard alphabetic filing indexes by surname first, then given name, then middle initial or name.

Question 16: What is the key difference between 'Save' and 'Save As' in Microsoft Word?

Save As is used exclusively for exporting documents to PDF format
Save overwrites the current file while Save As lets you choose a new name, location, or file format (Correct answer)
They are functionally identical operations
Save creates a backup copy while Save As saves the original

Correct answer: Save overwrites the current file while Save As lets you choose a new name, location, or file format

Save overwrites the existing file with current changes, while Save As creates a new copy that can be given a different name, saved to a different folder, or saved in a different format.

Question 17: How long should a professional executive summary typically be?

10–20 pages
Only one sentence
One to two pages (Correct answer)
As long as the full report

Correct answer: One to two pages

An executive summary condenses the full report into one to two pages so decision-makers can quickly understand key points.

Question 18: A customer praises your service at the end of the call. What is the most professional response?

Accept the compliment and take full personal credit
Thank them sincerely and invite them to reach out if they need anything else (Correct answer)
Tell them to leave an online review immediately
Say 'no problem' and end the call quickly

Correct answer: Thank them sincerely and invite them to reach out if they need anything else

A sincere thank-you and an open invitation reinforces the positive experience and leaves the door open for future engagement.

Question 19: A customer is calling about a package that was marked delivered but they never received it. What is the first step?

Tell them it was delivered and there's nothing you can do
Express empathy, confirm the delivery details, and initiate an investigation (Correct answer)
Ask them to contact the carrier directly
Suggest they check with neighbors before calling back

Correct answer: Express empathy, confirm the delivery details, and initiate an investigation

Taking ownership and initiating an investigation demonstrates responsibility and begins resolving the problem.

Question 20: Which of the following metrics is most commonly used to measure both speed and accuracy for numeric data entry roles?

Keystrokes Per Hour (KPH) with an accuracy percentage (Correct answer)
Words Per Minute (WPM)
Characters Per Second (CPS)
Lines Per Hour (LPH)

Correct answer: Keystrokes Per Hour (KPH) with an accuracy percentage

Keystrokes Per Hour (KPH) is the standard industry metric for measuring the speed of data entry, particularly for numeric data using the 10-key pad. This is always assessed alongside an accuracy percentage, as high speed is useless without high accuracy.

Question 21: You notice that your company's social media account has posted factually incorrect information about a product. What should you do?

Ignore it since it is not your department
Post a public correction using your personal account
Respond in the comments section of the post to correct it
Alert the marketing team or manager responsible for the account so it can be corrected promptly (Correct answer)

Correct answer: Alert the marketing team or manager responsible for the account so it can be corrected promptly

Routing corrections through the responsible internal team ensures the issue is handled by those with appropriate authority.

Question 22: What does 'net 30' mean on a vendor invoice?

30 days of free credit before interest accrues daily
Full payment is due within 30 days of the invoice date with no early-pay discount (Correct answer)
The vendor will accept 30 payments in installments
A 30% discount if paid within 30 days

Correct answer: Full payment is due within 30 days of the invoice date with no early-pay discount

Net 30 means the entire invoice balance is due within 30 days of the invoice date, with no early-payment discount offered.

Question 23: When entering a series of phone numbers, you notice the format switches between (555) 123-4567 and 555-123-4567 mid-spreadsheet. What is the best course of action?

Continue entering in whichever format is fastest
Standardize all entries to one consistent format before submitting (Correct answer)
Skip inconsistent entries and flag them for a supervisor
Leave the mixed formats and note the discrepancy in a separate column

Correct answer: Standardize all entries to one consistent format before submitting

Data consistency is critical; standardizing formats before submission prevents downstream errors in sorting, searching, and reporting.

Question 24: In a professional email, where should the most critical information be placed?

In the subject line and the opening paragraph (Correct answer)
In a postscript (P.S.) for emphasis
At the very end as a conclusion
In the middle of the email body

Correct answer: In the subject line and the opening paragraph

Recipients decide whether to read further based on the subject line and opening lines, so key information must appear there.

Question 25: What does 'latency' mean in the context of networking?

The maximum bandwidth of a network connection
The number of devices connected to a router
The encryption strength of a network protocol
The delay between sending a request and receiving a response (Correct answer)

Correct answer: The delay between sending a request and receiving a response

Latency is the time delay experienced in a network, typically measured in milliseconds from request to response.

Question 26: Which of the following transactions increases both total assets and total liabilities?

Borrowing money from a bank (Correct answer)
Paying off a bank loan with cash
Issuing stock for cash
Collecting an account receivable

Correct answer: Borrowing money from a bank

Borrowing from a bank increases cash (asset) and increases notes payable (liability) by equal amounts.

Question 27: If you want to count cells that meet multiple criteria across different ranges, which function should you use?

COUNTIF
DCOUNT
COUNTIFS (Correct answer)
SUMPRODUCT

Correct answer: COUNTIFS

COUNTIFS evaluates multiple criteria across multiple ranges and counts rows where all criteria are met.

Question 28: Which of the following is the best practice when leaving a professional voicemail?

Ask the recipient to call back without explaining the reason
State your name, company, purpose, and callback number slowly and clearly (Correct answer)
Speak quickly to save time and hang up without leaving a callback number
Leave a voicemail only if you have more than five minutes of information to share

Correct answer: State your name, company, purpose, and callback number slowly and clearly

Including all key details in a voicemail allows the recipient to prepare before returning your call.

Question 29: Deferred revenue appears on the balance sheet as a:

Current asset
Liability (Correct answer)
Component of equity
Long-term asset

Correct answer: Liability

Deferred revenue is a liability representing cash received before the related service or goods have been delivered.

Question 30: What is the result of =MOD(17, 5)?

5
2 (Correct answer)
3.4
3

Correct answer: 2

MOD returns the remainder after division: 17 ÷ 5 = 3 remainder 2, so MOD(17,5) = 2.

Question 31: What is the purpose of Freeze Panes in Excel?

Locks rows or columns so they remain visible when scrolling (Correct answer)
Prevents cells from being edited
Saves the current view as a named configuration
Protects the worksheet with a password

Correct answer: Locks rows or columns so they remain visible when scrolling

Freeze Panes locks specified rows or columns in place so headers stay visible as you scroll through large datasets.

Question 32: You discover that two of your teammates have a personal conflict that is visibly affecting team productivity. You are not their manager. What should you do?

Spread awareness of the conflict to the broader team
Do nothing since it is not your problem
Take sides with the colleague you are closer to
Speak privately to each person and encourage them to resolve it directly or involve management (Correct answer)

Correct answer: Speak privately to each person and encourage them to resolve it directly or involve management

Encouraging direct resolution or management involvement is the appropriate peer-level response to interpersonal conflicts.

Question 33: Which of the following is a characteristic of an object-oriented 'abstract class'?

It cannot be instantiated and is designed to be subclassed (Correct answer)
It has no methods or properties
It can only contain static methods
It can be instantiated directly like a regular class

Correct answer: It cannot be instantiated and is designed to be subclassed

An abstract class defines a template for subclasses but cannot be instantiated directly; it may include abstract methods that subclasses must implement.

Question 34: What does 'RSVP' mean in the context of a business event invitation?

Reserved seating, very private
Read, summarize, verify, and participate
Please respond (from French 'Répondez s'il vous plaît') (Correct answer)
Return shipment verified promptly

Correct answer: Please respond (from French 'Répondez s'il vous plaît')

RSVP is a French abbreviation meaning 'please respond,' indicating the host needs a confirmation of attendance.

Question 35: What is the debt-to-equity (D/E) ratio used to measure?

How quickly a company collects its receivables
The total market value of a company's shares
The proportion of financing that comes from creditors versus shareholders (Correct answer)
How much profit a company makes per dollar of equity

Correct answer: The proportion of financing that comes from creditors versus shareholders

The D/E ratio shows how leveraged a company is — a higher ratio indicates more reliance on debt financing.

Question 36: A visitor arrives 15 minutes early for a scheduled meeting with your manager, who is still in another meeting. What should you do?

Ask the visitor to reschedule
Interrupt the manager's current meeting immediately
Tell the visitor to come back at the correct time
Offer the visitor a seat, refreshments, and notify the manager discreetly (Correct answer)

Correct answer: Offer the visitor a seat, refreshments, and notify the manager discreetly

Making the visitor comfortable while discreetly informing the manager maintains professionalism and good hospitality.

Question 37: Which SQL statement is used to retrieve data from a database?

DELETE
UPDATE
SELECT (Correct answer)
INSERT

Correct answer: SELECT

The SELECT statement is used to query and retrieve records from one or more database tables.

Question 38: In a Word document using Content Controls (form fields), what setting prevents users from editing non-form areas?

Password-protecting the entire document
Restricting editing to 'Filling in forms' via the Restrict Editing pane (Correct answer)
Marking the document as Final
Setting the document to Read-Only mode

Correct answer: Restricting editing to 'Filling in forms' via the Restrict Editing pane

Setting the editing restriction to 'Filling in forms' locks all document content except designated form fields, ensuring users can only interact with intended input areas.

Question 39: What does the term 'double-keying' refer to in professional data entry?

Having two operators enter the same data independently to verify accuracy (Correct answer)
Typing each entry twice to build speed
Using two keyboards simultaneously for faster input
Pressing a key twice to confirm a database entry

Correct answer: Having two operators enter the same data independently to verify accuracy

Double-keying is a verification method where two operators independently enter the same data, and discrepancies are flagged for review.

Question 40: Which term describes the practice of selling a company's accounts receivable to a third party at a discount?

Securitization swap
Pledging
Discounting payables
Factoring (Correct answer)

Correct answer: Factoring

Factoring is the sale of receivables to a factor (financing company) at a discount, providing immediate cash in exchange for transferring collection responsibility.

Question 41: What does proofreading for 'parallelism' mean in business writing?

Ensuring all bullet points are indented the same amount
Making sure similar items in a list use the same grammatical form (Correct answer)
Writing two versions of the same document for comparison
Checking that headers appear on every page

Correct answer: Making sure similar items in a list use the same grammatical form

Parallel structure makes lists and sentences easier to read and more professional in appearance.

Question 42: What does EBITDA stand for?

Earnings Before Interest, Taxes, Depreciation, and Amortization (Correct answer)
Equity Balance Including Total Debt and Assets
Earnings Before Interest, Taxes, Dividends, and Amortization
Estimated Budget Including Taxes, Depreciation, and Allowances

Correct answer: Earnings Before Interest, Taxes, Depreciation, and Amortization

EBITDA measures a company's core operational profitability by excluding non-operating and non-cash expenses.

Question 43: What does a negative free cash flow indicate?

The company's stock price is declining
The company has no debt obligations
The company is spending more cash than it generates from operations (Correct answer)
The company is generating more cash than it spends

Correct answer: The company is spending more cash than it generates from operations

Negative free cash flow means the company is consuming more cash than its operations produce, which may require financing.

Question 44: What does the TRIM function do in Excel?

Extracts a substring from the middle of text
Converts text to uppercase
Rounds a number to a specified number of digits
Removes all spaces from text except single spaces between words (Correct answer)

Correct answer: Removes all spaces from text except single spaces between words

TRIM removes leading, trailing, and extra internal spaces, leaving only single spaces between words.

Question 45: A data entry operator types 8,500 net keystrokes per hour with 2 errors per 1,000 keystrokes. What is their approximate accuracy percentage?

99.8% (Correct answer)
97.5%
99.2%
98.0%

Correct answer: 99.8%

2 errors per 1,000 keystrokes equals 0.2% error rate, so accuracy is 100% - 0.2% = 99.8%.

Question 46: An administrative assistant is setting up a filing system for a new department that will handle client case files. Each client has a unique case number, but staff will most frequently need to access files based on the client's last name. Which filing system would be the most efficient for this department?

A chronological system, filed by the date the case was opened.
A numeric system, using the unique case number as the primary identifier.
An alphabetic cross-reference system, where files are stored numerically but an alphabetic index is used to look up the corresponding case number. (Correct answer)
A subject-based system, with folders for different types of legal issues.

Correct answer: An alphabetic cross-reference system, where files are stored numerically but an alphabetic index is used to look up the corresponding case number.

An alphabetic cross-reference system is the most efficient choice because it combines the benefits of two systems. Filing the physical folders numerically by case number keeps the records in a simple, expandable order. The separate alphabetic index (like a card file or a digital spreadsheet) allows staff to quickly find a client's case number by looking up their name, which is their most common search method.

Question 47: A customer is requesting an exception to a standard policy. You are unsure if you have the authority to grant it. What should you do?

Deny it without checking
Make the decision based on what feels right
Tell the customer you'll verify your authority and follow up before making a commitment (Correct answer)
Grant it anyway to appear helpful

Correct answer: Tell the customer you'll verify your authority and follow up before making a commitment

Verifying authority before committing protects both the customer and the company from unauthorized decisions.

Question 48: What is the recommended approach when you discover an error in a document after it has already been distributed?

Recall all copies and destroy them without explanation
Promptly issue a correction or erratum to all recipients (Correct answer)
Only correct it if someone specifically asks about it
Hope no one notices and correct future versions silently

Correct answer: Promptly issue a correction or erratum to all recipients

Proactively issuing a correction maintains credibility and ensures all recipients have accurate information.

Question 49: When presenting data verbally in a meeting, what is the most effective technique?

Summarize the key trend and explain what it means for the audience (Correct answer)
Show the raw data table and let attendees interpret it themselves
Read every number aloud from a spreadsheet for full transparency
Avoid mentioning data to keep the meeting conversational

Correct answer: Summarize the key trend and explain what it means for the audience

Summarizing trends and their implications makes data meaningful and actionable for your audience.

Question 50: A vendor offers terms of 1/15, net 60. What is the annualized cost of NOT taking the early-payment discount?

Approximately 16.2% (Correct answer)
Approximately 60%
Approximately 7.3%
Approximately 1%

Correct answer: Approximately 16.2%

Annualized cost = (Discount% / (1 − Discount%)) × (365 / (Net Days − Discount Days)) = (1/99) × (365/45) ≈ 8.19%; the closest standard answer is approximately 8%, but using the simplified formula (1% / 99%) × (365/45) ≈ 8.2%—option B at ~16.2% applies to 2/15 net 45 terms; for 1/15 net 60 the result is ~8.2%.

Question 51: What should you do before hitting 'Reply All' on a business email?

Confirm that every recipient on the thread actually needs to see your reply (Correct answer)
Always reply all to keep everyone informed
CC your manager on every reply-all response
Forward the email to a colleague first for approval

Correct answer: Confirm that every recipient on the thread actually needs to see your reply

Unnecessary Reply All responses clutter inboxes and can come across as unprofessional.

Question 52: A customer previously written off pays $500. Using the allowance method, what is the FIRST step to record this recovery?

Debit Cash, Credit Revenue
Reinstate the receivable by debiting Accounts Receivable and crediting Allowance for Doubtful Accounts (Correct answer)
Debit Cash, Credit Bad Debt Expense directly
Credit Accounts Payable for the recovered amount

Correct answer: Reinstate the receivable by debiting Accounts Receivable and crediting Allowance for Doubtful Accounts

The recovery first requires reinstating the receivable (reversing the write-off), then recording the cash receipt to close the reinstated balance.

Question 53: Which report is MOST useful for prioritizing daily collection calls in AR?

The accounts receivable aging report (Correct answer)
The income statement
The vendor ledger
The cash flow forecast

Correct answer: The accounts receivable aging report

The AR aging report categorizes outstanding customer balances by how long they are past due, helping collectors focus on the oldest and largest overdue accounts first.

Question 54: What is 'gross profit margin' and how is it calculated?

Total revenue divided by total expenses
Operating income divided by total equity
Net income divided by total assets
(Revenue minus cost of goods sold) divided by revenue (Correct answer)

Correct answer: (Revenue minus cost of goods sold) divided by revenue

Gross profit margin shows what percentage of revenue remains after direct production costs, before operating expenses.

Question 55: In a discounted cash flow (DCF) analysis, what does the discount rate represent?

The percentage reduction applied to accounts receivable
The company's gross margin percentage
The rate used to bring future cash flows to their present value, reflecting time value of money and risk (Correct answer)
The company's effective tax rate

Correct answer: The rate used to bring future cash flows to their present value, reflecting time value of money and risk

The discount rate adjusts future cash flows to today's value, accounting for risk and the opportunity cost of capital.

Question 56: What is the purpose of an AP subledger?

To reconcile the company's bank account monthly
To record all company-wide journal entries
To track the detailed balance owed to each individual vendor (Correct answer)
To calculate depreciation on fixed assets

Correct answer: To track the detailed balance owed to each individual vendor

The AP subledger maintains a separate balance for each vendor, and the total of all subledger balances must agree with the AP control account in the general ledger.

Question 57: In Excel, what does pressing Ctrl+Shift+End do?

Moves to the last cell in the current column
Saves and closes the file
Selects all cells to the right of the current cell
Extends the selection to the last used cell in the worksheet (Correct answer)

Correct answer: Extends the selection to the last used cell in the worksheet

Ctrl+Shift+End extends the current selection to the last cell that contains data or formatting in the worksheet.

Robert Half Skills Assessment

The Robert Half Skills Assessment evaluates candidates across accounting fundamentals, Microsoft Excel and Word proficiency, data entry accuracy, and workplace situational judgment to match applicants with suitable positions.

Questions

75 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds