WorksheetsQuickBooks 61 - 70
Total questions: 10
Worksheet time: 5mins
How do you add or delete columns on a report?
You cannot delete columns on a report.
Click the reports menu and select customize columns.
Click the Customize report button and on the display tab check (add ) or (uncheck) remove columns.
Click the Edit menu and select Preferences then click the Reports and Graphs group to make changes to columns.
How do you hide all subaccounts on a report?
Click the hide detail button.
Click the hide subaccounts button.
Click the modify reports button then the hide subaccounts then click ok.
Click the collapse button.
Why would you hide or collapse subaccounts on a report?
You cannot hide sub accounts on a report
To send the report to excel it must be collapsed
Can only email a report that is collapsed
To temporarily hide unnecessary detail and hide parent accounts
How can you open a QuickBooks report in Microsoft Excel?
You can't open a QuickBooks report in Excel.
Click the Excel button on the top of any QuickBooks report.
Use the import from QuickBooks Wizard in Microsoft Excel.
Select the view report in a database in the report center.
You sent a QuickBooks report to Excel and made some changes. How do you import the changes in Excel back to QuickBooks?
Use the import from excel wizard in QuickBooks.
You can't import changes in Excel back to QuickBooks.
Open the original report and click export; click the advance tab and select import list exported report
From the menu select reports, original report, name, import from excel.
What is the purpose of an Audit Trail report?
Track attempts to access a restricted area.
Track any changes and deletions to transactions and track which user makes the change or the deletion.
To prepare the books for an accounting item or forms audit.
To help you perform a year end audit.
How do you use a different form template when creating a new transaction? (i.e. Invoice)
Select Edit Preferences from the menu then click the customization icon and select the appropriate form template.
Double click on the form title bar and select the appropriate form template.
Select Edit, Apply custom template from the menu
Open the form, click the templates drop down list and select the appropriate form.
Which of the form templates cannot be customized in QuickBooks?
Checks
Invoice
Purchase Order
All of the above
Which accounts are affected when you enter Time in QuickBooks?
None. Because time sheets are non-posting entries.
Payroll Expenses.
Employee payroll balances.
Accounts Receivable
Which list represents the payroll services you can add to QuickBooks?
Basic (calculates taxes for you); Enhanced (adds state and federal tax forms); Assisted (Intuit handles payroll taxes and forms); and Full Service (Intuit processes payroll completely).
You don't have to add a payroll service to QuickBooks.
Basic (calculates taxes and helps create state and federal tax forms) and Assisted (Intuit handles payroll taxes and forms).
Basic (calculates taxes and helps create state and federal tax forms) and Full Service (Intuit processes payroll completely).
