VIP Exclusive

Robert Half Skills Assessment VIP Practice Exam

Robert Half Assessment Test — Robert Half does not administer a single standardized certification exam; rather, it uses a proprietary suite of skill assessments (covering Microsoft Office, accounting/bookkeeping, grammar, and business math) administered to job candidates during the staffing placement process. This practice exam is an original comprehensive set modeled on the domains, difficulty level, and scenario-based style of those assessments.

30
Questions
60m
Time Limit
75.00%
To Pass
Question 1 of 30👑 VIP

You are working in Microsoft Excel with a dataset where Column A contains product names (e.g., 'Laptop', 'Monitor', 'Keyboard') and Column B contains sales revenue. Several rows contain 'Laptop' as the product. Your manager asks you to calculate the total revenue for Laptops only. Which formula correctly accomplishes this in a cell outside the data range?

Questions 2–30 and full explanations are VIP-exclusive.