Chapter 9. Working with Data, Functions, and Formulas


Excel 2010 is a very powerful spreadsheet program, which means that it can be used to calculate values based on the figures entered into the cells, using formulas, which are customized relationships that are placed into the Formula Bar, and functions, which are standard calculations, like the average of a set of numbers.

Excel provides numerous features to work with data effectively. In a large spreadsheet, you can use the Find feature to locate specific items in cells. And as you construct a spreadsheet, you can use Excel’s artificial intelligence to fill in blank cells and complete a series ...

Get Easy Microsoft Office 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.