excel 2

Created by XDRAWR 

Upgrade to
remove ads

50 terms · excel 2

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.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above 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.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set