Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle 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


Play button


Play button




Click to flip

42 Cards in this Set

  • Front
  • Back
An Excel file with one or more worksheets.
The work area for entering and calculating data made up of columns and rows separated by gridlines (light gray lines). Also called a spreadsheet.
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.
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.
A workbook with certain labels, formulas, and formatting preset, saving you time in creating commonly used worksheets, such as sales invoices or balance sheets.
Text in the first row or column of a worksheet that identifies the type of data contained there.
The standard settings Excel uses in its software, such as column width or number of worksheets in a workbook.
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.
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.
A number entered in the worksheet.
Numeric label
A number entered in the worksheet as a label, not as a value---such 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.
A list of sequential numbers, dates, times, or text.
column width The default number of characters that display in a column based on the default font.
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.
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.
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.
to use a function as an argument within another function
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
A text note attached to a worksheet cell.
A preprogrammed Excel formula for a complex calculation.
A statement in an IF function that if true yields one result and if false yields another result.
using a function as an argument within another function
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.
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.