Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.2 Summarize Data with Functions: Demonstrate How To Apply the SUM Function Chart Layout The next pages will demonstrate several more Chart Elements. This example is based on a Column Chart. Here are the steps to create that Chart. 1. Try it: Enter the Data Please select a blank spreadsheet. Enter the Labels in Row 1. Cell A1: Department Cell B1: Salary   Enter the Data in Column A. Cell A2: Web Designer Cell A3: Training Cell A4: Sales   Enter the Numbers in Column B. Cell B2: 45,000 Cell B3: 50,000 Cell B4: 75,000 Format Row 1: Bold Format Column B: Accounting Calculate the SUM B5=SUM(B2:B4) Keep going... Home->Number