Looking for Computer Science Homework Help?

When using a 3-D reference in a formula,first select the tabs for the source worksheets,then begin typing the formula.

True False

Answer:

Given the formula =IF(X4="NO","CHARGE","FREE"),when the value of X4 is NO,the formula result is FREE.

True False

Answer:

The VLOOKUP function looks up values in a table and then inserts those values in another location in a spreadsheet.

True False

Answer:

When creating a VLOOKUP formula,the table range entry should be based on relative references so the formula produces correct results when copied to a new location.

True False

Answer:

In Excel,to calculate the cost of any loan,three pieces of information are needed.

True False

Answer:

To change the PMT function's result to a positive number,place a plus operator before the function name in the formula bar.

True False

Answer:

In the Error Checking dialog box,clicking the "Help on this error" button requires an Internet connection so that you can access Microsoft's online help.

True False

Answer:

The COUNTA function counts the number of cells in a range that are not empty.

True False

Answer:

The Insert tool on the Formulas tab includes the Logical category,which gives you access to a variety of logical functions.

True False

Answer:

The VLOOKUP function requires four pieces of information to perform its operations.

True False

Answer:

You can create an absolute cell reference by adding dollar signs to the column and row references in a formula.

True False

Answer:

To access the PMT function,click the Formulas tab,then in the Function group,click the Insert button,then click Financial.

True False

Answer:

The ____ tab contains an entire group dedicated to Excel's library of functions.

Multiple Choice

Answer:

The ____ function calculates the highest value found in its list of cell references.

Multiple Choice

Answer:

To determine the average score in a range of test scores,you should use the ____ function.

Multiple Choice

Answer: