# Shared Flashcard Set

## Details

Microsoft Excel 2010
n/a
67
Computer Science
11/28/2012

Term
 +
Definition
Term
 -
Definition
 operator used for subtraction
Term
 *
Definition
 operator used for multiplication
Term
 /
Definition
 operator used for division
Term
 ^
Definition
 operator used for exponentiation
Term
 parentheses - exponentiation - multiplication - division - addition - subtraction
Definition
 standard order of operations
Term
 equal precedence
Definition
 this characteristic of [multiplication and division] and [addition and subtraction] causes the operations to be evaluated as they are encountered from left to right
Term
Definition
 software application used for manipulating and analyzing tables of numbers
Term
 workbook
Definition
 an Excel document containing one or more sheets
Term
 worksheet
Definition
 a single page in an Excel workbook
Term
 three
Definition
 a new Excel workbook contains this many sheets by default
Term
 cell
Definition
 a data "space" formed by the intersection of a row and a column
Term
 letters
Definition
 Excels columns are labeled with these
Term
 numbers
Definition
 Excel rows are labeled with these
Term
 [image]
Definition
 this button on the Home ribbon inserts automatic SUM (and other) function for the adjacent range
Term
 name box
Definition
 displays the address or assigned name of the active cell
Term
 active cell
Definition
 the currently selected cell
Term
 cell pointer
Definition
 heavy border identifying the active cell
Term
 formula bar
Definition
 displays the contents of the currently selected cell
Term
 sheet tab
Definition
 displays the name of the worksheet
Term
 60
Definition
 the calculated value of the expression =6*(4+6)/(3-2)
Term
 24
Definition
 the calculated value of the expression =6*4+6/3-2
Term
 range
Definition
 a rectangular group of cells, such as might be used in a SUM function
Term
 A3:C5
Definition
Term
 Home
Definition
 keypress that moves the cell pointer to the first cell in the current row
Term
 End
Definition
 keypress that moves the cell pointer to the last occupied cell in the current row
Term
 Ctrl + Home
Definition
 keypress that moves the cell pointer to cell A1
Term
 Ctrl + G
Definition
 keypress that moves the cell pointer to the identified cell
Term
 ######
Definition
 appearance of these symbols in a cell signifies a number that is too big to be displayed in the current cell width
Term
 left
Definition
 default alignment for text in a cell
Term
 right
Definition
 default alignment for numbers in a cell
Term
 Ctrl + C
Definition
 keypress that copies the current selection to the Clipboard
Term
 Ctrl + X
Definition
 keypress that "cuts" (moves) the current selection to the Clipboard
Term
 Ctrl + V
Definition
 keypress that pastes the contents of the Clipboard to the current cell or range of cells
Term
 =
Definition
 symbol that identifies the following text as a formula
Term
 SUM
Definition
 Excel function that adds the values in the identified range
Term
 MIN
Definition
 Excel function that determines the minimum (smallest) value in the identified range
Term
 MAX
Definition
 Excel function that determines the maximum (largest) value in the identified range
Term
 COUNT
Definition
 Excel function that determines the number of cells with values in the identified range
Term
 AVERAGE
Definition
 Excel function that calculates the average value of the identified range
Term
 Freeze Panes
Definition
 Excel option that allows you to lock identified rows and/or columns in place so that they remain visible while you scroll through the sheet
Term
 Normal
Definition
 default page view that shows an editing view of the workbook
Term
 Page Layout
Definition
 page view that shows a sheet as it will appear on a printed sheet
Term
 Page break Preview
Definition
 page view that allows you to adjust the position of page breaks in printed output
Term
Definition
 information that appears at the top of each page of printed output
Term
 footer
Definition
 information that appears at the bottom of each page of printed output
Term
 Merge and Center
Definition
 Excel option that combines multiple cells into one to hold a sheet title
Term
 Accounting
Definition
 numeric format that includes a left-aligned dollar sign, comma separators, and two decimal places by default
Term
 Currency
Definition
 numeric format that includes a dollar sign, comma separators, and two decimal places by default
Term
 Comma
Definition
 numeric format that includes comma separators and two decimal places by default
Term
 Percent
Definition
 numeric format that multiplies a cell's value by 100 and appends a percent sign
Term
 conditional formatting
Definition
 automatic formatting (e.g., shading) applied to cells whose values meet specified criteria
Term
 filtering
Definition
 limiting the display to cell values that meet a specified criteria
Term
 chart
Definition
 a visual representation of spreadsheet data
Term
 column (bar)
Definition
 chart used to compare similar types of data
Term
 line
Definition
 chart used to illustrate the changes in data over time
Term
 pie
Definition
 chart used to represent the relative contributions (percentages) components contribute to a whole
Term
 data series
Definition
 worksheet data associated with an individual chart element, such a line, column, or pie "slice"
Term
 legend
Definition
 key that defines the colors, patterns, and symbols used in a chart
Term
 X-axis
Definition
 the horizontal (bottom) boundary of a chart
Term
 Y-axis
Definition
 the vertical (left) boundary of a chart
Term
 data point
Definition
 a single cell value plotted in a chart
Term
 explode
Definition
 pull out one or more "slices" of a pie chart for additional emphasis
Term
 embedded
Definition
 chart inserted on the same sheet as the originating data
Term
 absolute
Definition
 cell address that is not updated when a formula is copied to another cell
Term
 relative
Definition
 cell address that is updated when a formula is copied to another cell
Term
 \$G\$5
Definition
 format for typing an absolute address
Supporting users have an ad free experience!