Add More Data What are the hourly wages? Well, there are 50 weeks in a year (after you take away the holidays) and 40 hours in a work week. So, hourly wages can be calculated by dividing the Salary by (50*40) 2. Try it: Add More Data In Cell C1 type: Hourly Wage This is a label: Format C1 BOLD.   Format the Data: Select Column C. Format the Cells for Accounting. (This is money, isn't it?) Create a Formula: Select Cell C2. In Cell C2 enter the formula: =B2/(50*40)   AutoFIll the Formula: Select Cell C2 and AutoFill that formula in Cells C3:C4. Proof Your Work: Select Cell C4. The formula should be: =B4/(50*40) Keep going... Home -> Cells ->Format

Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.2 Summarize Data with Functions