Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)

1
Each row in a database includes related information and is known as a:
A)Category.
B)Record.
C)Row.
D)Line.
2
Database functions all follow the same syntax and have three:
A)Results.
B)Formulas.
C)Functions.
D)Arguments.
3
The database function that counts the cells in the field that are not empty and that meet the criteria is:
A)DCOUNTA.
B)DCOUNT.
C)COUNTIF.
D)ECOUNT.
4
Probably the most commonly used logical function is:
A)IF.
B)COUNT.
C)ROUND.
D)STDEV.
5
In an OR function, if any one of the arguments is true, the result is:
A)True.
B)False.
C)Inconclusive.
D)Circular.
6
A function within a function is described as:
A)Complex.
B)Dependent.
C)Secondary.
D)Nested.
7
When you accidentally make the error of typing the letter the letter "o" instead of a zero in a formula, Excel will display:
A)#ERROR!.
B)#VALUE!.
C)#LABEL!.
D)#NAME!.
8
This function displays the contents of the cell at the intersection of an identified column and row:
A)INTERSECT
B)ADDRESS
C)INDEX
D)AUTOFIND
9
A range of cells that you select in which to apply a function is called:
A)An objective.
B)A function range.
C)A target.
D)An array.
10
In a calculation, the difference between actual values and predicted values is called:
A)"distance."
B)"margin of error."
C)"deviation."
D)"derivation."
11
The one required argument in the SUMSQ function is:
A)MSE.
B)Number1.
C)FINDIF.
D)Square.
12
In a financial function, "nper" stands for:
A)New percentage rate.
B)Number of payments.
C)Nolo persona.
D)Non-negotiable percentage.
13
Like many financial functions, the PV function uses the concept of:
A)Compound interest.
B)Fixed rates.
C)Annuity.
D)Present value.
14
The text function allows you to join or combine up to 255 strings of text, values, or characters is called:
A)CONCATENATE.
B)Dual data display.
C)COMBINATIVE.
D)Value to Text.
15
The Standard Deviation functions are found in this category:
A)Financial
B)Forecast
C)Statistical
D)Math & Trig





To learn more about the book this website supports, please visit its Information Center.
Copyright (c)2014 McGraw-Hill Education .
Any use is subject to the Terms of Use and Privacy Notice | Report Piracy


Nordell, 1eOnline Learning Center

Home > Excel > Chapter 6 > Ch 6: Multiple Choice Quiz