ch04test01a

# Ch04test01a - g For Row 7 enter 10/3 Check No 1310 DirectTV 82.19 h For Row 8 enter 10/3 Check No 1311 Haney's Market 53.93 i For Row 9 enter 10/4

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 04 - Test 01 Date Check Description of Amount of Amount of Balance Number Transaction Check Deposit 4566.58 10/2 Deposit 1,683.48 6,250.06 10/2 1309 Scichili Landscape 129.50 6,120.56 10/3 1310 Direct TV 82.19 6,038.37 10/3 1311 Haney's Market 53.93 5,984.44 10/4 860.00 6,844.44 Directions: a. Enter the beginning Balance 4566.58 in Cell F4. b. Format cells in Column A for Date, Type x/xx. d. For Row 5, enter 10/2; for Amount of Deposit; 1683.48. f. For Row 6, enter 10/2; Check No. 1309; Scichili Landscape; 129.50.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: g. For Row 7, enter 10/3; Check No. 1310; DirectTV; 82.19. h. For Row 8, enter 10/3; Check No. 1311; Haney's Market; 53.93. i. For Row 9, enter 10/4; for Amount of Deposit; 860.00. c. Format Columns D, E, and F for Currency. Set Decimal places to 2 and Currency symbol to None. 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 ch04test01a.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

## This note was uploaded on 02/19/2012 for the course BUS bus 130 taught by Professor Munoz during the Winter '10 term at Everett CC.

Ask a homework question - tutors are online