Accounting One Test One

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