September 2010
Beginner
408 pages
10h 23m
English
Content preview from Excel® 2010 Workbook for Dummies®Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 6. Building Formulas
In This Chapter
Constructing simple arithmetic and comparative formulas by hand
Creating formulas that use Excel's built-in functions
Editing formulas
Altering the order in which a formula's operands are calculated
Creating external reference link formulas
Controlling formula recalculation
No one disputes that formulas are the center of almost every spreadsheet you create. Being able to build formulas (both those that perform simple arithmetic calculations as well as those that perform more sophisticated computations using Excel's built-in functions) is a critical skill. The exercises in this chapter give you a chance to practice building both types of formulas as well as modifying how and when the formulas in the spreadsheet are recalculated.
Building Formulas
All the formulas you build in an Excel spreadsheet, regardless of their function and degree of complexity, have one thing in common: They all begin with one simple character, = (the equal-to sign).Typing an equal-to sign activates the Enter and Cancel buttons on the Formula bar. It also changes the nature of the Name Box drop-down box so that its list displays commonly-used functions rather than the range names assigned to the workbook.
If you forget to type this as your initial character when creating formulas by hand (Excel is always sure to put one in for you when you build formulas with the Insert Function button), the program inserts the string of operands and operators you enter as a text reference. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.