Exam 77-420 Microsoft Excel 2013 2. Create Cells and Ranges 2.2 Format Cells and Ranges: Apply Number Formats

Still Before You Begin... 2. Try it: Add Sample Data Select Cell B2 and type: 2,850 Select Cell B3 and type: 8,170 Select Cell B4 and type: 21,470 Select Cell B5 and type: 1,050   Select Column B and format the numbers. Go to Home->Numbers->Accounting. Keep going... Memo to Self: You can use the sample spreadsheet or enter your own data. If you use the sample spreadsheet, you can link the sales data to the spreadsheet called Sales Subtotal by Category. Home->Numbers->Accounting