Computer 8th Vocab Excel Vocab Test 1-9

The command used to place a copy of data from the selected cell or range on the clipboard

To command used to redo an action you have undone

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

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

order in which Excel performs mathematical operations specified in a formula.

A style that displays numbers with a thousands separator

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

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

A style that displays decimal numbers as percentages

A block of adjacent cells in a worksheet

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

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

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

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

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

can change in a copied formula, so the new address is expressed in relation to the cell containing the copied formula

A shortcut used to insert repeated information

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

Symbols used in mathematical operations

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

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

File hosting service than can be accessed from a Web browser and upload and sync files to a storage environment

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

this is the intersection of a column and a row on a worksheet. You enter data into this to create a worksheet

To see how a worksheet will look when printed

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

The feature that enables Excel to create a series automatically

The measurement of the typeface in points

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

An instruction Excel uses to calculate a result

An Excel file with one or more worksheets

method used to move or copy the contents of a range by dragging the border of selection from one location to another

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

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

Keyboard shortcuts for choosing ribbon commands that you display by pressing Alt

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

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

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

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

A typeface or design of the text

A format that controls how numerical data is displayed,

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

A tool used to assist you in finding and correction typographical errors

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

A button you click to restore a dialog box to its normal size after using the Collapse Dialog button.

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

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

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

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

To remove a cells contents and/or formatting

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

A new, empty workbook contains one worksheet (sheet)

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

a color that fills a cell, appearing behind the data

A collection of coordinated fonts, colors, and effects for graphic elements than can be quickly applied in a workbook

A block of cells in Excel worksheet

a document that contains formatting, styles, and sample text that you can use to create now docuements.

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

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 style that displays dollar signs immediately preceding the number and includes a thousands separator.

A style that vertically aligns dollar signs, thousands separators, and decimal points.

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

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

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

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

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