Chapter 9. Working with Data, Functions, and Formulas

image

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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.