wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Quickbooks Certification Review

Total questions: 105

Worksheet time: 48mins

Name
Class
Date
1.

Where would you go to find more information about QuickBooks products and services?

a)

Intuit.com

b)

Google.com

c)

QuickBooks.com/tellmeallaboutquickbooks

d)

Youtube.com

2.

Match the term to the definition:


Expenses

a)

Proceeds generated from the sale of your product or business.

b)

Everything a business owns.

c)

Money owed to others.

d)

Everything the business has in its possession.

e)

Money spent to run the day to day business operations.

3.

The day that you start tracking your day to day business in QuickBooks is known as your "Start Date".

a)

True

b)

False

4.

With QuickBooks Online Payroll, customers have to pay extra to offer employees direct deposit.

a)

True

b)

False

5.

Which is quidbook features

a)

main menu

b)

banking

c)

company

6.

Which is part of menu bar

a)

Telephone

b)

File

c)

Icon

7.

Which of the following elements on an invoice can you NOT customize?

a)

Which fields appear on the screen when someone creates an invoice

b)

Adding your company’s unique logo

c)

The amount of information (number of characters you can type in each field)

d)

Which fields appear on the printed invoice

8.

What is the purpose of an audit-trail report?

a)

To prepare the books for an accounting firm’s audit

b)

Track any changes and deletions, as well as track which user makes the change or deletion

c)

Track attempts to a restricted area

d)

To help you perform a year-end audit

9.

Which of the following transactions cannot be memorized?

a)

Invoices

b)

Bills

c)

Checks

d)

Bill Payment

10.

How do you identify the version and release of the QuickBooks you are using?

a)

Click the File menu and select Version Information

b)

Click the Help menu and select About QuickBooks

c)

Press the F2 key

d)

Press the F1 key

11.

Which report shows how much you owe for sales taxes?

a)

A/P Aging Summary

b)

Sales Tax Liability

c)

1099 Detail

d)

Sales Tax Revenue Summary

12.

How do you hide all subaccounts on a report?

a)

Click the Customize Report button. Then click Hide Subaccounts and click OK

b)

Click the Collapse button

c)

Click the Hide Detail button

d)

Click the Hide Subaccounts button

13.

The bank notified you that a customer’s check you deposited has bounced (the customer didn’t have sufficient funds to over the check). What should you NOT do?

a)

Delete the customer’s payment from the deposit

b)

Call the customer and ask them to send another check

c)

Charge your customer a bounced check fee

d)

Click Record Bounces Check in the same Receive Payment window you used to receive the customer’s original payment

14.

What two steps do you follow to track Accounts Payable in QuickBooks?

a)

Enter Bills, Write Checks

b)

Enter Bills, Pay Bills

c)

File Bills, Pay Bills

d)

Pay Bills, Print Checks

15.

How do you display a group of reports?

a)

Click the Process Multiple Reports icon on the Home page

b)

Click the Reports menu and then select Process Multiple Reports

c)

Click the File menu and select Print Reports > Multiple Reports

d)

Click the Report Center icon. Then click the Process Multiple Reports button.

16.

What is the end result of the Payroll Setup Interview?

a)

QB advises if you need to create paychecks or regular checks for 1099 subcontractors

b)

Your first payroll is completed

c)

QB has an accurate record of employees, earning, deductions, and payroll history, and you are ready to create your first paycheck

d)

A payroll service option is selected and you are ready to set up employees and taxes

17.

Your new employee earns an annual salary of $55,000. How do you enter this into QB?

a)

Divide $55,000 by the number of pay periods (example: monthly) and manually enter this amount in the Payroll Info tab

b)

Divide $55,000 by the number of hours in a work week and enter that amount in the Payroll Info tab (so you can enter hours for the employee)

c)

Divide $55,000 by the number of pay periods (example: monthly) and manually enter this amount on each paycheck

d)

In the New Employees window, enter a salary of $55,000 in the Payroll Info window

18.

Which of the following editions of QuickBooks support multiple users?

a)

Enterprise Solutions only

b)

QuickBooks does not support multiple users

c)

Premium and higher

