Chapter 2

Basic Operations

Publisher Summary

This chapter provides some information on how to make a worksheet more readable, but the emphasis is on mathematical operations, which include: entering numbers, including fractions and percentages, simple formulas, range finders (colored borders showing what cells are used in a formula), arithmetic operators +, -, * , /, and ^, the Evaluate Formula tool, error values such a #DIV/O! and #VALUE!, copying with command and shortcuts, formatting numbers, the difference between stored and displayed values, and round off errors resulting from the IEEE 754 standard.

This book is about problem solving so we shall spend little time on the preparation of presentation-worthy worksheets. We will give some information ...

Get A Guide to Microsoft Excel 2007 for Scientists and Engineers 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.