Chapter 1 excel

Range

A _____ is a block of cells in an excel worksheet.

Theme

A _____ is a collection of coordinated fonts, colors, and effects that can be applied to a workbook.

Series

A _____ is a list of sequential numbers, dates, times, or text.

Relative

A _____ reference is a cell address in formula that CAN change when you copy the formula to another location.

Value

A cell contains a _____ when its first character begins with either a number or one of the following (+,-,=,$).

Absolute

An _____ reference is a cell address in formula that WILL NOT change when you copy the formula to another location.

Mixed Cell

An example of a _____-_____ reference is A$5.

Keyboard

Combinations of two or more keys pressed together or in sequence to preform many commands in excel are called _____-Shortcuts.

Portrait

Excels default page orientation is _____.

Label

If you enter an alphabetical character or a symbol as the first character in a cell, you are entering a _____ or text.

Range

The _____ A1:A3 consists of cells A1, A2, and A3.

SUM

The _____ function adds the values in the specified cells or range together.

General

The default cell format in excel is _____.

Auto Fill

The feature or process for creating a series in excel is called _____-_____.

Page Layout

The view used to view data as it will look when printed is _____-_____.

Increase Indent

To add space at the left end of the cell with left-aligned entries, use the _____-_____ button.

Show Formulas

To display formulas in cells rather than formula results, use the _____-_____ command

Hide

To hide columns or rows temporarily, right-click the heading and click _____.

Wrap Text

Use the _____-_____ feature to wrap the text to multiple lines.

Header

When you want to repeat the same information at the top of each printed page, create a _____.

Percent

_____ format displays decimal numbers as a percentage.

Currency

_____ format displays dollar signs immediately preceding the number and includes a thousands separator.

comma

_____ format displays numbers with a thousands separator (,).

Accounting

_____ format is a style that vertically aligns dollar signs ($), thousands separator (,) & decimal points.

formula

a _____ is a worksheet instruction that performs a calculation.