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
