Robert Half Skills Assessment — Questions and Answers

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

Net income divided by total assets
Total revenue divided by total expenses
Operating income divided by total equity
(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 2: A customer demands an immediate solution, but the issue genuinely requires 3–5 business days to resolve. How do you communicate this?

Apologize, clearly explain why it takes that long, and provide a status update schedule (Correct answer)
Tell them 3–5 days without any explanation
Promise a faster timeline you can't guarantee
Transfer them to someone else to avoid the difficult conversation

Correct answer: Apologize, clearly explain why it takes that long, and provide a status update schedule

Explaining the reason for the timeline and providing a status update plan demonstrates transparency and keeps the customer informed.

Question 3: If a company's net profit margin is 8%, what does this mean?

The company earns $8 in revenue for every $1 of expenses
The company pays 8% of revenue in taxes
The company's operating costs are 8% of total assets
The company retains $0.08 as net income for every $1 of revenue (Correct answer)

Correct answer: The company retains $0.08 as net income for every $1 of revenue

Net profit margin = Net Income ÷ Revenue, showing how much profit remains after all expenses are deducted.

Question 4: What is the purpose of a 'JOIN' clause in SQL?

To combine rows from two or more tables based on a related column (Correct answer)
To create a new table from an existing one
To sort query results by multiple columns
To delete records from two tables simultaneously

Correct answer: To combine rows from two or more tables based on a related column

A JOIN clause combines rows from multiple tables by matching values in related columns, enabling queries across relational data.

Question 5: Which type of office record retention schedule is mandated by federal or state law?

Statutory retention (Correct answer)
Discretionary retention
Internal retention
Voluntary retention

Correct answer: Statutory retention

Statutory retention schedules are legally required minimums set by federal or state regulations for specific document types.

Question 6: When a company issues common stock for cash, the journal entry includes:

Debit Common Stock; Credit Cash
Debit Cash; Credit Accounts Payable
Debit Retained Earnings; Credit Common Stock
Debit Cash; Credit Common Stock (Correct answer)

Correct answer: Debit Cash; Credit Common Stock

Issuing stock for cash debits Cash (asset increases) and credits Common Stock (equity increases).

Question 7: 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)
Avoid mentioning data to keep the meeting conversational
Show the raw data table and let attendees interpret it themselves
Read every number aloud from a spreadsheet for full transparency

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 8: What is the primary purpose of 'Mail Merge' in Microsoft Word?

Sending emails directly from Word
Merging two separate documents into one file
Combining multiple email attachments into a single file
Creating personalized copies of a document using data from an external source (Correct answer)

Correct answer: Creating personalized copies of a document using data from an external source

Mail Merge combines a template document with a data source such as an Excel spreadsheet to create personalized copies for multiple recipients.

Question 9: When writing a professional business email, what should appear in the subject line?

A concise, specific description of the email's purpose (Correct answer)
A vague overview of your day
Your full name and department
The recipient's name only

Correct answer: A concise, specific description of the email's purpose

A clear, specific subject line helps the recipient prioritize and locate the email quickly.

Question 10: Which function would you use to combine the text from cells A1 and B1 with a space between them?

=MERGE(A1," ",B1)
=JOIN(A1,B1)
=A1+" "+B1
=CONCATENATE(A1," ",B1) (Correct answer)

Correct answer: =CONCATENATE(A1," ",B1)

CONCATENATE (or the & operator) joins text strings together, and you can include a space character as a literal text argument.

Question 11: Under accrual accounting, when is revenue recognized for a credit sale?

When the customer places the order
When cash is collected from the customer
When the invoice is mailed to the customer
When the goods or services are delivered to the customer (Correct answer)

Correct answer: When the goods or services are delivered to the customer

Accrual accounting recognizes revenue when performance obligations are satisfied (goods/services delivered), regardless of when cash is received.

Question 12: A customer asks for a service that requires additional verification. The customer says the verification process is too complicated. How do you respond?

Apologize and waive the requirement
Explain why the verification is required and offer to guide them through each step (Correct answer)
Skip the verification to keep the customer happy
Tell them to call back when they're ready

Correct answer: Explain why the verification is required and offer to guide them through each step

