Excel Ch 2

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?

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.

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

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

) If a cell's width is too narrow to properly display the numeric contents of the cell, Excel displays a series of ________ symbols.

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:

The Excel operator for "less than" is:

Using ________ allows a cell to change appearance based on criteria.

A ________ provides a visual cue about the value of a cell relative to other cells.

Using ________ searches the spreadsheet for one value and replaces it with another.

Excel's ________ function retrieves the date and time from the computer's calendar and clock.

A ________ is a portion of a worksheet window bound by, and separated from, other portions by vertical or horizontal bars.

Using ________ enables you to select one or more rows or columns and lock them into place.

A function such as NOW that is updated each time a workbook is opened is said to be:

A range of cells can be converted into an Excel ________ so that the data can be analyzed.

An Excel ________ is a series of rows and columns that contain related data and is managed independently from other data in the worksheet.

To ________ a table means to arrange all of the data in a specific order.

You would ________ a table if you wanted to display only data that matches specific criteria.

Using ________ enables you to stretch or shrink the width, height, or both of printed output.

You can move from one worksheet to another by clicking the:

Dates can be treated as other numbers because Excel assigns a ________ value to the date as it is entered.

The action of placing cell contents that have been copied to the Clipboard is:

When pasting a range of cells you only need to click or select the ________ of the paste area.

By including worksheets in a ________, you can enter or edit data on them simultaneously.

A ________ displays and summarizes totals from other worksheets.

Changes made to the ________ affect the overall totals on the Summary worksheet.