d)

All versions support multiple users

19.

Which tool do you use to move your logo onto a form?

a)

QuickBooks Print Engine Editor

b)

Financial Statement Designer

c)

Customer Form Designer

d)

Layout Designer

20.

Which of the following CANNOT be entered during the setup of a new company (Express Start or Advanced/Detailed Setup) file?

a)

Trial balance opening balances

b)

Company name and address

c)

Checking account statement balance

d)

Chart of Accounts

21.

You accidentally entered the same customer twice in the Customer Center (with a slightly different spelling). How do you merge these two entries?

a)

Edit the unwanted entry. Click the Merge to button. Then select the appropriate name to merge into. Then click OK

b)

Click the Company menu and select Merge Names. Then select the two names to merge from the appropriate lists. Then click Merge

c)

Merging list entries is not possible. You can only delete unwanted entries

d)

Edit the unwanted entry. Change the name to match the name you want to merge into. Click OK. Then click YES when prompted to merge the names

22.

You need to deduct money from an employee’s paycheck for a garnishment (ie: child support). How do you do this?

a)

On the paycheck, reduce the gross wages by the amount you’ve been asked to deduct

b)

Setup and use the Deduction Type Payroll item, and be sure the item is linked to the appropriate liability account

c)

On the paycheck, click the expense tab and enter the amount of child support as a negative

d)

On the paycheck, click the Expenses tab and enter the amount of child support as a positive.

23.

Which is NOT a good reason to enter a general journal entry?

a)

For accountants to correct errors

b)

For year-end adjustments

c)

To enter depreciation

d)

To avoid using the build-in forms (ie: checks and invoices)

24.

Which of the following could explain why a Profit & Loss shows a profit, but the business owner doesn’t have any money in the bank?

a)

The Profit & Loss was run on the Item Profitability instead of the Job Profitability basis

b)

The Profit & Loss was run on the Fund basis instead of the Class basis

c)

The Profit & Loss was run on the Accrual Basis instead of the Cash Basis

d)

This is not possible. If there is a profit, there will be money in the bank

25.

Your company sells unique items to every customer (they never sell the same service or product twice). What item(s) should you set up in QuickBooks?

a)

Do not use items when invoicing the customer. Instead, just type the description and price in the notes area

b)

Click the Remove After Use button in the New Item window

c)

Click the One-Time Use button in the New Item window

d)

Set up a generic item and edit the description price each time

26.

You finished entering all the transactions for last year and just sent the file to the tax preparer. How do you ensure that no one deletes, edits, or adds a transaction to last year?

a)

Set a Closing Date and password in the Accounting Preferences or from the Company menu

b)

Click the Close Financial Year icon on the home page and enter the end of your fiscal year

c)

Complete the Close the Books wizard

d)

In the Company Information window, select the First month in your fiscal year

27.

How do you pay Payroll Liabilities in QB?

a)

Select the payments you want to make from the Pay Taxes & Other Liabilities list in the Payroll Center. Then click View/Pay

b)

Drag and drop liabilities to the payment calendars

c)

Click Write Checks (or use the check register), enter the amount, and then select Payroll Liabilities as the account in the Expenses tab

d)

Click Write Checks (or use the check register), enter the amount,

and then select Payroll Items you are paying in the Items tab

28.

What is the Undeposited Funds account in QB?

a)

The account QB uses to group customer payments together, before you record a deposit

b)

An account used to record checks you wrote that have not been deposited by your vendors yet

c)

An account used to remove “bounced checks” from the checking account

d)

An account used to record unpaid invoices

29.

You sent a QB report to Excel and made some changes. How do you import the changes back to QB?

a)

Open the original report and click Export. Click the Advanced tab and select Import last exported report

b)

Use the Import from Excel wizard in QuickBooks

c)

From the menu, select Reports > “original report name” > Import from Excel

d)

You can’t import changes in Excel back to QuickBooks

30.

How do you make a column wider on a report?

a)

Click the Format menu and select Column > Width. Then enter an appropriate amount and click OK

b)

Click on the three dots to the right of the column and drag it to the right