Explaining the reason for policies and offering step-by-step guidance increases compliance and reduces friction.

Question 13: You are assigned two high-priority projects from two different managers, both with the same urgent deadline. You realize you cannot complete both tasks to the required standard within the given timeframe. What should you do?

Choose the project from the manager you like better and focus on completing that one perfectly.
Work overtime and try your best to complete both, even if the quality of both projects suffers.
Communicate the conflict to both managers, present a clear assessment of the workload, and ask for their help in prioritizing or adjusting the deadlines. (Correct answer)
Quietly work on one project first and hope to have enough time for the second one later.

Correct answer: Communicate the conflict to both managers, present a clear assessment of the workload, and ask for their help in prioritizing or adjusting the deadlines.

Proactive and transparent communication is key when managing competing priorities. By informing both managers of the deadline conflict, you demonstrate responsibility and allow them to make an informed decision about priorities. This is much more effective than failing to meet expectations for one or both projects without prior warning.

Question 14: A company has $180,000 in Accounts Receivable and its DSO is 36 days. What is its approximate daily credit sales figure?

$5,000 per day (Correct answer)
$6,480,000 per year
$2,500 per day
$6,000 per day

Correct answer: $5,000 per day

DSO = AR / Daily Sales, so Daily Sales = AR / DSO = $180,000 / 36 = $5,000 per day.

Question 15: What is the effect on the financial statements when an invoice is accrued at month-end but not yet paid?

Expenses increase and liabilities increase (Correct answer)
Only the balance sheet is affected; no income statement impact
Expenses decrease and equity increases
Assets increase and liabilities increase

Correct answer: Expenses increase and liabilities increase

Accruing an unpaid invoice records the expense on the income statement and creates a corresponding accrued liability on the balance sheet.

Question 16: In office supply inventory management, what is the 'reorder point'?

The inventory level at which a new order should be placed to avoid running out (Correct answer)
The price point at which supplies are considered too expensive
The date when annual supply budgets reset
The maximum amount of supplies allowed in storage

Correct answer: The inventory level at which a new order should be placed to avoid running out

The reorder point is the predetermined stock level that triggers placing a new order, accounting for lead time and usage rate.

Question 17: During a remote team meeting, one participant dominates the conversation and others cannot contribute. As a non-facilitating participant, what should you do?

Send private messages mocking the situation to other team members
Politely interject to invite quieter members to share their perspectives (Correct answer)
Interrupt the dominant speaker repeatedly
Leave the meeting early to signal displeasure

Correct answer: Politely interject to invite quieter members to share their perspectives

Inclusive participation improves meeting outcomes and is a valued professional behavior.

Question 18: You are copying data from a printed report into a database. The printed document shows '0' and 'O' in ambiguous font. What is the best strategy?

Cross-reference with context clues or source documents to determine the correct character (Correct answer)
Always enter zero since numbers are more common in databases
Always enter the letter O to avoid numeric errors
Enter whichever character you think looks right and move on quickly

Correct answer: Cross-reference with context clues or source documents to determine the correct character

Context clues such as surrounding data type (numeric field vs. text field) help disambiguate visually similar characters.

Question 19: Petty cash is replenished when the fund runs low. The journal entry to replenish it includes:

A debit to Petty Cash and a credit to Accounts Payable
A debit to Cash and a credit to Petty Cash
Debits to expense accounts and a credit to Petty Cash
Debits to expense accounts and a credit to Cash (Correct answer)

Correct answer: Debits to expense accounts and a credit to Cash

Replenishment debits the various expense accounts for items purchased and credits Cash for the total amount reimbursed.

Question 20: When creating a professional Word report, which feature is used to label figures and tables so they can be automatically cross-referenced?

Bookmark
Footnote
Caption (Correct answer)
Endnote

Correct answer: Caption

The Caption feature in the References tab labels figures, tables, and equations with auto-numbered captions that update automatically and can be used for cross-references and lists of figures.

Question 21: Which sentence uses active voice correctly?

The analyst completed the report. (Correct answer)
The report had been completed.
The report was completed by the analyst.
Completion of the report was done by the analyst.

