Computer 8 Excel Vocab Test

A method used to move or copy the contents of a range of cells by dragging and dropping it to another location.

A cell entry that indicates a date or time and is stored as a date code in Excel

A cell address that can change in a copied formula

A cell address in a formula that will not change when you copy the formula to another location.

A feature used to automate the correction of common typing errors

Descriptive text, such as page numbers, that appears at the bottom of every page of a printout

An instruction Excel uses to calculate a result

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

The measurement of the typeface in points (1 point =1/72 of an inch)

As you enter data in a cell, it simultaneously appears in the formula bar, which is located above the worksheet

A block of cells in an Excel worksheet

An Excel file with one or more worksheets

Shows you how a gallery formatting choice will appear in the worksheet when you move the mouse pointer over that choice

A Windows feature that holds data or graphics you cut or copy prior to pasting to another location

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

*

A style that vertically aligns dollar signs ($), thousands separators (,), and decimal points

A color that fills a cell, appearing behind the data

A tool that enables you to copy formatting from a cell and apply it to another cell or range

+

The command used to reverse one or a series of editing actions

A style that displays dollar signs ($) immediately preceding the number and includes a thousands separator (,).

Specific keyboard keys that you press together or in sequence to execute commands or apply settings

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

The feature that enables Excel to create a series automatically

Cells in a worksheet that act as a block, but are not necessarily adjacent to each other

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

The typeface or design of the text

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

^

A combination of a font, text color, cell color, and other font attributes applied to a single cell

A method to rearrange data by switching the positions of columns and rows

The location of a cell in a worksheet as identified by its column letter and row number, such as A1

A collection of coordinated fonts, colors, and effects for graphic elements that can be quickly applied to all sheets.

/

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

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

A number entered in the worksheet as a label, not as value- such as the year 2017 used as a column label

The active cell is the current cell. There is a green border around the active cell.

Descriptive text, such as page numbers, that appears at the top of every page of a printout

A feature that causes long cell entries to appear in multiple lines

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

A new, empty workbook contains one worksheet

An alphanumeric entry in a worksheet that is not a cell or range address

The command used to place a copy prior to pasting to another location

A style that displays decimal numbers as a percentage

Symbols used in mathematical operations

Enables you to automatically combine cells and center the contents of the original far left cell in the new cell

The order in which Excel performs the mathematical operations in a formula, based on the mathematical operators used

Text entered to identify the type of data contained in a row or column

A document that contains formatting, styles, and sample text that you can use to create new documents

A button in a dialog box that you click to downsize a dialog box to make a selection on the sheet

The command used to remove data from a cell or range of cells and place it on the Clipboard

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

A feature of Microsoft Office 2016 from which you access file and program management commands

A format that controls how numerical data is displayed, including the use of commas, dollar

The command used to place data from the Clipboard to a location on the worksheet

A file hosting service that allows you to upload a sync files to a virtual, or cloud, storage environment.

A green box on the lower-right corner of the selected cell or range that you can use to fill (copy) a series or formula

A block of adjacent cells in a worksheet

To remove a cell’s contents and/or formatting

To see how a worksheet will look when printed

A cell entry that consists of a number and numeric formatting only

The standard settings Excel uses in its software, such as column width or bottom alignment of text in a cell

A shortcut used to insert repeated information

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

-

To apply attributes to cell data to change the appearance of the worksheet

A built-in calculation used to add a range of values together

- The work area for entering and calculating data made up of columns and rows separated by gridlines

A button that you click to restore a dialog box to its normal size

The command used to redo an action you have undone