Excel Formulas

The Tutorials

Chapter 2

Building Basic Formulas

This chapter is about building the simplest possible formulas in Excel. Use this practice to learn how you can make Excel perform basic calculations with ordinary numbers.

Exercise #1: Pocket calculator Excel

In this exercise you'll look at sample calculations and translate them into Excel's formula language.

  1. Begin by opening the Pocket calculator.xlsx spreadsheet.

    Click the link above to download the workbook file to your computer, then open it. Excel will start in protected view, because it doesn't know whether it should trust your file. To accept the file and switch out of protected view, click Enable Editing in the yellow bar at the top of the Excel window.

  2. In column A are six problems, described in words or shown with an equation picture. In column B, you must write the Excel formula that solves each one. You'll know you've written the right formula if you get the answer that's shown in column C.

    If you don't get them all, you can find the formulas in the solution worksheet. (To get to the solution worksheet, click the Solution tab at the bottom of the Excel window.)