# Excel Ch 2

## Unlock all answers in this set

question
A predefined formula is called a:
function
question
The values that an Excel function uses to perform operations are called:
arguments
question
Excel's ________ function finds the middle value in a range.
MEDIAN
question
Which Excel function would be used to find the middle value of a list of test scores?
MEDIAN
question
Which Excel function would be used to calculate the total points a student earned on a series of tests?
SUM
question
Excel's ________ function adds all of its arguments then divides the sum by the number of arguments
AVERAGE
question
The ________ function adds all of the numbers in a range of cells.
SUM
question
Excel's ________ function finds the largest value in a selected range of cells.
MAX
question
The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful when the user needs to analyze a group of measurements.
statistical
question
The Excel function ________ would be used to find the lowest score on a series of student test scores.
MIN
question
Use ________ to split data from two or more cells or to combine data from two cells.
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.
#
question
Functions that test for a specific condition are called ________ functions.
logical
question
IF is an example of a ________ function.
logical
question
The COUNTIF function takes two arguments:
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.
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".
COUNTIF
question
A value or expression that can be evaluated as true or false is called a:
logical test
question
Which of the following is an example of a logical test?
D5>45
question
The ________ function returns one value if a condition is met, and a different value if it is not.
IF
question
Values are evaluated using ________ operators.
arithmetic
question
The Excel operator for "not equal to" is:
<>
question
The Excel operator for "greater than or equal" to is:
>=
question
The Excel operator for "less than" is:
<
question
Using ________ allows a cell to change appearance based on criteria.
conditional formatting
question
A ________ provides a visual cue about the value of a cell relative to other cells.
data bar
question
Using ________ searches the spreadsheet for one value and replaces it with another.
Find and Replace
question
Excel's ________ function retrieves the date and time from the computer's calendar and clock.
NOW
question
A ________ is a portion of a worksheet window bound by, and separated from, other portions by vertical or horizontal bars.
pane
question
Using ________ enables you to select one or more rows or columns and lock them into place.
Freeze Panes
question
A function such as NOW that is updated each time a workbook is opened is said to be:
volatile
question
A range of cells can be converted into an Excel ________ so that the data can be analyzed.
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.
table
question
To ________ a table means to arrange all of the data in a specific order.
sort
question
You would ________ a table if you wanted to display only data that matches specific criteria.
filter
question
Using ________ enables you to stretch or shrink the width, height, or both of printed output.
Scale to Fit
question
You can move from one worksheet to another by clicking the:
sheet tabs
question
Dates can be treated as other numbers because Excel assigns a ________ value to the date as it is entered.
serial
question
The action of placing cell contents that have been copied to the Clipboard is:
pasting
question
When pasting a range of cells you only need to click or select the ________ of the paste area.