Excel Case 3 - Statistics Tracking

Excel Case 3 - Statistics Tracking - EXCEL CASE 3:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
EXCEL CASE 3: STATISTICS TRACKING DURHAM TEMPORARY STAFFING: STATISTICS TRACKING SKILLS Add headers to worksheets Copy a formula with relative cell references Copy cell contents Create a complex formula Create formulas using the SUM function Edit numbers in cells Enter formula arguments by pointing Fill adjacent cells with formulas Modify worksheet names Modify worksheet orientation Use AutoSum Use Page Layout View CASE SCENARIO Durham Temporary Staffing (DTS) is an employment firm that matches qualified candidates to temporary jobs in companies in the Raleigh-Durham area of North Carolina. Jobs can be full or part time, and range from administrative and clerical to customer service and sales. You are working as the assistant to the DTS communications director, who asks you to analyze the demand for employees in various job categories and to compile statistics on job placements made this year. She has already prepared an Excel worksheet with the job data organized by
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

Excel Case 3 - Statistics Tracking - EXCEL CASE 3:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online