c)

Click the Customize Report button. Then click the Display tab. Then enter an appropriate column width next to the column name

d)

Right-click on the column and select Column Width. Then enter an appropriate amount and click OK

31.

Once you’ve completed the setup of a new company file, how do you open a window where you can change company information such as business name, address, or phone number

a)

Select Edit: Preferences from the menu

b)

Select Company: My Company from the menu

c)

Select File: Open Company from the menu

d)

Select File: Easy Step Interview from the menu

32.

Which of the following statements is true regarding single-user and multi-user mode?

a)

Only the Administrator is allowed in the file while it’s in single-user mode

b)

To use QuickBooks in multi-user mode, each user must have the same version of QuickBooks on the computer to access the same company file

c)

You can have a maximum of 3 users at the same time in multi-user mode

d)

To use QuickBooks in multi-user mode, the Administrator and other users can have different versions of QuickBooks.

33.

The company file you are working on is a mess. You decide to start a new company file. To save time, you want to keep all the lists and preferences and just deleted the transactions. How do you do this?

a)

Click the Edit menu and then select Delete All Transactions

b)

Create a new company and select Copy Settings from Another Company in the Easy Step Interview

c)

Click the File menu and select Utilities > Condense Data from the menu. Then choose the All Transactions option

d)

You can’t do that in QB

34.

Your company just hired a subcontractor to work 40 hrs per week on a job. Which list should you add this person to?

a)

Employees

b)

Other Names

c)

Vendors

d)

Subcontractors/1099

35.

What can you do in the Report Center?

a)

Delete reports from QuickBooks

b)

Add reports to QuickBooks

c)

Start the Client Data Review

d)

Run most reports in QuickBooks

36.

There are 2 primary financial statements that summarize the Chart of Accounts. Which of the following is one of these reports?

a)

Balance Sheet

b)

Chart of Accounts Summary

c)

Depreciation Statement

d)

Cash Flow Forecast

37.

What is the quickest way in QuickBooks to find an invoice from six months ago?

a)

Click Help and search for the invoice by date

b)

Click Help and search for the invoice by number

c)

Open an invoice and click the Find button

d)

Click the Previous button until you find the invoice

38.

You have to set up an item for “Shipping”. What item type should you use?

a)

Non-Inventory Part

b)

Inventory Part

c)

Service

d)

Other Charge

39.

Which of the following CANNOT be customized in Quick Books?

a)

Invoice

b)

Check

c)

Purchase Order

d)

All of the Above

40.

When you run a Profit & Loss on the accrual basis, what does QuickBooks include as income?

a)

All sales entered with accrual journal entries

b)

Only sales for which you have been paid

c)

All sales, whether or not you’ve received customer payments

d)

All sales except statement charges

41.

When you sell an item, how does it affect the Profit & Loss Report?

a)

The value of the sale flows to the income account you selected when you set up the item

b)

When you set up an item, you select Balance Sheet or Profit & Loss from the Assign drop-down list

c)

When you set up a non-inventory items, QuickBooks assigns the current on-hand quantity to the Profit & Loss

d)

Items does not affect the Financial Statements

42.

A list entry may be deleted ONLY when:

a)

The entry has not been used in the current year

b)

List entries can never be deleted

c)

It has no balance, it has not been used, and is not linked to anything that has been used

d)

You enter a valid security password

43.

Your company had to return some goods to a vendor. How do you record the vendor credit in QB?

a)

In the Pay Bills window, select Refunds & Credits

b)

Click Refunds & Credits on the home page

c)

Enter a Journal Entry

d)

Click the Enter Bills and then click Credit on the top of the bill

44.

Which of the following could explain why a profit and loss shows a profit, but the business owner doesn't have any money in the bank?

a)

This is the difference between fund and class reporting.

b)

This is the difference between accounts receivable and accounts payable reporting.

c)

This is the difference between item profitability reporting and job profitability reporting.

d)

This is the difference between cash and accrual reporting.

45.

Which report shows how much you owe for sales tax?

a)

Sales Tax Revenue Summary

b)

1099 Detail

c)

Sales Tax Liability

