# Excel

### 50 terms by wandatland

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

### file

All the worksheets and charts in a workbook are saved together as one ?

### Ctrl

To fill a range with numbers that increment by 1--such as 1, 2, 3--press and hold down the ___ key and drag the fill handle.

### multiple

To insert ___ rows or columns, first select the number of rows or columns you want to insert.

### Format Painter

The button that allows you to copy formats from one cell and paste the formats into another cell or range.

### function

A formula that has already been created by Excel to perform a common calculation.

### operators

The +, -, * and / symbols are the basic calculation ___ used in worksheet formulas.

You can use the fill handle to copy data and formulas to ___ cells.

### relative

By default, Excel copies formulas with ___ reference.

### Merge and Center

The button used to center the contents of a single cell over a range of cells.

### AutoSum

Click this button drop-down arrow to insert commonly used functions such as SUM, MIN, MAX, or AVERAGE.

### Max

The function to find the highest number in a range.

### Min

The function to find the lowest number in a range.

### cell reference

The intersection of a column and a row such as A2.

### ESC

To deselect a chart object or cancel data entry before tapping the Enter key.

### asterisk (*)

The symbol that indicates multiplication.

### forward slash (/)

The symbol that indicates division.

### column

The type of chart used to compare two or more data series.

### CTRL key

To select nonadjacent cells, press and hold the ___.

### =B16/B19

A formula containing only relative references.

### =A2+\$C10

A formula containing both relative and absolute references.

### line

The type of chart used to show a change in the data over time.

### CTRL + Home

To immediately activiate cell A1, press the ___ keys.

A grid of rows and columns containing numbers, text and formulas.

### right

Numbers representing values in Excels are ___ aligned unless specified otherwise.

### column

The part of a worksheet that appears vertically and is identified by a letter at the top of the worksheet window.

### currency

Money values are typically formatted using the ___ format.

### wrap

When text is longer than the width of a cell, the ___ text feature moves some of the words to a new line within the same cell.

### row

The part of a worksheet that appears horizontally and identified by a number at the left of the worksheet.

### rotate

When text is wider than the cell, you could ___ the text.

### Freeze

To keep row or column titles on the screen at all times, you would use the ___ feature.

### #######

If the numbers are too long for a cell, this will appear in the cell.

### percentage

The ___ button formats cell contents with a % sign and two decimal places.

### C7:G4

The range of cells beginning in cell C7 and ending in cell G4.

### ascending

To sort a range of cells containing text in A, B, C order.

### descending

To sort a range of cells containing numbers from highest to lowest.

### F4

To add a dollar sign to a cell reference, tap the ___ key once.

### chart

A picture of worksheet data.

### embedded

A chart that is inserted on the worksheet with the data.

### equal (=)

Always begin a formula by typing the ___ sign.

### decrease decimal

To remove decimal places from cell contents, click the ___ button for each decimal place you want to remove.

### Formatting

You can add borders and shading to selected cells with the Borders and Fill Color buttons on the ____ toolbar.

### SUM

The function used to add numbers in selected cells.

### COUNT

The function used to find the number of employees in a company

### Pie

The type of chart that shows how each part of the whole is divided.

### left

The default alignment for text in cells.

### comma

The formatting for numbers larger than 999.

### gridlines

The borders around each cell.

### horizontal

To print with equal margins on the left and right of the worksheet, use ___ centering.

### vertical

To print with equal margins on the top and bottom of the worksheet, use ___ centering.

### File, Page Setup

To change the paper orientation, change margins, or to set worksheet centering, go to ?

Example: