# Emerge with Computers

Computing

## Quiz 96 :Functions Looking for Computer Science Homework Help?

## 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   