d)

AP Aging

46.

Where can you see a thumbnail sample of each report in QuickBooks along with a description of what the report tells you?

a)

Report men

b)

View menu

c)

Report center

d)

Document center

47.

What can you do in the report center?

a)

Start the client data review.

b)

Add reports to QuickBooks

c)

Run most reports in QuickBooks

d)

Delete reports in QuickBooks Multiple Reports

48.

How do you display a group of reports?

a)

Click the reports center icon then click the process multiple reports button.

b)

Click the reports menu then select process multiple reports.

c)

Click the file menu then click multiple reports.

d)

Click the process multiple reports icon on the home page.

49.

How do you customize a report, i.e. change the information QuickBooks displays, change the title etc?

a)

Click the customize report button on the report.

b)

Double click on the report element you want to change.

c)

Click the modify report button on the report.

d)

Right click on the report element you want to change.

50.

How do you change text in the header/footer of a report?

a)

You can't change the header/footer in QuickBooks. You would have to do this in Excel.

b)

Double click on the header or footer in the report you want to change.

c)

Click the customize report button on the report and then change the header footer tab.

d)

Right click on the header footer in the report you want to change.

51.

Suppose you always want all reports to show a specific size and color, how do you set the standard or preference in QuickBooks so you don't have to customize each report?

a)

You must customize each report individually.

b)

Click the Reports menu and select global report preferences.

c)

Click the Reports menu and select Memorize Reports, set preferences; you can only set report preferences for memorized reports.

d)

Click the edit menu and select preferences then click the reports and graphs group to set your report preferences.

52.

If you have a customized report that you use each month, which feature lets you run the report with updated data each month?

a)

Update Report

b)

Memorize Report

c)

Automate Report

d)

Customize Report

53.

How do you make a column on a report wider?

a)

Right click on the column and select column width, enter the appropriate amount and click OK.

b)

Click the Format menu, select column width and enter the appropriate amount and click OK.

c)

Click the three dots to the right of the column and drag it to the right.

d)

Click the modify report button, click the display tab, and enter the appropriate column width.

54.

Which of the following is TRUE regarding General Journal entries?

a)

General Journal entries require a good understanding of debits and credits and should not be used by non-accountants.

b)

Enter a General Journal entry when you are not sure which form to use.

c)

General Journal entries should not be used for year-end adjustments.

d)

General Journal entries should not be used to enter depreciation.

55.

Which is a reason to NOT enter a general journal entry?

a)

To enter transactions in another way instead of using built in forms.

b)

For accountants to make entries

c)

For year end adjustments.

d)

Enter depreciation

56.

You been asked to move the name of the customer and the customer center from the top of the list to the bottom of the list. How do you do this without renaming the customer?

a)

Click to the right of the name then drag the name up or down the list

b)

Right-click on the name then select sort by selection.

c)

You can't move list entries to different location on the list

d)

Click on the diamond to the left of the name and then drag the name up or down to the desired location

57.

How would you track customer birth dates in QuickBooks?

a)

Use the built in Excel link to track the information.

b)

Add a custom field to the customer list.

c)

Use track additional data feature in the customer center.

d)

You cannot track customer's birthdays.

58.

How do you move list entries to a different location on the list? For example, Customers.

a)

Click to the right of the name and drag the name up or down on the list.

b)

Right click on the name then select sort by selection.

c)

You can't use move list entries to different locations on the list.

d)

Click on the diamond to the left of the name and then drag the name up or down the list.

59.

Which of the following is NOT true regarding merging entries?

a)

Merging effectively combines names on a list.

b)

QuickBooks allows you to merge an Expense account with an Income account.

c)

Merging entries effects past transaction

d)

You can only merge names of the same type.

60.

Your company just hired a subcontractor to work 40 hours per week. Which list should you add this person to?

a)

Employees

b)

Vendors

c)

Subcontractors

d)

Subcontractors

61.

List entries may be deleted only when:

a)

There is no balance, it has not been uses and is not linked to anything that has been used.

b)

You entered a valid security password.

c)

List entries can never be deleted.

d)

