Excel

an excel document is called a

The individual pages of an Excel document are called

A ________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.

A ________ is created when a row and a column intersect

In the ________ you can enter a value or a formula or edit a value or formula in the active cell.

A ________ identifies a worksheet in a workbook

The ________ displays the name of the selected cell, table, chart, or object

The Current cell mode, the page number, and the view and zoom button display on the

Anything you type into a cell is referred to as

A text value is also referred to as a

The ________, when outlined in black, indicates it is ready to accept data.

________ generates and extends a series of values into adjacent cells based on the values of other cells.

The ________ feature fills in the remaining characters of a word if what is typed matches an existing entry in the column

The small black square in the lower right corner of a selected cell is called the

A group of items that come one after another in succession is called

Two or more cells that Excel treats as a single unit is called a

The data you see in a cell is called the

The Formula Bar displays the data known as the

A prewritten formula known as a (n) ________ looks at one or more values, performs an operation, and returns a value.

All Excel formulas begin with which symbol?

The result of a formula displays in the active cell, and the ________ itself displays in the Formula Bar.

Excel's ________ command creates one cell from the selected cells and centers the contents within the new cell

________ are defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

The ________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parentheses

To make data easier to understand, use a ________ instead of a table of numbers

Tiny charts embedded in cells that show a visual trend alongside the data are called

Labels that display along the bottom of a chart to identify the category of the data are called

On an Excel chart, the ________ identifies the patterns or colors that are assigned to all the categories in the chart.

Charted values that originate in a worksheet are called

A data marker, such as a column, dot, or pie slice on a chart, represents a single

In an Excel chart, a ________ is made up of related data points

________ shrinks the width and height of the printed worksheet to fit a maximum number of pages.

To widen a column to fit the cell content of the widest cell in the column, use

To center worksheet data horizontally and vertically on a page, use the ________ dialog box

Which is the Excel operator for multiplication

. Excel uses ________ to perform basic mathematical operations.

Which is the Excel operator for exponentiation?

Absolute cell references are indicated by using what symbol in the cell address?

A predefined formula is called a

The values that an Excel function uses to perform operations are called:

Excel's ________ function finds the middle value in a range.

A predefined formula is called a

The values that an Excel function uses to perform operations are called

Excel's ________ function finds the middle value in a range

Which Excel function would be used to find the middle value of a list of test scores

Which Excel function would be used to calculate the total points a student earned on a series of tests?

The Excel function ________ would be used to find the lowest score on a series of student test scores.

Excel's ________ function adds all of its arguments then divides the sum by the number of arguments.

The ________ function adds all of the numbers in a range of cells.

) Excel's ________ function finds the largest value in a selected range of cells.

The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful when the user needs to analyze a group of measurements.

Use ________ to split data from two or more cells or to combine data from two cells.

Functions that test for a specific condition are called ________ functions.

) IF is an example of a ________ function

The COUNTIF function takes two arguments

The ________ function counts the number of cells within a range that meet a certain criteria

If a column of data holds the letter grades for a class, the ________ function could be used to determine how many students had a grade of "A".

A value or expression that can be evaluated as true or false is called a:

Which of the following is an example of a logical test?

The ________ function returns one value if a condition is met, and a different value if it is not.

Values are evaluated using ________ operators.

The Excel operator for "not equal to" is:

The Excel operator for "greater than or equal" to is: