GL19 U5 (Excel) CH02 Read and Learn Lesson

In the example =IF(A10<B2, 100, 1), the formula displays _____ if the value in cell A10 is less than the value in cell B2.

100

In Excel, which of the following formulas will return a result of 31?

3+7*4

Suppose that cell A1 contains a value of 20 and cell A2 contains a value of 35. The formula for obtaining the sum of these two cells is

=A1+A2.

To clear the cell formatting while leaving the cell contents alone, use the _____ option.

Clear Formats

According to the standard order of operations, the formula =10+16/2 will return a result of 13.

F

Changing a cell's contents will also change its formatting.

F

If you don't know the name of a function you need, you must search for it in Excel Help or online and then type the correct name into the formula.

F

The TODAY function displays all the entries made on the current date.

F

To insert a function, you can use buttons in the Library group on the Functions tab.

F

When you move a formula, relative references automatically adjust.

F

You can sort a range of data to temporarily display rows that meet certain criteria.

F

You can enter a formula by typing the formula directly into a cell or by using the

Formula bar.

What does the Show Formulas feature do?

It displays all the formulas on a worksheet at once.

What does selecting a cell and then clicking the Clear All option do?

It removes the cell contents and formatting.

The AutoSum feature provides a quick way to enter commonly used functions into a formula, including all of the following functions except

PMT

Absolute cell references in a formula are indicated by dollar signs.

T

If you print a spreadsheet when the Show Formulas feature is active, the formulas will print but the cell contents will not.

T

To paste a horizontal set of data so that it is positioned vertically instead, use the _____ option.

Transpose

If you need to include multiple arguments - such as multiple cell addresses or ranges or other values - within a function, add _____ between the arguments.

a comma

If you need to include multiple arguments within a function, add _____ between the arguments.

a comma

When you complete a cell entry containing a formula, the _____ displays within the cell.

calculated result

When sorting data, the key sort column is the

column that the sort is based on.

When including multiple arguments in a function, add a(n) _____ between arguments.

comma (,)

In the formula =SUM(B1:G1), SUM is the _____ and (B1:G1) is the _____.

function; argument

What type of cell reference automatically adjusts when you copy or move a formula to a different cell?

relative

If you want to sort data in a worksheet first by City and then by ZIP Code, you could sort a selected range based on the City column and then add the ZIP Code column as the _____ sort level.

secondary