ch01qz02a

# ch01qz02a - 3600 Totals \$2,150 \$25,800 Directions a Enter a...

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 01 - Quiz 02 Northridge Country Club Membership Dues Name Type of Dues Monthly Dues Total Adams, Mark Family 300 3600 Castillo, Elena Couple 250 3000 Garcia, Gorges Couple 250 3000 Hernandez, Ana Single 200 2400 Jiminez, Adrian Family 300 3600 Kennedy, Mary Couple 250 3000 Nugyen, Chein Family 300 3600 Okano, Chikara Family 300
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3600 Totals \$2,150 \$25,800 Directions: a. Enter a formula in Cell D6 to multiply Monthly Dues by 12 months. b. Copy the formula down Column D. c. Total Columns C and D. Format totals for Currency. Set Decimal places to zero. Set Currency symbol to \$. d. Save the file as ch01qz02a.xls. A B C D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online