How can we help?

You can also find more resources in our Help Center.

50 terms

Excel

STUDY
PLAY
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.
adjacent
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.
spreadsheet
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 ?