# Emerge with Computers

Computing

## Quiz 96 :Functions

Showing 1 - 20 of 47
In Excel,all formulas are functions.
Free
True False

False

The MIN function is an example of a Database function.
Free
True False

False

Excel provides five different counting functions.
Free
True False

True

When using a 3-D reference in a formula,first select the tabs for the source worksheets,then begin typing the formula.
True False
Given the formula =IF(X4="NO","CHARGE","FREE"),when the value of X4 is NO,the formula result is FREE.
True False
The VLOOKUP function looks up values in a table and then inserts those values in another location in a spreadsheet.
True False
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
In Excel,to calculate the cost of any loan,three pieces of information are needed.
True False
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
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
A function is a pre-made formula that computes a value.
True False
The COUNTA function counts the number of cells in a range that are not empty.
True False
The Insert tool on the Formulas tab includes the Logical category,which gives you access to a variety of logical functions.
True False
The VLOOKUP function requires four pieces of information to perform its operations.
True False
You can create an absolute cell reference by adding dollar signs to the column and row references in a formula.
True False
To access the PMT function,click the Formulas tab,then in the Function group,click the Insert button,then click Financial.
True False
Which of the following choices is a valid SUM function?
Multiple Choice
The ____ tab contains an entire group dedicated to Excel's library of functions.
Multiple Choice
The ____ function calculates the highest value found in its list of cell references.
Multiple Choice
To determine the average score in a range of test scores,you should use the ____ function.
Multiple Choice