###
A value or expression that can be evaluated as true or false is called a logical test.

true

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

logical test

###
Using ________ allows the user to stretch or shrink the width, height, or both of printed output.

scale to fit

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

conditional formatting

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

SUM

###
Entering the year portion of a date as 40 will be interpreted as the year 2040.

false

###
The COUNTIF function takes three arguments.

false

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

sheet tabs.

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

COUNTIF

###
The IF function returns one value if a logical test is false and a different value if the logical test is true.

true

###
The MEDIAN function adds a group of values and then divides the sum by the number of items in the group.

false

###
A function is a predefined formula.

true

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

group

###
The Excel comparison operator for not equal to is < >.

true

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

upper left corner

###
Excel provides only one technique for changing the name of a worksheet.

false

###
Excel assigns a serial number to each date entered, which allows dates to be treated the same as other numbers in the worksheet.

true

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

NOW

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

serial

###
A ________ displays and summarizes totals from other worksheets.

summary sheet

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

#

###
The Excel operator for less than is

<

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

table

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

sort

###
Data within a cell can be displayed rotated to draw attention to the data.

true

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

pasting

###
A predefined formula is called a

function

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

table

###
MIN and MAX are examples of statistical functions.

true

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

MEDIAN

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

statistical

###
The data in an Excel table can only be sorted into ascending order.

false

###
Values are compared using ________ operators.

comparison

###
Excel's Print Titles command allows the user to specify rows and columns that will repeat on each printed page.

true

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

MAX

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

logical

###
In Excel, data can be moved from one area to another using the mouse and a technique called drag and drop.

true

###
Each worksheet in a workbook must have the same headers and footers.

false

###
COUNTIF is an example of a logical function.

false

###
Logical functions are used to test for specific conditions.

true

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

D5 > 45

###
The Excel operator for not equal to is

<>

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

data bar

###
>, >=, and = are examples of conditional operators.

false

###
IF is an example of a statistical function.

false

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

AVERAGE

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

MIN

###
The target destination for data that has been cut or copied using the Office Clipboard is called the paste area.

true

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

Find and Replace

###
Excel's Paste Options gallery does not include Live Preview.

false

### Please allow access to your computer’s microphone to use Voice Recording.

## We can’t access your microphone!

### Click the icon above to update your browser permissions and try again

Example:

### Reload the page to try again!

Reload

## Press Cmd-0 to reset your zoom

## Press Ctrl-0 to reset your zoom

### It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

## Your microphone is muted

### For help fixing this issue, see this FAQ.