A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.

A function that determines how many cells in a range contain a number

A function that returns the number of cells in the selected range that contain text or values, but not blank cells.

A function that counts the number of blank cells in a range.

A predefined formula that performs a calculation

A function that returns the largest value in a set of values

Two or more cells combined into a single cell.

A function that determines the minimum value in a range of cells

A function that totals all of the cells in a range.

Arrange in a line or bring into alignment.

A formatting characteristic, such as bold, italic, or underlined text.

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed

A set of text properties that affects the typeface, size, and similar aspects of text.

A feature found in most Office applications that allows you to quickly copy formatting attributes that you have already applied and “paint” those attributes onto other text, shapes, pictures, and worksheet cells

A shortcut that enables you to navigate to a web page or a location in another file in just one click of the mouse.

Two or more cells combined into a single cell.

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

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 more

A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more.

A set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually.

To automatically display data on the next line when it is too long to display within the cell’s width. Wrapping automatically increases a cell’s height.

Which of the following commands is used to insert a cell into a worksheet?

Which of the following can you not copy using Format Painter?

When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right.

After you select a color and apply it to a cell’s background, the Fill Color button takes on that color

1. The COUNT and MIN functions are examples of which category of functions?

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

The MIN function returns the smallest value in a range of cells.

The COUNT function returns the total number of cells in the selected range that contain both text and numbers

The Line between rows or columns

The identifying letter of a column

The left-to-right measurement of a column

A predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook

Something that modifies the appearance of an object

Lines of text that appear at the bottom of each page

The lines that display around worksheet cells

A line of text that appears at the top of each page of a printed worksheet

The position of the content in a worksheet, so that it prints either vertically or horizontally on a page

A divider that breaks a worksheet into separate pages for printing

An Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document

An Excel view that enables you to see what your document will look like before sending it to the printer

The identifying letter of a row

The top-to-bottom measurement of a row

Shrinking or stretching printed output to a percentage of it actual size

Changes your cell data to change orientation

Text or a picture that appears in the background of a document; it is similar to a sheet background in Excel

The empty area of a document in which no content appears

To Prevent portions of a worksheet from moving on the screen. When you freeze panes.

To make a worksheet invisible

Pre-set settings that determine how Excel behaves when performing an action

Commands on the default ribbon tabs that are related in functionality.

A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.

Several settings that enable you to change how a document prints

(1) An area on the ribbon that contains groups of related commands. (2) An area of the Backstage navigation pane that contains groups of related commands.

A file that includes formatting and formulas complete with designs, tools, and specific data types.

A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.

Operators that specify the calculations to be performed

A reference that identifies a cell’s location in the worksheet based on its row number and column letter.

A number or text value entered directly into a formula.