The entry has not been used in the current year.

62.

Which of the following statement is TRUE regarding items?

a)

Items on a transaction do not affect the financial statements.

b)

When you set up a non-inventory item, QuickBooks assigns the current on-hand quantity to the balance sheet.

c)

When you purchase or sell an item, the value of the purchase or sales flows to the account and therefore the financial statement you selected when you set up the item.

d)

You must use items on checks.

63.

How do you make an item on the item list inactive?

a)

Open the item list, click to select appropriate item, then click the activities button and select inactivate item.

b)

Open the item list, click to select the appropriate item, then click the bottom left button and select make item inactive.

c)

Open the item list, click the select inactive items button, then select the appropriate items then click ok.

d)

Click the items list and select make entries inactive then select the appropriate list entry then click ok.

64.

Which of the following statements is TRUE regarding Undeposited Funds?

a)

It is an item type usually associated NSF fees.

b)

It is an account used to record unpaid invoices

c)

It is an item type usually associated with bad debt.

d)

It is an account used to record payments before you make a deposit.

65.

Which of the following CAN be memorized in QuickBooks?

a)

Check

b)

Bill Payment

c)

Paycheck

d)

All of the above

66.

Which of the following transactions CANNOT be memorized?

a)

Checks

b)

Automatic bank withdrawal

c)

Bill payment

d)

Credit card charge

67.

Which of the following transactions CANNOT be memorized?

a)

Checks

b)

Invoices

c)

Bill payment

d)

Bills Banking

68.

How do you record debit card transactions in QuickBooks?

a)

You don't set up a debit card at all.

b)

Use the write checks window, enter the check and write debit in the check number field.

c)

Open the check register and select debit card.

d)

Create sub accounts.

69.

How do you record a debit card transaction in QuickBooks?

a)

Setup a credit card type account and name it debit card.

b)

Use the write check window for the check register but type debit in the check number field.

c)

Open the check register and select debit card from the drop down list.

d)

Create a sub-account of your checking account and name it debit card.

70.

Which of the following statements is TRUE regarding how you record a debit card transaction in QuickBooks?

a)

Set up a credit card type account and name it debit card then use the Enter Credit Card Charges window.

b)

Use the Write Checks window or Check Register and type debit in the check number field.

c)

Set up a new window and choose Debit Card as the type then use the Enter Debit Card Charges window

d)

Use the cash payment window.

71.

Which of the following is a possible reason for a bank reconciliation discrepancy?

a)

You did not record checks in QuickBooks that are dated after the bank statement date.

b)

The beginning balance calculated by QuickBooks does not match last months ending balance.

c)

The QuickBooks Balance will never match the banks' balance.

d)

The bank reconciliation is on a cash basis instead of the correct accrual basis.

72.

When can you delete a check from QuickBooks without voiding it?

a)

It is not possible to delete a check from QuickBooks.

b)

You printed or wrote a check but it will never be cashed. Example, the check was destroyed or lost.

c)

You printed or wrote a check but changed your mind and decided to use a credit card instead.

d)

You entered a check in QuickBooks but haven't printed it yet. You realized the purchase was actually made using a credit card. The check was never really used.

HIDE ANSWER

73.

When should you VOID instead of delete a check?

a)

You mistakenly printed checks on plain paper.

b)

You used the check number but it will never be cashed.

c)

You entered the same check number twice in QuickBooks.

d)

You accidently entered a handwritten check in QuickBooks but the purchase is actually made using a credit card.

74.

When you start a company or are hired as a bookkeeper, it is important to know which edition of QuickBooks you are using. What are the major QuickBooks editions?

a)

QuickBooks Online, QuickBooks Pro, QuickBooks Premier, QuickBooks Enterprise Solutions

b)

QuickBooks Online, QuickBooks Basic, QuickBooks Pro

c)

QuickBooks Basic, QuickBooks Pro

d)

QuickBooks Premier, QuickBooks Enterprise Solutions

75.

If you have a customized report that you use each month, which feature lets you run the report with updated data each month?

a)

Click on run aotomatically

b)

Customized Report

c)

