What is the process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called?

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called: Filtering. The Excel command that enables you to specify rows and columns to repeat on each printed page is: Print Tiles.

What are bevels and shadows in Excel?

Bevel. A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled. Category axis. The area along the bottom of a chart that identifies the categories of data.

What is a series of rows that contain related data?

A series of rows and columns that contains related data and that is managed independently from other data is an Excel: table. The process of arranging data in a specific order based on the value in each field is called: sorting.

What do trendlines demonstrate?

A trendline is a line drawn over pivot highs or under pivot lows to show the prevailing direction of price. Trendlines are a visual representation of support and resistance in any time frame. They show direction and speed of price, and also describe patterns during periods of price contraction.

What Allow quickly apply the content for one cell to another cell?

Terms in this set (23)

1. Active Cell. The cell in your worksheet that has been selected.
2. Auto Fill. A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
3. Auto Sum.
4. Cell.
5. Cell Address/Reference.
6. Cell Grid.
7. Column.
8. Drag.

What is a cell reference that refers to cells by their fixed position in a worksheet?

A. Absolute cell reference. A cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied.

When a cell is part of an active formula it is surrounded with?

Calculate the Price

Where is Goal Seek in Excel?

On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek.

What is a predefined formula called?

A function is a predefined formula that performs calculations using specific values in a particular order.

How do you trade with trendlines?

How to use Trend Line and identify trend reversal

1. Wait for the price to break above the Trend Line.
2. Wait for a higher low to form (this tells you the sellers have exhausted themselves)
3. If the price breaks the swing high, the market is likely to reverse higher (the buyers are now in control)

Why would you add borders to cells?

In Excel 2010, you can add borders to individual cells to emphasize or define sections of a worksheet or table. Use the Borders button in the Font group on the Home tab to add borders of varying styles and colors to any or all sides of the cell selection.