Study your flashcards anywhere!
Download the official Cram app for free >
 Shuffle
Toggle OnToggle Off
 Alphabetize
Toggle OnToggle Off
 Front First
Toggle OnToggle Off
 Both Sides
Toggle OnToggle Off
 Read
Toggle OnToggle Off
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
A key: Read text to speech.a key
35 Cards in this Set
 Front
 Back
Active cell

The selected cell in the worksheet; indicated with a dark border.


Adjacent range

A single rectangular block that include a group of contiguous cells.


Argument

Specifies the numbers, text, or cell references used by the function to calculate a value.


Arithmetic operator

Symbols, such as +, , *, or /, used in a formula to perform a arithmetic calculations.


AutoComplete

Excel feature that anticipates the text you are about to enter by displaying text that begins with the same letter as a previous entry displays.


AutoSum

Toolbar button that automatically inserts the SUM function to calculate the sum of values in a range.


Cell

The intersection of a column and row in a worksheet.


Cell reference

The address of cell indicating its column and row location.


Clear

Erases the contents of a cell, leaving the cell in the worksheet.


Column

The horizontal portion of a worksheet identified by letters.


Delete

To remove a cell or cells from a worksheet, shifting the remaining worksheet cells into the space previously occupied by the deleted cell or cells; also to remove a worksheet entirely from a workbook.


Documentation sheet

A worksheet that provides information about the content and purpose of the workbook.


Edit mode

Excel mode in which you can edit cell contents.


Formula

A mathematical expressions that calculates a value; all Excel formulas always begin with an equal sign (=) followed by an expression describes the calculation to be done.


Formula bar

The bar located about the workbook window in which the contents of a cell in displayed.


Formula view

View in which cell formulas are displayed, rather than the values returned by the formulas.


Function

A predefined formula that performs calculations using specific values called arguments.


Landscape orientation

Orientation of a printed page in which the page is longer than it is tall.


Name box

Box located on the leftmost end of the Formula bar in which the cell reference to the active cell is also displayed.


Nonadjacent range

Cell range that is comprised of two or more separate adjacent ranges.


Order of precedence

A set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second, and so forth.


Range

A group of worksheet cells, which can be adjacent or nonadjacent; also called a cell range.


Range reference

Identification of a cell range using the upperleft and lowerright corners of the rectangle selection of the cells.


Row

The vertical portion of a worksheet, identified by numbers.


Sheet tab

The area at the bottom of a worksheet that identifies the worksheet; clicking a sheet tab makes the worksheet active.


Spell checker

An Excel editing tool that you can use to check the words in the workbook against the program’s internal dictionary.


Spreadsheet

A tool used in business for budgeting, inventory management, and decision making for analyzing and reporting information.


SUM function

Math function that calculates the sum of a set of numbers.


Tab scrolling buttons

Navigation tools located in the lowerleft corner of the Excel window used to view the worksheet tabs present in the workbook.


Value

Number entered in a cell that represents a quantity of some type, such as the number of units sold, stock prices, a exam score, and so on.


Whatif analysis

An approach you can use in Excel to analyze workbook data by changing one or more of the values and then examining the recalculated values to determine the effect of the change.


Workbook

File in which Excel stores an electronic spreadsheet.


Workbook window

Window in which a workbook is displayed; also called worksheet window.


Worksheet:

Each workbook is made up of individual worksheets, or sheets containing formulas, functions, values, text, and graphics.


Worksheet window

Window in which a workbook is displayed; also called worksheet window.