Correct answer: The analyst completed the report.

Active voice is clearer and more direct because the subject performs the action.

Question 22: A company's accounts receivable turnover ratio is declining year over year. What does this most likely indicate?

The company is collecting payments from customers faster
The company is taking longer to collect payments from customers (Correct answer)
The company's inventory is growing
The company's sales are increasing rapidly

Correct answer: The company is taking longer to collect payments from customers

A declining accounts receivable turnover ratio suggests slower collections, which can strain cash flow.

Question 23: An input mask formatted as '(999) 000-0000' is applied to a phone number field. What does the '9' vs '0' indicate in this mask?

9 indicates alphabetic input; 0 indicates numeric input
9 and 0 both indicate required digits but from different ranges
9 means the digit is required; 0 means it is optional
9 means any digit is allowed optionally; 0 means a digit is required (Correct answer)

Correct answer: 9 means any digit is allowed optionally; 0 means a digit is required

In many input mask conventions, '0' requires a digit while '9' allows a digit but treats it as optional.

Question 24: Which Excel function returns the largest value in a range?

UPPER
TOP
MAX (Correct answer)
LARGE

Correct answer: MAX

MAX scans a range and returns the highest numeric value found, ignoring text and empty cells.

Question 25: A customer speaks limited English and is struggling to communicate their issue. How do you handle this?

Speak loudly and slowly in English
Use simple language, confirm understanding frequently, and use any available translation resources (Correct answer)
Transfer them to voicemail
Ask them to call back with a translator

Correct answer: Use simple language, confirm understanding frequently, and use any available translation resources

Simplifying language and leveraging translation tools ensures every customer can access service equitably.

Question 26: You are offered a gift by a vendor worth $150 after completing a successful contract. Your company's gift policy limit is $50. What do you do?

Accept and donate the difference in value to charity
Accept and keep it private to avoid scrutiny
Politely decline and explain your company's gift policy (Correct answer)
Accept the gift since it was a thank-you gesture

Correct answer: Politely decline and explain your company's gift policy

Gifts that exceed company policy limits must be declined to avoid conflicts of interest.

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

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

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 28: Which Excel function returns the position (row number) of a value within a range?

SEARCH
LOOKUP
MATCH (Correct answer)
FIND

Correct answer: MATCH

MATCH returns the relative position of a value in a range; it's often combined with INDEX for flexible lookups.

Question 29: What is the Days Payable Outstanding (DPO) formula?

(Accounts Receivable / Revenue) × 365
(Accounts Payable / Cost of Goods Sold) × 365 (Correct answer)
(Revenue / Accounts Payable) × 365
(Cost of Goods Sold / Accounts Payable) × 365

Correct answer: (Accounts Payable / Cost of Goods Sold) × 365

DPO measures how many days on average a company takes to pay its vendors: (AP / COGS) × 365.

Question 30: In financial analysis, what is a 'pro forma' statement?

A government-required disclosure filed with the SEC
A restatement of prior-year financials due to errors
A summary of past audit findings
A financial projection based on hypothetical or expected future conditions (Correct answer)

Correct answer: A financial projection based on hypothetical or expected future conditions

Pro forma statements are forward-looking financial projections used for planning, mergers, or scenario analysis.

Question 31: A new policy is introduced that you believe will negatively impact team morale. What is the most professional response?

Refuse to follow the policy until it is changed
Openly criticize the policy to your team to rally opposition
Voice your concerns through appropriate channels such as a manager or feedback process (Correct answer)
Comply with the policy and say nothing

Correct answer: Voice your concerns through appropriate channels such as a manager or feedback process

Raising concerns through proper channels respects organizational processes while allowing legitimate feedback to be heard.

Question 32: An adjusting entry to record accrued salaries expense at year-end would:

Debit Salaries Expense; credit Cash
Debit Salaries Payable; credit Salaries Expense
Debit Salaries Expense; credit Salaries Payable (Correct answer)
Debit Cash; credit Salaries Expense

Correct answer: Debit Salaries Expense; credit Salaries Payable

Accrued salaries are recorded by debiting Salaries Expense (increasing expenses) and crediting Salaries Payable (creating a liability).

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

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

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 34: A customer wants to speak to your manager after you've already offered a resolution. What is the best response?

