Audit
Wildcard
Tax
Excel
100

This document outlines the scope, objectives, responsibilities, and terms of the audit engagement before the work begins.

What is an engagement letter?

100

This amount of time is how long you have to pass all four CPA exams in California.

30 months

100

This K-1 item allows a taxpayer to potentially deduct the cost of qualifying business property immediately rather than depreciating it over its useful life.

What is a Section 179 deduction?

100

Pressing this key while editing a formula cycles a cell reference through relative, absolute, and mixed references.

What is F4?

200

The four audit assertions at Baker Tilly are?

What is Existence & Occurrence, Completeness, Valuation & Allocation, Presentation & Disclosure?

200

Top 10 Accounting Firms in the US are?

Deloitte, PWC, EY, KPMG, Grant Thorton, Baker Tilly, RSM, BDO, Forvis Mazars, Crowe

200

Name 3 Major Types of Trusts

Any 3 of the following:

Revocable Living Trust, Irrevocable Trust, Simple Trust, Complex Trust, Grantor Trust, Non-Grantor Trust, Testamentary Trust, Charitable Trusts, Special Needs Trust, Qualified Terminable Interest Property Trust

200

In Excel, this keyboard shortcut jumps directly to the cells referenced by the formula in the active cell.

What is Ctrl + [

300

Auditors use this sampling method to give larger-dollar transactions a higher chance of selection, making it especially effective for detecting material overstatements.

What is Monetary Unit Sampling?

300

This client is the Santa Rosa Office's biggest client in terms of total billables.

Caymus Vineyards
300

This federal law may protect an out-of-state corporation from a state’s net income tax when its in-state activities are limited to soliciting orders for tangible personal property.

What is Public Law 86-272?

300

This Excel tool works backward, changing one input value until a formula reaches a specified result.

What is Goal Seek?