Emerge with Computers

Computing

Quiz 96 :
Functions

Quiz 96 :
Functions

Showing 1 - 20 of 47
Next Quiz
arrow
In Excel,all formulas are functions.
Free
True False
Answer:

Answer:

False

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

Answer:

False

arrow
Excel provides five different counting functions.
Free
True False
Answer:

Answer:

True

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