Formatting Cells and Ranges
Arrange in a line or bring into alignment.
align
A predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook.
document theme
A portion of a divided window.
pane
A comparatively complex system that can store a large amount of related data, which requires a program to be able to assess and render that data.
database
The parameters of a function
arguments
A set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually.
style
The position of the content in a worksheet, so that it prints either vertically or horizontally on a page.
orientation
A command to help you search for certain content
Find command
A condition you specify to limit which records are returned when filtering data. The plural of criterion is criteria.
criterion
An efficient way to search for and insert a value in a cell when the desired value is stored elsewhere in the worksheet or even in a different workbook.
lookup functions
A tool that enables you to control specifically what you want to paste after using the Copy or Cut commands, such as cell content, formulas, values, formatting, and much mor
Paste Special
An Excel view that enables you to see what your document will look like before sending it to the printer
Print Preview
An Excel feature that allows you to make a worksheet appear bigger (zoom in) or smaller (zoom out).
zoom
Predefined formatting in Excel that enables you to apply an elaborate format that makes a table look sleek and professional.
quick format
A range of cells in a worksheet that contains related data and can be used by a lookup function.
table
A formatting tool that appears above or below the shortcut menu when you right-click a cell and that displays the most commonly used formatting commands
Mini toolbar
Text or a picture that appears in the background of a document; it is similar to a sheet background in Excel.
watermark
An Excel feature that allows you to add content to a text box and replace any matches Excel finds
Replace command
A feature in Excel that ensures data is entered correctly, before it is processed incorrectly.
table
Data in a table arranged in rows and columns.
table array
An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.
conditional formatting
A line of text that appears at the top of each page of a printed worksheet.
header
To prevent portions of a worksheet from moving on the screen. When you freeze panes, such as a row of column headings, the column headings remain visible as you scroll down the worksheet or change magnification
freeze
One of the ways to filter a table so that it shows only records containing a certain object. A slicer is a selection panel that floats above a worksheet (the way a chart does).
slicer
A formula in which the result is determined by the presence or absence of a particular condition.
conditional formula