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
42 Cards in this Set
 Front
 Back
Workbook

An Excel file with one or more worksheets.


Worksheet

The work area for entering and calculating data made up of columns and rows separated by gridlines (light gray lines). Also called a spreadsheet.


Cell

A cell is the intersection of a column and a row on a worksheet. You enter data into cells to create a worksheet.


Active Cell

The active cell contains the cell pointer. There is a dark outline around the active cell.


Task pane

A vertical window that provides quick access to common command such as opening and creating workbooks, searching for workbooks, getting help, and so on.


Formula bar

As you enter data into a cell, it simultaneously appears in the Formula bar, which is located above the worksheet frame.


Cell reference

The location of a cell in a worksheet as identified by its column letter and row number. This is also known as the cell’s address.


Scroll

A way to view locations on the worksheet without changing the active cell.


Sheet tabs

Tabs that appear at the bottom of the workbook window, which display the name of each worksheet.


Tab scrolling buttons

Buttons that appear just to the left of the sheet tabs, which allow you to scroll hidden tabs into view.


Blank workbook

The excel default workbook contains three worksheets or sheets.


Template

A workbook with certain labels, formulas, and formatting preset, saving you time in creating commonly used worksheets, such as sales invoices or balance sheets.


Label

Text in the first row or column of a worksheet that identifies the type of data contained there.


Default

The standard settings Excel uses in its software, such as column width or number of worksheets in a workbook.


AutoComplete

A feature used to complete an entry based on previous entries made in the column containing the active cell.


Pick from list

A shortcut used to insert repeated information.


AutoCorrect

A feature used to automate the correction of common typing errors.


Spelling Checker

A tool used to assist you in finding and correcting typographical or spelling errors.


Value

A number entered in the worksheet.


Numeric label

A number entered in the worksheet as a label, not as a valuesuch as year 2005 used as a column label.


Label prefix

An apostrophe (‘) used to indicate that a number is really a label an dnot a value.


Series

A list of sequential numbers, dates, times, or text.


Standard

column width The default number of characters that display in a column based on the default font.


Formula

An instruction Excel uses to calculate a number


Mathematical operators

Symbols used in mathematical operations: + for addition, for subtraction, * for multiplication, / for division, and ^ for exponentiation.


Order of mathematical operations

The order in which Excel performs the calculations specified in a formula.


Number format

A format that controls how numerical data is displayed, including the use of commas, dollar signs (or other symbols), and the number of decimal places.


Percent format

A style that displays decimal numbers as a percentage.


Comma Format

A style that displays numbers with a thousands separator (,).


Active sheet tab

The selected worksheet; the tab name of an active sheet is bold.


Function

A predefined formula that uses the values in the cells you select to calculate its answer.


Function name

The name given to one of Excel’s predefined formulas.


Argument

The parts of a formula that are variable. You select the cells or cells for each argument, and Excel calculates the answer based on their values.


Nest

to use a function as an argument within another function


AutoCalculate

A feature that temporarily performs the following calculations on a range of cells w/o making you write a formula: Average, Count, Count nums, Max,, Min or Sum


Natural Language formula

A formula that refers to column or row heading labels instead of a cell reference or range


Comment

A text note attached to a worksheet cell.


Function

A preprogrammed Excel formula for a complex calculation.


Condition

A statement in an IF function that if true yields one result and if false yields another result.


Nesting

using a function as an argument within another function


Argument

A variable used in a function. An argument can be a #, text, formula, or a cell reference. A comma separates each argument in a function.


Criteria

Similar to a condition. In the case of a SUMIF or COUNIF function, the criteria tells Excel which cells to count or sum. You list the criteria, such as >2000, and Excel counts or sums only the cells w/ values greater than 2000.
