ch14qz02a

ch14qz02a - Notice the equals sign appears in the Formula...

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

BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 14 - Quiz 02 Date Range Frequency 1-Jul 68 60 2 2-Jul 75 61-80 80 6 3-Jul 114 81-100 100 2 4-Jul 55 101-120 120 3 5-Jul 68 1 6-Jul 76 7-Jul 59 8-Jul 76 9-Jul 114 10-Jul 121 11-Jul 114 12-Jul 98 13-Jul 87 14-Jul 76 Directions: a. In Cell E5 enter 60, the first break point. b. In Cell E6 enter 80, the second break point. c. In Cell E7 enter 100, the third break point. d. In Cell E8 enter 120, the last break point. Dell’s Cooking and Recipe Sharing Hit Log for July 1 – July 14 Web Site Hits Break Points e. Select Cells F5 through F9. Click on the equals sign in the Formula bar.
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Notice the equals sign appears in the Formula bar. Key the first part of the Frequency formula FREQUENCY(. f. Notice when the parenthesis is keyed, the Frequency dialog box drops down. Key in the Data_array box the range for the grades (B5:B18). g. Key the range of cells containing your break points (E5:E8) in the Bins_array box. h. Press CTRL + SHIFT + Enter to apply the results of the Frequency formula to the selected cells. i. Save the file as ch14qz02a.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 23 24 25 26 27 28 29 30...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online