Question 1 of 20 5.0 Points
This is the calculation investors use to determine whether an investment made today is more valuable than alternative choices, such as holding their money in a savings account, or investing it in other types of securities.
A. FV
B. RATE
C. PV
D. NPV
Question 2 of 20 5.0 Points
When using VLOOKUP and HLOOKUP functions, if the value being searched for is less than the lowest number in the table, the program will indicate this by returning:
A. 00.
B. 000.
C. NA.
D. #NA.
Question 3 of 20 5.0 Points
If cell H12 displays a value of -6.89, what is the absolute value of that cell location? (ABS(H12))
A. -6.89
B. 6.9
C. 6.89
D. 7.0
Question 4 of 20 5.0 Points
When creating a database, Excel will:
A. duplicate the values in the first entry for each entry.
B. automatically format each entry based on your first entry.
C. automatically create a function to total numerical values.
D. delete each previous entry when you add a new entry.
Question 5 of 20 5.0 Points
If the value in cell C11 is -23.7, =ABS(C11) will return the value of:
A. 24.
B. -24.
C. 23.7.
D. -23.7.
Question 6 of 20 5.0 Points
=INT(27.3) will return the value of:
A. 81.
B. 27.
C. 24.
D. 9.
Question 7 of 20 5.0 Points
Statistical functions include the following:
A. DAY, TIME, WEEKDAY.
B. AVERAGE, COUNT, MEDIAN.
C. CONCATINATE, DOLLAR, EXACT.
D. ISBLANK, ISERROR, ESEVEN.
Question 8 of 20 5.0 Points
In using the RAND function, when is the random value calculated?
A. every time the worksheet performs a new calculation
B. when you enter the function into a formula
C. whenever the user requests it
D. once a week
Question 9 of 20 5.0 Points
__________ is a statistical function.
A. FORECAST
B. INT
C. SYD
D. SQRT
Question 10 of 20 5.0 Points
__________ is a depreciation function.
A. FORECAST
B. INT
C. SYD
D. SQRT
Question 11 of 20 5.0 Points
The __________ function predicts the next value in a series.
A. ABS
B. FORECAST
C. GROWTH
D. MIRR
Question 12 of 20 5.0 Points
__________ is different from the Decrease Decimal button (or Increase Decimal button) because it eliminates all values to the right of the decimal places specified.
A. RATE
B. AMORTIZE
C. ROUND
D. SLN
Question 13 of 20 5.0 Points
The __________ function is used to calculate the amount of payment on a mortgage or loan obligation.
A. PMT
B. SLN
C. MTG
D. PFV
Question 14 of 20 5.0 Points
If you want numerical values in a database to appear from low to high, you would use:
A. the SUM function.
B. the Sort Ascending button.
C. the Sort Descending button.
D. the TOTAL function.
Question 15 of 20 5.0 Points
This function computes depreciation for an asset using the double-declining-balance method.
A. FV(rate,nper,pmt,pv,type)
B. IF(logical_test,value_if_true,value_if_false)
C. DDB(cost,salvage,life,period,factor)
D. FORECAST (x,known_y's,known_x's)
Question 16 of 20 5.0 Points
This function returns the minimum value found in specified ranges or a list of cells separated by commas.
A. RANGE
B. MIN(values)
C. MIN(list)
D. MIN(range)
Question 17 of 20 5.0 Points
Using the AutoFilter function allows you to:
A. find specific data in a spreadsheet.
B. filter out certain values in a database.
C. filter out automatically created formulas.
D. recover your most recently saved file.
Question 18 of 20 5.0 Points
Integer portion of value is a __________ function.
A. logical
B. depreciation
C. statistical
D. mathematical
Question 19 of 20 5.0 Points
__________ is a finance function.
A. ABS
B. DDB
C. VARP
D. NPER
Question 20 of 20 5.0 Points
Which of the following is NOT one of the three common database activities?
A. Creating a database
B. Compiling records
C. Sorting records
D. Filtering records