Acknowledge their request, summarize what you offered, and connect them to a supervisor (Correct answer)
Put them on hold indefinitely
Argue that your solution is the best available
Refuse and explain that your answer is final

Correct answer: Acknowledge their request, summarize what you offered, and connect them to a supervisor

Escalating professionally while summarizing the prior offer ensures continuity and respects the customer's choice.

Question 35: 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?

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

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 36: What is the difference between a relative and absolute cell reference when copying a formula?

Relative references adjust to the new location; absolute references stay fixed (Correct answer)
Absolute references update automatically; relative references stay fixed
Relative references only work within the same sheet
Both types behave identically when copying

Correct answer: Relative references adjust to the new location; absolute references stay fixed

Relative references shift based on the formula's new position, while absolute references (using $) remain fixed regardless of where the formula is copied.

Question 37: Which ratio measures a company's ability to pay interest on its outstanding debt?

Return on assets
Debt-to-equity ratio
Current ratio
Times interest earned ratio (Correct answer)

Correct answer: Times interest earned ratio

Times Interest Earned = EBIT / Interest Expense, measuring how many times operating income covers interest obligations.

Question 38: What is the purpose of the SUMPRODUCT function?

Multiplies corresponding elements in arrays and returns the sum of those products (Correct answer)
Returns the largest product of any two values in a range
Sums all products in a catalog list
Creates a multiplication table for two ranges

Correct answer: Multiplies corresponding elements in arrays and returns the sum of those products

SUMPRODUCT multiplies corresponding elements across multiple arrays and then sums all the resulting products.

Question 39: An operator accidentally swaps two adjacent digits when entering a product ID, keying in '87' instead of '78'. What is this specific type of error called?

Omission error
Transcription error
Formatting error
Transposition error (Correct answer)

Correct answer: Transposition error

A transposition error occurs when two adjacent characters, typically numbers or letters, are reversed during data entry. This is a common mistake that requires careful proofreading to catch.

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

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

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 41: What does EBITDA stand for?

Earnings Before Interest, Taxes, Depreciation, and Amortization (Correct answer)
Earnings Before Interest, Taxes, Dividends, and Amortization
Equity Balance Including Total Debt and Assets
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 42: When taking meeting minutes, what is the primary objective an administrative professional should focus on?

Writing a brief, one-paragraph summary of the meeting's general mood.
Recording the key decisions made and the action items assigned. (Correct answer)
Creating a verbatim transcript of everything that was said.
Documenting personal opinions and detailed arguments of each participant.

Correct answer: Recording the key decisions made and the action items assigned.

The most important function of meeting minutes is to create an official record of what was decided and what tasks were assigned to whom, including deadlines. While context is important, the focus should be on outcomes rather than a word-for-word transcript of the discussion.

Question 43: What does the $ symbol do when placed before a column letter in a cell reference like $B5?

Locks the entire cell
Locks the entire row
Locks the row only
Locks the column only (Correct answer)

Correct answer: Locks the column only

A $ before the column letter creates an absolute column reference, so the column stays fixed when the formula is copied.

Question 44: What is the most appropriate way to begin a formal business letter in the US?

Yo,
What's up,
Hey there,
To Whom It May Concern: (Correct answer)

Correct answer: To Whom It May Concern:

'To Whom It May Concern:' is a standard, professional salutation when the recipient's name is unknown.

Question 45: A company purchased equipment for $50,000 cash. How does this affect the accounting equation?

Assets increase $50,000; equity decreases $50,000
Assets decrease $50,000; equity decreases $50,000
One asset increases $50,000; another asset decreases $50,000 (Correct answer)
Assets increase $50,000; liabilities increase $50,000

Correct answer: One asset increases $50,000; another asset decreases $50,000

Buying equipment for cash swaps one asset (cash) for another (equipment), keeping total assets unchanged.

Question 46: What is the recommended approach when you are uncertain about a data value while performing a timed data entry test?

Guess and continue to preserve your time score
Enter a placeholder like 'N/A' in every uncertain field
Leave the field blank and continue, then return if time allows (Correct answer)
Stop the test and ask for clarification before proceeding

