Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Excel Lesson 1&2
Vocabulary terms
| Question | Answer |
|---|---|
| An excel file with one or more worksheets. | workbook |
| The work area for entering and calculating data made up of columns and rows. | worksheet |
| The intersection of a column and a row on a worksheet. | cell |
| The cell that has a dark outline around it. | active cell |
| Located above the worksheet and data appears as it is entered. | formula bar |
| The location of a cell in a worksheet as identified by its column letter and row number. | Cell reference |
| A way to view location on the worksheet without changing the active cell. | Scroll |
| Tabs that appear at the bottom of the workbook window which display the name of each worksheet. | Sheet tabs |
| Buttons that appear just to the left of the sheet tabs which allow you to scroll hidden tabs into view. | tab scrolling buttons |
| A new empty workbook that contains three worksheets. | Blank workbook |
| A workbook with labels, formulas and formatting presets. | template |
| Text in the first row or column of a worksheet that identifies the type of data contained there. | Label |
| The standard settings excel uses in its software. | default |
| The command used to reverse one or a series of editing actions. | undo |
| The command used to do an action you have undone. | redo |
| A feature used to complete an entry based on previous entries made in the column containing the active cell. | Autocomplete |
| A shortcut used to insert repeated information. | Pick from drop-down list |
| A feature used to automate the correction of common typing errors. | autocorrect |
| A tool used to assist you in finding and correcting typographical or spelling errors. | Spelling checker |
| A number entered in the worksheet. | value |
| A number entered in the worksheet as a label, not as a value. | numeric label |
| An apostrophe {'} used to indicate that a number is a label and not a value. | Label prefix. |
| A list of sequential numbers, dates, times or text. | series |
| The default number of characters that display in a column based on the default font. | standard column width |
| An instruction excel uses to calculate a number. | formula |
| Symbols used in mathematical operations: + for addition, - for subtraction, * for multiplication, / for division, and ^ for exponentiation. | Mathematical operators |
| The order in which excel performs the calculations in a formula. | Order of mathematical operations. |
| A block of cells in an excel worksheet. | range |
| A block of adjacent cells in a worksheet. | contiguous range |
| Cells in a worksheet that act as a block, but are not necessarily adjacent to each other. | noncontiguous range |
| To apply attributes to cell data to change the appearance of the worksheet. | format |
| A collection of coordinated fonts, colors, and effects for graphic elements | theme |
| The typeface or design of the text. | font |
| A color that fills a cell, appearing behind the data. | fills |
| A combination of a font, text color, cell color, and other font attributes applied to a single cell. | cell styles |
| The measurement of the typeface in points | font size |
| A format that controls how numerical data is displayed. | number format |
| A style that vertically aligns with dollar signs ($), thousands separators (,), and decimal points. | accounting format |
| A style that displays decimal numbers as a percentage. | percent format |
| A style that displays numbers with a thousands separator. | comma format |
| A style that displays dollar signs ($) immediately preceding the number and includes a thousands separator(,) | currency format |
| A feature of windows that holds data or graphics that you have cut or copied and are ready to be pasted into any document. | clipboard |
| Dragging this handle will copy cell contents, formatting or a formula to adjacent cells. | fill handle |
| A cell address expressed in relation to the cell containing the formula. | relative cell reference |
| A cell address such as $E$14, referenced in a formula is copied, the relative cell references are adjusted to reflect the new location of the formula cell. | absolute cell reference. |
| A feature used to display a document as it will appear when printed. | print preview |
| The command used to place data from the clipboard to a location on the worksheet. | paste |
| The command used to remove data from a cell or range of cells and place it on the clipboard. | cut |
| A method used to move or copy the contents of a range of cells by dragging the border of a selection from one location and dropping it in another location. | drag -and-drop feature |
| Worksheets that selected as a unit; any action performed on this unit will affect all the worksheets in the group. | grouping |
| The selected worksheet; the tab name of an active sheet is bold. | active sheet tab |
Created by:
richars1
Popular Business sets