Site MapHelpFeedbackMatching Quiz
Matching Quiz
(See related pages)


Matching Quiz
1


Value of the cell (or cells) you wish to square and sum

2


Calculates the net present value of an investment using a discount rate and a series of future payments

3


Combines up to 255 strings of text, values, or characters in a single cell.

4


Returns the relative location of the data that matches the condition

5


Enables you to observe the effects of all edits in cells containing formulas without having to scroll through a large worksheet

6


Total number of periods or payments

7


Column used in a database calculation

8


Displays the smallest value in the field that meets the criteria

9


Totals the values in cells that meet the criteria.

10


Determines whether or not something is true or if more than one condition exists

Answer choices for questions 1 through 10
A)Number1
B)MATCH function
C)Watch Window
D)Field
E)CONCATENATE function
F)DMIN
G)Logical function
H)nper
I)NPV function
J)DSUM





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: Matching Quiz