Correct answer: Leave the field blank and continue, then return if time allows

Leaving uncertain fields blank and returning later balances speed with accuracy, preventing random guesses from inflating your error count.

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

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

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 48: When transferring a caller who did not want to be transferred, what is the best approach?

Explain why the transfer is necessary, give the direct number, and stay on the line during transfer (Correct answer)
Ask the caller to call back later
Take a message and hang up
Transfer without warning

Correct answer: Explain why the transfer is necessary, give the direct number, and stay on the line during transfer

Explaining the reason, providing a backup number, and monitoring the transfer ensures the caller feels respected and the connection succeeds.

Question 49: What is the key difference between a purchase order and a vendor invoice?

A purchase order records payment; an invoice records the order
Both are issued by the vendor but at different times
A purchase order is issued by the vendor; an invoice is issued by the buyer
A purchase order is issued by the buyer to authorize a purchase; an invoice is the vendor's demand for payment (Correct answer)

Correct answer: A purchase order is issued by the buyer to authorize a purchase; an invoice is the vendor's demand for payment

The buyer issues a purchase order to authorize a transaction; the vendor then sends an invoice billing the buyer for goods or services delivered.

Question 50: A company borrows $10,000 from a bank on a 6-month, 8% note payable. How much interest will accrue over the 6-month term?

$600
$400 (Correct answer)
$800
$480

Correct answer: $400

Interest = Principal × Rate × Time = $10,000 × 8% × (6/12) = $400.

Question 51: The price of research and development.

In accordance with generally accepted accounting principles, must be expensed as incurred (Correct answer)
Considered to be intangible assets
Should be accounted for in the price of the relevant patent
Are capitalized, followed by an amortization period of no more than 20 years

Correct answer: In accordance with generally accepted accounting principles, must be expensed as incurred

Under Generally Accepted Accounting Principles (GAAP), research and development (R&D) costs are generally required to be expensed in the period they are incurred. This is due to the inherent uncertainty regarding the future economic benefits of R&D activities. While R&D can lead to valuable assets like patents, the costs themselves are not capitalized as intangible assets until specific criteria for technological feasibility are met, which is rare for R&D itself.

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

Read, summarize, verify, and participate
Please respond (from French 'Répondez s'il vous plaît') (Correct answer)
Reserved seating, very private
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 53: In Excel's Name Box (the box to the left of the formula bar), what happens when you type a cell address and press Enter?

It renames the active cell
It selects all cells with that value
It navigates directly to that cell (Correct answer)
It inserts the address as a formula

Correct answer: It navigates directly to that cell

Typing a cell address (e.g., D15) in the Name Box and pressing Enter moves the active cell to that location.

Question 54: What is 'float' in the context of accounts payable check disbursements?

A penalty fee charged by vendors for late payment
The time between when a check is written and when it clears the company's bank account (Correct answer)
The balance remaining in petty cash
The difference between the invoice amount and the discounted payment amount

Correct answer: The time between when a check is written and when it clears the company's bank account

Float is the period between check issuance and bank clearance, during which the company retains use of the cash and the bank balance has not yet decreased.

Question 55: When asked to enter data from multiple source documents simultaneously, what is the most effective workflow strategy?

Process the shortest document last to end on a quick task
Complete all entries from one document before moving to the next (Correct answer)
Alternate between documents with each keystroke to stay efficient
Enter data randomly to reduce repetitive strain

Correct answer: Complete all entries from one document before moving to the next

Completing one document at a time minimizes context switching, reduces errors, and makes it easier to track progress.

Question 56: What happens when you use the Remove Duplicates feature on a dataset in Excel?

Duplicate rows are highlighted but not deleted
All duplicate rows including the first are deleted
One copy of each duplicate row is kept and others are permanently deleted (Correct answer)
Duplicates are moved to a new sheet

Correct answer: One copy of each duplicate row is kept and others are permanently deleted

Remove Duplicates retains the first occurrence of each unique row and permanently deletes all subsequent duplicates.

Question 57: 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)
CC your manager on every reply-all response
Always reply all to keep everyone informed
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.

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