question

A predefined formula is called a:

answer

function

question

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

answer

arguments

question

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

answer

MEDIAN

question

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

answer

MEDIAN

question

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

answer

SUM

question

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

answer

AVERAGE

question

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

answer

SUM

question

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

answer

MAX

question

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

answer

statistical

question

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

answer

MIN

question

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

answer

Flash Fill

question

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

answer

#

question

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

answer

logical

question

IF is an example of a ________ function.

answer

logical

question

The COUNTIF function takes two arguments:

answer

the range of cells to check and the criteria.

question

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

answer

COUNTIF

question

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".

answer

COUNTIF

question

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

answer

logical test

question

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

answer

D5>45

question

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

answer

IF

question

Values are evaluated using ________ operators.

answer

arithmetic

question

The Excel operator for "not equal to" is:

answer

<>

question

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

answer

>=

question

The Excel operator for "less than" is:

answer

<

question

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

answer

conditional formatting

question

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

answer

data bar

question

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

answer

Find and Replace

question

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

answer

NOW

question

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

answer

pane

question

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

answer

Freeze Panes

question

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

answer

volatile

question

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

answer

table

question

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

answer

table

question

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

answer

sort

question

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

answer

filter

question

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

answer

Scale to Fit

question

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

answer

sheet tabs

question

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

answer

serial

question

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

answer

pasting

question

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

answer

upper left corner

question

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

answer

group

question

A ________ displays and summarizes totals from other worksheets.

answer

summary sheet

question

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

answer

detail sheet