Accounting 1 - Unit 1

Which type of accounting focuses on reporting information to executives and internal users of information who are involved in making day-to-day operating decisions such as purchasing and hiring?

• computerized

• financial

• management

• manual

Which career involves providing financial advice to help individuals and business organizations, and requires education and experience as well as passing a uniform exam?

• bookkeeper

• accounting clerk

• public accountant

• certified public accountant

The standards, conventions, and rules that accountants follow to prepare financial reports are known as:

• generally accepted accounting principles

• accounting and audit procedures

• management accounting

• executive accounting

In the formula =MAX(G4:G19), the cell references are an example of which term?

• label

• value

• range

• numeric label

Which cell addresses contain numeric labels?

• A3:F3

• A5:A8

• B5:B8

• E5:F8

Samantha needs to total the values in cells A1 to A10. Which should she enter to find the answer?

• SUM(A1+A10)

• =SUM(A1:A10)

• =TOTAL(A1:A10)

• =TOTAL(A1+A10)

What is the common term for a retirement savings plan sponsored by employers that will allow workers to save and invest from their paychecks before taxes?

• 401(k) savings plan

• certificate of deposit

• 529 savings plan

• stock fund

Which formula is used to calculate the 6% tax of the SUBTOT?

• =3,192 X 6%

• =F11*.06

• =6%/F11

• =F11*F12

Data can be entered into a cell as a numeric label (used to identify or name information) by first entering which character?

• : (colon)

• • + (plus sign)

• ' (apostrophe)

• $ (dollar sign)

Tameka wants to change the orientation of her spreadsheet from landscape to portrait. On which tab of the Excel ribbon will this command be found?

• Formulas Page

• Insert Page

• Page Layout

• Review