NEW
Font size
WorksheetsAccounting One Test One
Total questions: 23
Worksheet time: 10mins
Data can be entered into a cell as a numeric label by first entering which character?
: Colon
+ Plus Sign
' apostrophe
$ dollar sign
What type of style in excel will show the $ and decimal of a number in all your cells.
Percent
Decimal
General
Accounting
In this type of BUSINESS OWNERSHIP structure the owner is protected from loss from the business.
Limited Liability
Corporation
Parternship
Sole proprietorship
if your business earns more money then they lose for the quarter then the company had a
Net Loss
Net Profit
Net equity
loss of capital
If you want to change the orientation of a spreadsheet from landscape to portrait then you must use this command.
Formulas page
Insert Page
Page Layout
Review
If I wanted to figure out how to calculate the state income based off of the gross pay (Cell) B12 I would use:
$6,000 * 5.25%
B12+5.25%
5.25%*B12
=B12*5.25%
When I am working on a spreadheet and the formula in the cell is =C12+C14/2+F5 and I wanted to copy that formula into the next row it would read:
=C13+C15/2+F6
C13+C15/2+F6
D12+D14/2 +F5
=C13*C15/2+H7
In an excel spreadsheet, what is the correct formula to multiply the value in B6 by the value in D12
(B6 X D12)
=B6*D12
=B6 X D12
(B6*D12)
If you want to add up the sum of multiple cells then the formula will look like:
Sum(B14:B67)
=B14+67
=Sum(B14:B67)
=SUMB:14:B67
In the formula=Max(G4:G19), the cell references are an example of which term?
Label
Value
Range
numeric label
If I have these numbers 4.5 3 5.6 7 and I want the formating to look the same what do I need to do?
General
Percentage
Increase Indent
Increase Decimal
If you want to add the value of multiple cells what would you do?
formula
function
label
?
What is the term for a financial reporting period of time beginnning on Jan 1 and ending Dec 31
Accounting Cycle
A Quarter
Budget Year
Calendar year
What carrer in accounting requires experience and classes in college plus passing a certtified exam?
Private Accounting
CAP Accounting
CPA Accounting
Public Accountant
What type of accounting is it when you are accounting for inventory and sales for the executive and management team?
Public Accounting
Managerial Accounting
Manual accounting
Audit Accounting
What is the name of the common retirement savings plan where your company will invest into the workers?
401K
CD
529
Limited Liability
The standards, conventions and rule that accountants follow to prpare financial reports are known as:
Generally accepted accounting principals
Accounting and Audit requirements
Managements accounting
Executive accounting
What type of ownership is there when the owner takes on all the risks and debts?
Sole Proprietorship
LLC
parternship
corporation
Which type of business has limited impact when a new owner is on board?
Parternship
Corporation
Sole Proprietorship
LLC
Which term in accounting refers to the owner keeping his personal money out of the business ?
Parternship
LLC
Capital concern
Business Entity
The accounting assumption that a business is expected to survive and operate indefinitely is called a:
Business entity
Going Concern
Capital concern
Charter Entity
What term refers to the owner having full responibility for company debts and obligations?
Limited Liability
Unlimited Liability
A small business owner should get a ________________ so they are covered from personal losses.
LLC
Unlimited Liability
Do nothing