Click on update data for the report

d)

Memorized Report

76.

Which is not a section of the balance sheet?

a)

Assets

b)

Liabilities

c)

Expenses

d)

Equity

77.

Once the easy step interview is completed or you have completed the sign of new company file, how do you change company information such as business name, address, or phone number?

a)

Select customer information from the menu

b)

Delete the company and re-enter it

c)

You can't change it once you've gone through the interview

d)

Select company information from the menu

78.

There are two primary financial statements that summarize the chart of accounts. Which of the following is the two reports?

a)

Loss and Profit statement and balance sheet

b)

Journal statement and income statement

c)

Equity statement and balance sheet

d)

balance sheet and income statement

79.

What two steps do you follow to track accounts payable in Quickbooks?

a)

Enter bills, pay bills

b)

Reports, accounts payable

c)

Reports, accounts with balances

d)

Enter accounts payable, enter bills

80.

What can you do in the report center?

a)

Enter payments

b)

Set up customers

c)

Run most reports in QuickBooks

d)

Run only accounts with balances

81.

What transaction in Quickbooks should you use if your customer pays you when you provide the goods or services?

a)

Sales Invoice

b)

Sales Receipt

c)

Sales Estimate

d)

Sales Ticket

82.

Which payroll service allows you to print state tax forms?

a)

Basic payroll

b)

Standard payroll

c)

Enhanced payroll

d)

Advanced payroll

83.

What is the end result of payroll setup interview?

a)

A payroll service option has been selected and you are ready to setup employees and taxes.

b)

Your first payroll is completed.

c)

QuickBooks has an accurate record of employee's earnings and deductions and payroll history and you are ready to create your first paycheck.

d)

QuickBooks advises that you need to create checks or regular checks from 1099.

84.

What is the end result of a payroll setup interview?

a)

A payroll service option is selected.

b)

Your fist payroll is completed.

c)

QuickBooks has an accurate record of employees, earning deductions and payroll history and you are ready to create the first paycheck

d)

Your payroll service subscription is selected and activated.

85.

Your new employee earned an annual salary of $40,000. How do you enter this into QuickBooks?

a)

Divide 40,000 by the number of pay periods and manually enter this amount on each paycheck.

b)

Divide 40,000 by the number of pay periods, example monthly, and enter that amount in the payroll info window.

c)

Enter 40,000 in the payroll info window.

d)

Divide 40,000 by the number of hours in a work year and enter that amount in the payroll info window.

86.

When you set up a new employee, how do you add a payroll deduction such as medical insurance?

a)

In the new employee window, click the change tab drop down list and select employment info, then add the medical insurance payroll item below the employment detail section.

b)

In the new employee window, click the change tab drop down list and select payroll and compensation info and then add the medical insurance payroll item below the additions deductions and company contributions.

c)

In the new employee window, click the change tab drop down list and select personal info and then add the medical information in the personal deductions.

d)

In the new employee window, click the change tab drop down list and select payroll and compensation information then click the taxes button and the medical insurance payroll below the other taxes and deductions.

87.

What steps must you complete to use the payroll center to pay payroll liabilities?

a)

Enter General Journal entries to record amounts due.

b)

Drag and drop liabilities to the payment calendar.

c)

Set deposit frequencies.

d)

Run payroll forms such as the 9-41

88.

How do you pay, Payroll Liabilities in QuickBooks?

a)

Click write check or use the check register, enter the amount and select payroll liability as the account in the expense tab.

b)

Click write check or use the check register, enter the amount and select the payroll items you are paying in the item tab.

c)

Select the payment you want to make form the pay scheduled liability select view pay.

d)

Drag and drop liabilities to the payment calendar.

89.

For each functional area of QuickBooks Pro and Premier, i.e. Sales Accounts, Accounts Receivable, Purchases, what levels of access can you grant to users?

a)

You can prohibit access, grant full access or grant selective access; these levels apply to all transactions within that area.

b)

You can prohibit access, grant full access or grant selective access; these levels apply to specific transactions in that area.

c)

You can prohibit access or grant full access; these levels apply to specific transactions within that area.

