2022 Accuracy Assessment -- Online Survey

4. *

If the information previously provided to the client is true, what would be the remaining balance due after June 30, 2019?

"Billing Support Request #29371: I called last week and spoke with someone regarding my invoice #2779182 that was sent to me on June 2, 2019. The invoice states that my balance of $1,871.20 is due within 30 days of the invoice date, but I was told by a member of your staff that I could pay $935.60 by June 30, 2019 and pay the remaining balance by July 30, 2019."

This block is required.

5. *

What is the Invoice # that this Billing Support Request pertains to?

This block is required.

6. *

According to the data shown, which class code is most common?

This block is required.

7. *

What is the ID # of the youngest patient listed here?

This block is required.

8. *

Which Class Code corresponds to Invoice #84920157?

This block is required.

9. *

What are the Invoice #s for the 3 most recent visits, in order from most to least recent?

This block is required.

10. *

What is the last name of the patient with the lowest Invoice Total?

This block is required.

11. *

Based on this table, enter the missing code from Column 2.

This block is required.

12. *

What is the total amount for Invoice #90152990?

This block is required.

13. *

Which Company has the same class code as VisionWorx?

This block is required.

14. *

What was the total for the invoice issued on 5/1/2019?

This block is required.

15. *

List the individual Invoice Totals for all invoices generated in the month of June 2019.

This block is required.

16. *

What was the combined total for all invoices generated in the month of June 2019?

This block is required.

17. *

Not including Quantity, how many differences are there between these two tables?

This block is required.

18. *

Assuming the table on the left represents details for Order 1 and the table on the right represents Order 2, what is the difference in Total Quantity between the two orders?

This block is required.

19. *

The remaining questions will focus on your proficiency with Microsoft Excel.

In Microsoft Excel, if you need a quick method to add together all numbers in a column, the best way to do this would be to click in the cell below the numbers and then:

Click Subtotals on the Data menu, then press ENTER

Select CTRL and =

View sum in the formula bar

Click the AutoSum button on the Standard toolbar, then press ENTER

This block is required.

20. *

Is the following formula valid?

=((A2+B5)*21

This block is required.

21. *Which of the following features cannot be found in the Data ribbon in Microsoft Excel?

What-If Analysis

PivotTable

Data Validation

Text to Columns

This block is required.

22. *If you see "#####" appear in a cell, what does this indicate?

This block is required.

23. *In Microsoft Excel, if you want to paste a formula result - but not the underlying formula - to another cell, you should copy the cell with the formula, then place the insertion point in the cell you want to copy to, then...

Click the Paste button on the Standard toolbar

Select CTRL and V

Click the arrow on the Paste button on the Standard toolbar, then click Formulas

Click the arrow on the Paste button on the Standard toolbar, then click Values

This block is required.

24. *Which of the following features in Microsoft Excel allows you to select/highlight all cells that are formulas?

Find

Replace

Go To

Go To Special

This block is required.

25. *

In Microsoft Excel, how can you change the column width to fit the contents?

Press ALT and single-click anywhere in the column

Press CTRL and double-click anywhere in the column

Single-click the boundary to the left of the column heading

Double-click the boundary to the right of the column heading

This block is required.

26. *Which tab of the ribbon should you go to for removing gridlines on a worksheet?

Formulas

View

Review

Developer

This block is required.

27. *If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?

This block is required.

28. *

Company X is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2 that can be copied down to cell C3 through C5 to generate the results shown below?

=IF(B2>=E2,"Accept","Reject")

=IF(B2>=$E2,"Accept","Reject")

=IF(B2>=E$2,"Accept","Reject")

=IF(B2>=$E$2,"Accept","Reject")

This block is required.

29. *Suppose a company expected its revenue to be $180,000 for 2014-2018. What formula should be entered in cell E6 so it displays revenue in 2016 if it was above budget, otherwise it'll show 0?

=IF(E2<$B$6,E2,0)

=IF(E2<$B$6,0,E2)

=IF(E2>$B$6,E2,0)

=IF(E2>$B$6,0,E2)

This block is required.

31. *Which are you more comfortable with?

Accounts Payable

Accounts Receivable

Both

This block is required.

32. *

Please complete the following typing assessment and upload a screenshot of your results once complete: https://10fastfingers.com/advanced-typing-test/english

This block is required.

33. *Please complete the following numerical typing test and upload a screenshot of your results once complete: https://10fastfingers.com/text/12345-Numbers-Test

This block is required.

34. *Please upload a copy of your resume.

This block is required.

35.

Thank you for taking the time to complete our Accuracy Assessment! Once your assessment is received, it will be sent to our hiring manager(s) for review and you will be contacted once a decision has been made regarding the status of your application.

Is there anything else you'd like to share with us prior to submitting your assessment?

This block is required.