How To Summarize In Excel

Table of contents:

How To Summarize In Excel
How To Summarize In Excel

Video: How To Summarize In Excel

Video: How To Summarize In Excel
Video: How to make Summary Report in Excel within 2 minutes, How to Summarize Data in Excel 2024, April
Anonim

Excel refers to the Microsoft Office software package that comes with Microsoft software. It is a spreadsheet editor that allows you to perform various actions with data. With the help of this program, you can perform various mathematical operations, process large arrays of data presented in tabular form, build graphs and diagrams on their basis, and analyze the results obtained.

How to sum in Excel
How to sum in Excel

Necessary

  • - computer
  • - Microsoft Office Excel.

Instructions

Step 1

Enter the program. To do this, open the Start menu in the lower left corner of your monitor. In the window that opens on the left, look for the name Microsoft Office Excel 2007.

The figure 2007 is the year in which the version installed on your computer was released. The year of issue can be 2000, 2003, 2007, etc. When you find the program, open it.

Step 2

If there is no such program in the list, then in the same Start menu open the All Programs tab. Here you need to find the "Microsoft Office" tab, and in it - Microsoft Office Excel 2007.

Step 3

A sheet of cells will open in front of you. In each such cell, you can do different actions, including setting formulas and doing calculations.

Step 4

To sum in Excel means to add the given numbers. There are different ways to do this.

Step 5

Stand on any cell in which you want the result to be indicated. Put the "=" sign. This means that in the cell you will perform arithmetic operations and work with formulas. After the "=", write down the numbers that you want to add, separated by the "+" sign. Finally press "Enter". The cursor will move down or to the right one cell, and the result of the addition will be reflected in the cell. Return the cursor to the cell to see the numbers that you have added. There is a long line at the top, below the toolbar, with “fx” written to the left of it. The numbers that you added will be reflected here.

Step 6

Now let's look at the "auto-sum" option. It is usually found in the toolbar and is denoted by the letter "∑". The option allows you to sum the numbers written in different cells. The cells must follow each other in a column or line so that they can be selected with a rectangle. Write down the numbers that you need to add in a column in the cells below each other. Then place the cursor on the cell after the column and click the "∑" icon. A flickering frame will appear. It highlights the area of the numbers to be added. The borders of this frame can be changed. To do this, press the left mouse button and drag the lower right corner of the frame. When set the boundaries, press "Enter". Further, everything is the same. Only the formula bar will show the formula that Excel uses to sum the region numbers.

Recommended: