Ch14qz03a - Cells A5 through A18 by highlighting them Click the icon to return Click Next d In Step 3 click the “Titles” tab Add labels as

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

View Full Document Right Arrow Icon
BUSINESS MATH USING EXCEL Name ______________________________ Date ______________________________ Chapter 14 - Quiz 03 Date 1-Jul 68 2-Jul 75 3-Jul 114 4-Jul 55 5-Jul 68 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. Select Cells B4 through B18 by highlighting them. e. Also in Step 3, click the “Legend” tab. Turn Show legend off. Click Finish. Dell’s Cooking and Recipe Sharing Hit Log for July 1 – July 14 Web Site Hits b. Click the Chart Wizard button. In Step 1, under Chart type, select “Line.” Then, under Chart sub-type, select “Stacked line with markers displayed at each data value.” Click Next. c. In Step 2, click the “Series” tab. Click the icon in the “Category (x) Axis Labels” box. Select
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Cells A5 through A18 by highlighting them. Click the icon to return. Click Next. d. In Step 3, click the “Titles” tab. Add labels as follows: Chart Title: DELL’S CRS WEB SITE HITS Category (x) Axis Label: Date Value (y) Axis Label: Web Site Hits f. Adjust overall size and position of graph as needed. Make cosmetic changes as desired. Double click on any element of the graph to open the appropriate Format window. g. Save the file as ch14qz03a.xls. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 20 40 60 80 100 120 140 DSL LINES ADDED Web Site Hits Year Number of Lines A B C D E F G 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...
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