d)

You can prohibit access or grant full access; these levels apply to all transactions within that area.

90.

Assume that QuickBooks is now in Single User Mode. What does this mean?

a)

Multiple users can access the company file, however, their activities are restricted

b)

Only one user can work with each functional area.

c)

Only one user can access the company file.

d)

Multiple users can access the company file, however, only one transaction can be saved at a time.

91.

Which of the following statement is TRUE regarding single user and multi user mode?

a)

To use QuickBooks in multi user mode the administrator and other users can have different versions of QuickBooks.

b)

Only the administrator is allowed in the file while it is in single user mode.

c)

To use QuickBooks in multi user mode each user must have the same version of QuickBooks on their computer to have access.

d)

You can have a minimum of three users at a time in multiuser mode.

92.

How do you add or delete columns on a report?

a)

You cannot delete columns on a report.

b)

Click the reports menu and select customize columns.

c)

Click the Customize report button and on the display tab check (add ) or (uncheck) remove columns.

d)

Click the Edit menu and select Preferences then click the Reports and Graphs group to make changes to columns.

93.

How do you hide all subaccounts on a report?

a)

Click the hide detail button.

b)

Click the hide subaccounts button.

c)

Click the modify reports button then the hide subaccounts then click ok.

d)

Click the collapse button.

94.

Why would you hide or collapse subaccounts on a report?

a)

You cannot hide sub accounts on a report

b)

To send the report to excel it must be collapsed

c)

Can only email a report that is collapsed

d)

To temporarily hide unnecessary detail and hide parent accounts

95.

How can you open a QuickBooks report in Microsoft Excel?

a)

You can't open a QuickBooks report in Excel.

b)

Click the Excel button on the top of any QuickBooks report.

c)

Use the import from QuickBooks Wizard in Microsoft Excel.

d)

Select the view report in a database in the report center.

96.

You sent a QuickBooks report to Excel and made some changes. How do you import the changes in Excel back to QuickBooks?

a)

Use the import from excel wizard in QuickBooks.

b)

You can't import changes in Excel back to QuickBooks.

c)

Open the original report and click export; click the advance tab and select import list exported report

d)

From the menu select reports, original report, name, import from excel.

97.

What is the purpose of an Audit Trail report?

a)

Track attempts to access a restricted area.

b)

Track any changes and deletions to transactions and track which user makes the change or the deletion.

c)

To prepare the books for an accounting item or forms audit.

d)

To help you perform a year end audit.

98.

How do you use a different form template when creating a new transaction? (i.e. Invoice)

a)

Select Edit Preferences from the menu then click the customization icon and select the appropriate form template.

b)

Double click on the form title bar and select the appropriate form template.

c)

Select Edit, Apply custom template from the menu

d)

Open the form, click the templates drop down list and select the appropriate form.

99.

Which of the form templates cannot be customized in QuickBooks?

a)

Checks

b)

Invoice

c)

Purchase Order

d)

All of the above

100.

Which of the form templates cannot be customized in QuickBooks?

a)

Checks

b)

Invoice

c)

Purchase Order

d)

All of the above

101.

How do you use a different forms template when creating a new transaction? Ex. invoice

a)

Click on form template, Design the form you want.

b)

Open the form, click the templates drop down list and select the appropriate form.

c)

Click on design forms template and click on the one you want.

d)

You can't change the templates of forms

102.

How would you track customer birth dates in Quickbooks?

a)

Add a custom field to the customer list.

b)

Select track birthday in customer information window.

c)

Click on track birthdays in preferences for customers.

d)

This is not an option in Quickbooks.

103.

If you have a customized report that you use each month, which feature lets you run the report with updated data each month?

a)

Click on run aotomatically

b)

Customized Report

c)

Click on update data for the report

d)

Memorized Report

104.

Which is not an option for when List entries may be deleted?

a)

It has no balance

b)

It is linked to an account, but isn't used

c)

it isn't being used

d)

it isn't linked to anything that has been used

105.

Which is not a section of the balance sheet?

a)

Assets

b)

Liabilities

c)

Expenses

d)

Equity