ch04qz01a

# ch04qz01a - For Row 5 enter 9/2 for Amount of Deposit...

This preview shows page 1. Sign up to view the full content.

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 04 - Quiz 01 Date Check Description of Amount of Amount of Balance Number Transaction Check Deposit 1,698.21 9/2 Deposit 1,204.75 2,902.96 9/2 1208 Schichili Landscape 119.50 2,783.46 9/3 1209 Direct TV 75.16 2,708.30 9/3 1210 Haney's Market 42.82 2,665.48 9/4 Deposit 750.00 3,415.48 Directions: a. Enter the beginning Balance 1698.21 in Cell F4. b. Format cells in Column A for Date, Type x/xx. c. Format Columns D, E, and F for Currency. Set Decimal places to 2 and Currency symbol to None. d.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: For Row 5, enter 9/2; for Amount of Deposit; 1204.75. f. For Row 6, enter 9/2; Check No. 1208; Scichili Landscape; 119.50. g. For Row 7, enter 9/3; Check No. 1209; DirectTV; 75.16. h. For Row 8, enter 9/3; Check No. 1210; Haney’s Market; 42.82. i. For Row 9, enter 9/4; for Amount of Deposit; 750.00. e. Enter a formula to calculate the new Balance in Cell F5. Copy the formula to the remaining cells in Column F. j. Save the file as ch04qz01a.xls. A B C D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online