Move data Delete data from a worksheet and then place that data at a different location in the workbook or into another file. Name box Displays the ce...
Vocabulary Active cell The cell displayed with a bold border. Also called the selected cell.
Range Selection of two or more cells.
Adjacent cells Cells that are next to each other.
Relative cell reference A cell reference that reflects the row or column it has been copied to.
Boundary (Excel) The bar separating the column letters at the top of the worksheet.
Row (Excel) Horizontal part of the worksheet grid identified by the numbers.
Cell reference The column letter and row number that identify a cell, such as B3.
Selected cell See Active cell.
Cell styles Used to apply several formats in one step. Circular reference An error that occurs when a formula references the cell it is stored in. Column (Excel) Vertical part of the worksheet grid identified by the letters. Conditional formatting Formatting that is applied to a cell when a specified condition is met.
Sheet See Worksheet. Source The data to be copied or moved. Spreadsheet An application used to store and analyze data. Template In Excel, a master workbook that includes the basic elements for a particular type of workbook. Time Data displayed as a time (i.e., 12:30 PM).
Data Information stored in a worksheet. Categorized as either label, value, or date/time.
Value Numeric data that can be used in calculations.
Date Data displayed as a calendar date.
Worksheet Sheets in an Excel workbook.
Destination The upper-left cell of the range where data is to be pasted. Duplicate data To make a copy of data and then place that copy at a different location in the worksheet or into a completely different document. Fill handle The solid square in the lower-right corner of a selected cell that is dragged to copy the contents of a cell to adjacent cells. Formula Mathematical statement used to calculate a value. A formula must always begin with an equal sign. Formula bar Displays the active cell‘s contents. Located above the cells. Gridlines Solid lines that mark off the rows and columns in a worksheet. Label Text stored in a cell that cannot be used in calculations. Move data Delete data from a worksheet and then place that data at a different location in the workbook or into another file. Name box Displays the cell reference of the active cell. Located at the top of the worksheet. Order of operations The precedence Excel follows to evaluate a mathematical expression. Page Layout view View that displays the worksheet as a printed page. Pointing Clicking a cell to place its reference in a formula.
Workbook An Excel file.
Excel Commands Accept/ Reject Changes Displays a dialog box prompting for which changes to review. Found in REVIEW j Track Changes. Accounting Number Format Applies the Accounting format to the active cell. Found on the HOME tab. Align Left Formats the active cell as left aligned. Found on the HOME tab. Align Right Formats the active cell as right aligned. Found on the HOME tab. Allow Users to Edit Ranges Displays a dialog box with options for editing a cell range on a protected sheet. Found on the REVIEW tab. Bold Formats the active cell as bold. Found on the HOME tab. Borders HOME tab.
Used to format cell borders. Found on the
Cancel Restores the original contents of the active cell. Found on the formula bar. Center Formats the active cell as center aligned. Found on the HOME tab. Comma Style Adds a thousands separator to a value. Found on the HOME tab. Conditional Formatting Displays a list of rules used to specify conditional formatting. Found on the HOME tab. Copy Creates a duplicate of the selected cell(s) contents for pasting. Found on the HOME tab. Cut Removes the selected cell(s) contents. Found on the HOME tab. Data Bars Displays a list of options for conditional formatting. Found in HOME j Conditional Formatting. Email Displays an email message with the workbook as an attachment. Found in j Share. Enter Enters data in the active cell. Found on the formula bar. Error Checking Displayed by a cell that has an error in the formula it stores. Font Displays a list of fonts to choose from. Found on the HOME tab. Font Size Displays a list of font sizes to choose from. Found on the HOME tab. Format Painter Copies cell formatting from one cell to another. Found on the HOME tab. Header & Footer Adds a header and footer to the worksheet and displays the worksheet in Page Layout view. Found on the INSERT tab.
Highlight Cell Rules Displays a list of options for conditional formatting. Found in HOME j Conditional Formatting. Highlight Changes Displays a dialog box with options for tracking changes. Found in REVIEW j Track Changes. Hyperlink Displays a dialog box used to insert a hyperlink into the active cell. Found on the INSERT tab. Italic Formats the active cell as italic. Found on the HOME tab. Merge & Center Used to merge a group of adjacent cells and center text within the merged cells. Found on the HOME tab. New Creates a new workbook. Found in Backstage view. Number Format Used to select number formats. Found on the HOME tab. Online Pictures Displays a dialog box used to place a graphic on the worksheet. Found on the INSERT tab. Orientation Used to change text orientation. Found on the HOME tab. Paste Places the most recently copied or cut data into a worksheet starting at the selected cell. Found on the HOME tab. Paste Options a worksheet.
Displayed when data is pasted on
Percent Style Formats the active cell as percentage with no decimal places. Found on the HOME tab. Pictures Displays a dialog box used to place a graphic on the worksheet. Found on the INSERT tab. Print Prints a copy of the worksheet. Found in Backstage view. Protect Sheet Displays a dialog box with options for protecting the contents of the active sheet. Found on the REVIEW tab. Protect Workbook Displays a dialog box with options for protecting sheets and the window. Found on the REVIEW tab. Remove Hyperlink Removes the blue underline from text in a cell. Found in the menu displayed by right-clicking the cell containing a link. Redo Repeats the last action. Found on the Quick Access Toolbar. Save As Displays a dialog box used to save a workbook as a template. Found in Backstage view.
Spelling Checks the spelling of text in the worksheet. Found on the REVIEW tab. Thesaurus Displays a task pane used to suggest words with similar meanings. Found on the REVIEW tab. Top/Bottom Rules Displays a list of options for conditional formatting. Found in HOME j Conditional Formatting. Underline Formats the contents of the active cell as underlined. Found on the HOME tab. Undo Reverses the previous action. Found on the Quick Access Toolbar. Unprotect Sheet Displays a dialog box with options for unprotecting the contents of the active sheet. Found on the REVIEW tab. Wrap Text Allows for more than one line of text within a cell. Found on the HOME tab.
