Able2Extract Mobile

Able2Extract Mobile for iPad is a Free, lightweight and easy to use app for creating and converting PDF documents. Users can create PDF from MS Office documents and convert PDF to Word, Excel, PowerPoint and more.

How to Use the Formulas Tab in Excel for iPad

At first glance, it is already clear that Excel for iPad is designed with tablet users in mind. The options given for editing your spreadsheets are clearly made to make it easier for you to add data without having to type too much.

The “FORMULAS” tab is a good example of this. It allows users to implement formulas to their data easily, without having to type out long equations.

Let’s take a look at how it works. Tap on the “FORMULAS” tab.

How to Use the Formulas Tab in Excel for iPad

You will see that there are many options when it comes to ready-to-use formulas available to you. They are grouped in categories, including AutoSum (some of the more basic formulas), Financial, Logical, Math & Trig, and more.

While there are obviously not as many options as you would find in the desktop version of Excel, there certainly are enough to work with when it comes to most basic and popular spreadsheet operations.

For this example, we are going to find the averages of two columns of data.

Tap on the first cell with numbers in it, and then slide your finger from the corner to include all of the data you need.

How to Use the Formulas Tab in Excel for iPad

Now tap on the AutoSum tab and select “AVERAGE” from the list of options.

How to Use the Formulas Tab in Excel for iPad

You will now see that Excel has calculated the averages for both rows of information.

How to Use the Formulas Tab in Excel for iPad

You can now tap on the corresponding cell and label the row accordingly. We have written “Monthly Average” in the corresponding cell.

How to Use the Formulas Tab in Excel for iPad