, TESTBANK FOR Microsoft Excel for Accounting, 2nd Edition Weinstein
Important Notes
The file includes the complete test bank, organized chapter by chapter.
A sample of selected pages has been provided for preview.
All available appendices and Excel files (if included in the original resources) are
provided.
We continuously update our files to ensure you receive the latest and most accurate
editions.
New editions are added regularly – stay connected for updates!
⚠️Note on Answer Keys: If the answer key is not included within the chapter
questions, you will find the complete answers and solutions at the end of each
chapter.
✅ Why Buy From Us?
📚 Complete & organized chapter-by-chapter – no missing content, no guessing.
⚡ Instant digital delivery – get your file the moment you pay, no waiting.
📅 Always up to date – we track new editions so you always get the latest version.
💬 Friendly support – real humans ready to help, anytime you need us.
🔒 Safe & secure – thousands of satisfied students trust us every semester.
🛡️Our Guarantees
💰 Money-Back Guarantee: Not satisfied? We offer a full refund – no questions asked.
🔄 Wrong File? No Problem: Contact us and we will replace it immediately with the
correct version, free of charge.
⏰ 24/7 Support: We are always here – reach out anytime and expect a fast response.
,Test Bank
Chapter 1
The Accounting Equation and Recording Journal Entries
Name: ______________________________
Class: ______________________________
Date: ______________________________
Display the Accounting Equation
1. What represents amounts owed to entities outside of a business?
A. Assets
B. Liabilities
C. Receivables
D. Equity
2. Which of these describes the accounting equation?
A. Owner’s Equity = Profit - Liabilities
B. Profit = Revenue / Liabilities
C. Assets = Liabilities + Owner’s Equity
D. Revenue = Equity * Assets
Enter Data and Numbers in Excel
3. If the [Enter] key on the keyboard is used to complete this entry, where will the cursor move?
A. A2
B. B1
C. B2
D. It will remain in cell A1.
4. If the [Tab] key is used to complete this entry, where will the cursor move?
A. A2
B. B1
C. B2
D. It will remain in cell A1.
Microsoft Excel for Accounting, 2nd Edition Page 1 of 6
,Test Bank
5. If the Enter button on the formula bar is used to complete this entry, where will the cursor
move?
A. A2
B. B1
C. B2
D. It will remain in cell A1.
6. Which of these is considered a constant value?
A. 4,200
B. =5+81
C. =82*43
D. =9/9
7. The thick border surrounding an active cell is referred to as the _____.
A. Ribbon
B. entry
C. reference
D. highlight
8. Match each keyboard key with the impact it has on the location of the active cell.
Keyboard Keys Where the Active Cell Moves
A. (Enter) _____ 1. It will move to the next cell in the applicable
B. [Tab] _____ direction.
C. (←)(↓)(↑)(→) _____ 2. It will move down to the next cell.
D. (Esc) _____ 3. The entry is deleted, and the cell remains active.
4. It will move to the next cell to the right.
Record Journal Entries
9. Which statement is correct about debits?
A. A journal entry can include only one debit.
B. Debits are indented within a journal entry.
C. A debit increases the balance within a revenue account.
D. Debits appear above credits within a journal entry.
10. What is NOT a standard component of a journal entry?
A. Debited account
B. Credited amount
C. Accounting equation impact
D. Explanation
Microsoft Excel for Accounting, 2nd Edition Page 2 of 6
,Test Bank
11. Which cell contains a long text entry?
A. A1
B. A2
C. A3
D. A4
12. Which cell contains a truncated long text entry?
A. A1
B. A2
C. B1
D. B2
13. What feature can be used to adjust the width of column A to accommodate the text in cell A1?
A. Drag and drop
B. Right-dragging
C. AutoFit
D. Paste Options
14. What feature makes this menu appear?
Microsoft Excel for Accounting, 2nd Edition Page 3 of 6
,Test Bank
A. Drag and drop
B. Right-dragging
C. AutoFit
D. Paste Options
15. Using drag and drop results in the same outcome as using _____.
A. point and click
B. Bold and Italic
C. Undo and Redo
D. Cut and Paste
16. If the contents of cell A1 are copied and pasted into cell A3, what will appear in cell A3?
A. Liabilities
B. Nothing, the cell will be empty.
C. Liabilities Assets
D. Assets
17. Match each Excel action with its associated description.
Actions Descriptions
A. Drag and drop _____ 1. Adjust column width (or row height) to
B. Right-dragging _____ accommodate the widest (or tallest) entry.
C. AutoFit _____ 2. Drag the outside border of a cell to move the
D. Copy and Paste _____ contents to a new location.
3. Move the contents of a cell to a new location
without dragging the border.
4. Drag the outside border of a cell to a new
location to prompt a menu of options.
Use Undo and Redo in Excel
18. Which actions cannot be undone?
A. Right-dragging
B. Saving a file
C. Deleting text
D. Changing the page orientation
Microsoft Excel for Accounting, 2nd Edition Page 4 of 6
,Test Bank
19. Maci notices that the Redo button is shaded and can’t be clicked, but the Undo button is active.
Why?
A. She hasn’t yet issued the Undo command.
B. Excel hasn’t identified any errors for her to correct.
C. She must have printed the file.
D. You can only redo actions in the order you undid them.
20. Tyler chooses the “Typing ‘Assets’ in A1” option from the Undo menu. What happens?
A. The text “Assets” is removed from cell A1.
B. The text “Liabilities” is removed from cell A3.
C. The text in both cell A1 and cell A3 is removed.
D. Nothing; he has to undo actions from top to bottom in the list.
21. What action results in this ScreenTip being displayed?
A. Hovering the mouse pointer over the Enter button
B. Clicking the Enter button and dragging down
C. Clicking the Enter button
D. Right-clicking the Enter button
Print Worksheets
22. What action cannot be done in Backstage view?
A. Altering the print options
B. Viewing a preview of the printout
C. Navigating through the previewed worksheet pages
D. Editing the worksheet
23. What page orientation is this?
A. Portrait
B. Horizontal
C. Accounting
D. Landscape
Microsoft Excel for Accounting, 2nd Edition Page 5 of 6
,Test Bank
24. Match each Ribbon option with its associated description.
Ribbon Options Descriptions
A. Orientation _____ 1. Changes the page dimensions
B. Size _____ 2. Sets where one printed page ends and the next
C. Print Area _____ begins
D. Breaks _____ 3. Sets the page layout to either portrait or landscape
4. Allows you to identify a range of cells that will be
printed
25. Braedon completed his worksheet and is in a rush to print a portion of it, so he clicks the Quick
Print button. What happens next?
A. Backstage view is displayed so he can choose the print options.
B. The worksheet is sent to the printer with the current print options in effect.
C. A menu is displayed from within the available print options for this worksheet.
D. The print preview appears.
Microsoft Excel for Accounting, 2nd Edition Page 6 of 6
,Test Bank
Chapter 2
Financial Statements
Name: ______________________________
Class: ______________________________
Date: ______________________________
Create an Income Statement
1. What formula is conveyed in the income statement?
A. Assets = Liabilities + Equity
B. Net Income = Revenue - Expenses
C. Current Assets + Long-Term Assets = Total Assets
D. Beginning Equity + Net Income + Investments by Owner – Withdrawals = Ending Equity
2. What description is used when the final amount in the income statement is positive?
A. Total Expenses
B. Net Loss
C. Total Revenues
D. Net Income
Create a Statement of Owner’s Equity
3. What is NOT included in a statement of owner’s equity?
A. Net Loss
B. Total Liabilities
C. Beginning Equity
D. Investments by Owner
4. On what line of the statement of owner’s equity header do you enter the ending equity
balance?
A. First
B. Second
C. Third
D. The ending equity balance is not included in the header.
Microsoft Excel for Accounting, 2nd Edition Page 1 of 6
, Test Bank
Create a Balance Sheet
5. Which account would appear in the balance sheet?
A. Rent Expense
B. Jack Franklin, Withdrawals
C. Service Revenue
D. Salaries Payable
6. The balance sheet conveys financial information for the _____.
A. end of the final day of the period
B. entire period
C. time since the last asset purchase was made
D. time since the last liability payment was made
7. Place the financial statements below in the order in which they are completed.
Financial Statements Order in Which to Complete
A. Balance sheet _____ 1. First
B. Income statement _____ 2. Second
C. Statement of cash flows _____ 3. Third
D. Statement of owner’s equity _____ 4. Fourth
Alter Columns, Rows, and Text Alignment
8. What statement is correct about hidden rows?
A. They will print.
B. They are removed from the worksheet.
C. They are visible when modifying the worksheet.
D. They can be unhidden.
9. Alan wants to delete cells A3 and A4 while keeping all of column B as is. With the cells selected
as shown, which Delete Cells option does he choose?
A. Shift Cells Left
B. Shift Cells Up
C. Entire Row
D. Entire Column
Microsoft Excel for Accounting, 2nd Edition Page 2 of 6
Important Notes
The file includes the complete test bank, organized chapter by chapter.
A sample of selected pages has been provided for preview.
All available appendices and Excel files (if included in the original resources) are
provided.
We continuously update our files to ensure you receive the latest and most accurate
editions.
New editions are added regularly – stay connected for updates!
⚠️Note on Answer Keys: If the answer key is not included within the chapter
questions, you will find the complete answers and solutions at the end of each
chapter.
✅ Why Buy From Us?
📚 Complete & organized chapter-by-chapter – no missing content, no guessing.
⚡ Instant digital delivery – get your file the moment you pay, no waiting.
📅 Always up to date – we track new editions so you always get the latest version.
💬 Friendly support – real humans ready to help, anytime you need us.
🔒 Safe & secure – thousands of satisfied students trust us every semester.
🛡️Our Guarantees
💰 Money-Back Guarantee: Not satisfied? We offer a full refund – no questions asked.
🔄 Wrong File? No Problem: Contact us and we will replace it immediately with the
correct version, free of charge.
⏰ 24/7 Support: We are always here – reach out anytime and expect a fast response.
,Test Bank
Chapter 1
The Accounting Equation and Recording Journal Entries
Name: ______________________________
Class: ______________________________
Date: ______________________________
Display the Accounting Equation
1. What represents amounts owed to entities outside of a business?
A. Assets
B. Liabilities
C. Receivables
D. Equity
2. Which of these describes the accounting equation?
A. Owner’s Equity = Profit - Liabilities
B. Profit = Revenue / Liabilities
C. Assets = Liabilities + Owner’s Equity
D. Revenue = Equity * Assets
Enter Data and Numbers in Excel
3. If the [Enter] key on the keyboard is used to complete this entry, where will the cursor move?
A. A2
B. B1
C. B2
D. It will remain in cell A1.
4. If the [Tab] key is used to complete this entry, where will the cursor move?
A. A2
B. B1
C. B2
D. It will remain in cell A1.
Microsoft Excel for Accounting, 2nd Edition Page 1 of 6
,Test Bank
5. If the Enter button on the formula bar is used to complete this entry, where will the cursor
move?
A. A2
B. B1
C. B2
D. It will remain in cell A1.
6. Which of these is considered a constant value?
A. 4,200
B. =5+81
C. =82*43
D. =9/9
7. The thick border surrounding an active cell is referred to as the _____.
A. Ribbon
B. entry
C. reference
D. highlight
8. Match each keyboard key with the impact it has on the location of the active cell.
Keyboard Keys Where the Active Cell Moves
A. (Enter) _____ 1. It will move to the next cell in the applicable
B. [Tab] _____ direction.
C. (←)(↓)(↑)(→) _____ 2. It will move down to the next cell.
D. (Esc) _____ 3. The entry is deleted, and the cell remains active.
4. It will move to the next cell to the right.
Record Journal Entries
9. Which statement is correct about debits?
A. A journal entry can include only one debit.
B. Debits are indented within a journal entry.
C. A debit increases the balance within a revenue account.
D. Debits appear above credits within a journal entry.
10. What is NOT a standard component of a journal entry?
A. Debited account
B. Credited amount
C. Accounting equation impact
D. Explanation
Microsoft Excel for Accounting, 2nd Edition Page 2 of 6
,Test Bank
11. Which cell contains a long text entry?
A. A1
B. A2
C. A3
D. A4
12. Which cell contains a truncated long text entry?
A. A1
B. A2
C. B1
D. B2
13. What feature can be used to adjust the width of column A to accommodate the text in cell A1?
A. Drag and drop
B. Right-dragging
C. AutoFit
D. Paste Options
14. What feature makes this menu appear?
Microsoft Excel for Accounting, 2nd Edition Page 3 of 6
,Test Bank
A. Drag and drop
B. Right-dragging
C. AutoFit
D. Paste Options
15. Using drag and drop results in the same outcome as using _____.
A. point and click
B. Bold and Italic
C. Undo and Redo
D. Cut and Paste
16. If the contents of cell A1 are copied and pasted into cell A3, what will appear in cell A3?
A. Liabilities
B. Nothing, the cell will be empty.
C. Liabilities Assets
D. Assets
17. Match each Excel action with its associated description.
Actions Descriptions
A. Drag and drop _____ 1. Adjust column width (or row height) to
B. Right-dragging _____ accommodate the widest (or tallest) entry.
C. AutoFit _____ 2. Drag the outside border of a cell to move the
D. Copy and Paste _____ contents to a new location.
3. Move the contents of a cell to a new location
without dragging the border.
4. Drag the outside border of a cell to a new
location to prompt a menu of options.
Use Undo and Redo in Excel
18. Which actions cannot be undone?
A. Right-dragging
B. Saving a file
C. Deleting text
D. Changing the page orientation
Microsoft Excel for Accounting, 2nd Edition Page 4 of 6
,Test Bank
19. Maci notices that the Redo button is shaded and can’t be clicked, but the Undo button is active.
Why?
A. She hasn’t yet issued the Undo command.
B. Excel hasn’t identified any errors for her to correct.
C. She must have printed the file.
D. You can only redo actions in the order you undid them.
20. Tyler chooses the “Typing ‘Assets’ in A1” option from the Undo menu. What happens?
A. The text “Assets” is removed from cell A1.
B. The text “Liabilities” is removed from cell A3.
C. The text in both cell A1 and cell A3 is removed.
D. Nothing; he has to undo actions from top to bottom in the list.
21. What action results in this ScreenTip being displayed?
A. Hovering the mouse pointer over the Enter button
B. Clicking the Enter button and dragging down
C. Clicking the Enter button
D. Right-clicking the Enter button
Print Worksheets
22. What action cannot be done in Backstage view?
A. Altering the print options
B. Viewing a preview of the printout
C. Navigating through the previewed worksheet pages
D. Editing the worksheet
23. What page orientation is this?
A. Portrait
B. Horizontal
C. Accounting
D. Landscape
Microsoft Excel for Accounting, 2nd Edition Page 5 of 6
,Test Bank
24. Match each Ribbon option with its associated description.
Ribbon Options Descriptions
A. Orientation _____ 1. Changes the page dimensions
B. Size _____ 2. Sets where one printed page ends and the next
C. Print Area _____ begins
D. Breaks _____ 3. Sets the page layout to either portrait or landscape
4. Allows you to identify a range of cells that will be
printed
25. Braedon completed his worksheet and is in a rush to print a portion of it, so he clicks the Quick
Print button. What happens next?
A. Backstage view is displayed so he can choose the print options.
B. The worksheet is sent to the printer with the current print options in effect.
C. A menu is displayed from within the available print options for this worksheet.
D. The print preview appears.
Microsoft Excel for Accounting, 2nd Edition Page 6 of 6
,Test Bank
Chapter 2
Financial Statements
Name: ______________________________
Class: ______________________________
Date: ______________________________
Create an Income Statement
1. What formula is conveyed in the income statement?
A. Assets = Liabilities + Equity
B. Net Income = Revenue - Expenses
C. Current Assets + Long-Term Assets = Total Assets
D. Beginning Equity + Net Income + Investments by Owner – Withdrawals = Ending Equity
2. What description is used when the final amount in the income statement is positive?
A. Total Expenses
B. Net Loss
C. Total Revenues
D. Net Income
Create a Statement of Owner’s Equity
3. What is NOT included in a statement of owner’s equity?
A. Net Loss
B. Total Liabilities
C. Beginning Equity
D. Investments by Owner
4. On what line of the statement of owner’s equity header do you enter the ending equity
balance?
A. First
B. Second
C. Third
D. The ending equity balance is not included in the header.
Microsoft Excel for Accounting, 2nd Edition Page 1 of 6
, Test Bank
Create a Balance Sheet
5. Which account would appear in the balance sheet?
A. Rent Expense
B. Jack Franklin, Withdrawals
C. Service Revenue
D. Salaries Payable
6. The balance sheet conveys financial information for the _____.
A. end of the final day of the period
B. entire period
C. time since the last asset purchase was made
D. time since the last liability payment was made
7. Place the financial statements below in the order in which they are completed.
Financial Statements Order in Which to Complete
A. Balance sheet _____ 1. First
B. Income statement _____ 2. Second
C. Statement of cash flows _____ 3. Third
D. Statement of owner’s equity _____ 4. Fourth
Alter Columns, Rows, and Text Alignment
8. What statement is correct about hidden rows?
A. They will print.
B. They are removed from the worksheet.
C. They are visible when modifying the worksheet.
D. They can be unhidden.
9. Alan wants to delete cells A3 and A4 while keeping all of column B as is. With the cells selected
as shown, which Delete Cells option does he choose?
A. Shift Cells Left
B. Shift Cells Up
C. Entire Row
D. Entire Column
Microsoft Excel for Accounting, 2nd Edition Page 2 of 6
