ITM Exam 1 Flashcards
How many input cells does a two-variable data table use?
A. 1
B. 2
C.3
4. Unlimited
2
Which of the following functions compares a value to a list and displays the result for the first match in the list?
A. MATCH
B. EXACT
C. SWITCH
D. INDEX
Switch
Which text file uses a character, such as comma or a tab, to separate the fields?
1. Formatted Text File
2. Delimited Text File
3. Fixed Width Text File
4. Variable Width Text File
Delimited Text File
Which of the following histogram output options creates the histogram chart?
1. New worksheet ply
2. Cumulative Percentage
3. Pareto Chart
4. Chart Output
Chart Output
Which of the following is a row mixed cell reference?
A. B2
B. $B$2
C.B$2
D.$B2
B$2
Which of the following functions controls which data in a range are included in the total?
A. VLOOKUP
B. SUMPRODUCT
C. SUMIF
D. SUBTOTAL
SUMIF
A _____ is a worksheet that illustrates past data and predicts future values in an Excel table and a chart
A. Moving Average
B. Goal Seek Sheet
C. Forecast Sheet
D. Histogram
Forecast Sheet
If the interest rate is an annual rate and the payments are monthly, what should you type after the cell address?
A./1
B./2
C./4
D./12
/12
How do text files separate data?
A. Fields
B. Cells
C. Records
D. Paragraphs
Fields
Consider the function =IF(C4>15000,5000,0) What is the value if true?
A. 15,000
B. 20,000
C. Answer is not given
D.10,000
Answer is not given
In the MATCH function, which match_type argument finds the smallest value greater than or equal to the lookup_value?
A. 1 or omitted
B. -1
C. 0
D. -2
-1
Which of the following is NOT a Solver parameter?
A. Constraints
B. Variable Cells
C. Objective Cells
D. Scenarios
Scenarios
Which of the following shows the correct syntax for the NPV function?
A. =NPV(value1,value2,….)
B. =NPV(value1,value2,rate)
C. NPV(rate,value1,value2,….)
D. =NPV(rate,value1,value2,….)
=NPV(rate,value1,value2,….)
Which of the following error values indicates that an incorrect data type is used?
A. N/A
B. DIV/0!
C. #VALUE!
D. #REF!
VALUE!
