How to Input Transaction in the petty cash book with ms.excell

Which software program is used to input transactions in the petty cash book?

• Microsoft Word

• Microsoft PowerPoint

• Microsoft Excel

• Microsoft Access

What are the materials needed to input transactions in the petty cash book with Microsoft Excel?

• Mouse and Keyboard

• Transaction and Laptop

• Laptop and Mouse

• Laptop, Mouse, and Microsoft Excel

What is the first step to input transactions in the petty cash book with Microsoft Excel?

• Enter the formulas

• Enter the transaction details

• Open Microsoft Excel

• Calculate debit and credit columns

Which columns are included in the petty cash book in Microsoft Excel?

• Date, Description, Debit, Credit, and Balance

• Date, Description, Amount, Debit, and Credit

• Date, Description, Withdrawal, Expense, and Balance

• Date, Description, Receipt, Payment, and Balance

What comes after reading and understanding the transaction in the input process?

•  Enter the transaction details in debit and credit columns

• Calculate debit and credit columns

• Enter the formulas

• Enter the formula for balance calculation

Tags

CCSS.4.OA.A.3

Which column is used to enter the transaction date in the petty cash book?

• Debit

• Credit

•  Description

• Date

What is the purpose of entering the formula in the petty cash book?

• To calculate the balance

• To calculate the debit column

• To calculate the credit column

• To calculate the sum of all transactions

Tags

CCSS.4.OA.A.3

How should the debit and credit columns be calculated in the petty cash book?

• Using the SUM function

• Using the COUNT function

• Using the AVERAGE function

• Using the suitable formula

What is the final step in the process of inputting transactions in the petty cash book with Microsoft Excel?

• Enter the transaction details

• Calculate the debit and credit columns

• Enter the formula for balance calculation

•  Close Microsoft Excel

What is the suitable formula used to calculate the debit and credit columns in the petty cash book?

• =SUM(Debit)

•  =SUM(Credit)

• =SUM(Debit:Credit)

• =SUM(Credit:Debit)

Tags

CCSS.4.OA.A.3