# Explanation of Basic Excel Ranges and Entering Formulas

In the world of basic Excel operators are often used it is necessary to know the parts in it. For example, ranges. Range in Excel is very important because data will be displayed correctly if the range matches. It doesn’t stop there, the formula will also work if the range given is right.

The range itself is also known as the range. Is a group of cells. There are several types of this range or range. Even under certain conditions, the range itself does not need to be close to one another. Look at the types of ranges below for more details.

Contents

## Flat Horizontal Range Easily Recognized

Range or horizontal range is a collection of cells that are flat (sleep). An easy example is the range between B4:F4. A colon (:) in basic Excel is known as an interval. So it connects one cell to other cells in one range.

### 1. Vertical Range for Columns

If the horizontal range is flat create a line blockage. Then the vertical range is for the column. Knowing the range has many functions, one of the functions of the range is to summarize when you want to enter cells into formulas.

Without the need to write a lot of cells, just block the cells that fall within that range.

### 2. Mixed Range Combines Rows and Columns

The next type of range is mixed. Distinguishing the horizontal and vertical ranges is quite easy, the mixed range is a combination of the two.

### 3. Multiple Choice Ranges Don’t Have to Adjacent

The range itself does not need to be close together like the three types of the range above. There is one type that proves it, namely the Multiple Selection Range.

## Enter Basic Excel Formula Formulas 