ch14qz01a

# ch14qz01a - Enter a formula in Cell B12 to calculate the...

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 14 - Quiz 01 Family Units Annual Salary Husband/Wife Only \$53,232.00 Husband/Wife/Children under age 6 \$66,928.00 Husband/Wife/Childred ages 6-17 \$69,472.00 Husband/Wife/Children over age 18 \$64,725.00 One Parent/One child under age 18 \$25,095.00 Single Persons \$28,969.00 \$51,403.50 \$58,978.50 NONE Directions: a. Enter a formula in Cell B11 to calculate the Mean. b.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Enter a formula in Cell B12 to calculate the Median. Department of Labor Consumers Expenditure Survey Average Annual Income Mean Median Mode c. Enter a formula in Cell B13 to calculate the Mode. If there is no mode, key “NONE.” d. Format Cells B11 through B13 for Currency. Set Decimal places to 2. Set Currency symbol to \$. e. Save the file as ch14qz01a.xls. A B 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