O'Reilly logo

A Guide to Microsoft Excel 2007 for Scientists and Engineers by Bernard Liengme

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required