Accounting Assessment Test

ProCoder Inc. reported the following information on Dec 31st. If we ignore income tax, what should ProCoder report as comprehensive income as of Dec 31?

Here’s the balance sheet for SinkedIn Ltd as of December 31, 2022:

SinkedIn Ltd acquires a smaller company for $100,000 cash. The acquisition adds $60,000 in goodwill and increases the long-term investments by $40,000. 

Here’s the new balance sheet created after these changes:

Which of the following rows are erroneous rows in the balance sheet after the acquisition?

Review the following balance Sheet for Company Sinclair as of December 31, 2023 (in thousands of dollars)

Suppose that Company Sinclair has a tax rate of 30%. What will be the company's new equity balance if the company sells all its long-term investments at their book value, pays off all its short-term debt, and distributes the remaining cash as a dividend to shareholders?

Some friends live in adjacent apartments in a building in Central Perk, New York. We want to write a function to search the apartment number by name. Which of the following functions should we use?

We have two Excel files with organization data. One file has Organization ID and Organization Name fields, whereas the second file has Organization ID, Organization Name and Country fields. We wrote a query to retrieve the data from both files. Here’s a sample of the data retrieved:

We want to ensure Organization ID field is unique. Which of the following is the ideal solution that ensures Organization ID field is unique while retaining Country data?

A: Select the Organization ID and Country columns, and then click Keep Duplicates.
B: Select the Organization ID and Country columns, and then click Remove Duplicates.
C: Use Group BY function to group the rows by Organization ID. Specify output columns for Organization Name and Country using MAX operation.
D: Select Organization ID column and then click Remove Duplicates. Then specify output columns for Country using MAX operation.

Here’s a sample Excel data source:

Here’s the expected data format: 

Which of the following is the correct way to transform the data from the query editor to achieve the result?

A: Columns to Select: Student Only
B: Columns to Select: Student and Student ID
C: Columns to Select: Primary and Secondary
D: Command to Use: Pivot Column
E: Command to Use: Reverse Rows
F: Command to Use: Unpivot Columns

We are looking to find the contact number of the only blood donor with blood group O-. Which function should we use to look up the correct contact number? Here's the documentation for VLOOKUP: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match (FALSE)).

A: =VLOOKUP("O-", A1:E10, 3, TRUE)
B: =VLOOKUP("O-", A1:E10, 3, FALSE)
C: =VLOOKUP("O-", D1:D10, 4)
D: =VLOOKUP("O-", D1:D10, 3)
E: =VLOOKUP("O-", A1:E10, 4, TRUE)
F: =VLOOKUP("O-", A1:E10, 4, FALSE)
G: =VLOOKUP("Kane", A1:E10, 4)