Question 20 of 20 5.0 Points

__________ is a depreciation function.

• A.FORECAST
• B.INT
• C.SYD
• D.SQRT

Accounting Spreadsheet Fundamentals Lesson 3 Question 1 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 2 of 20 5.0 Points Integer portion of value is a __________ function. A. logical B. depreciation C. statistical D. mathematical Question 3 of 20 5.0 Points __________ is a finance function. A. ABS B. DDB C. VARP D. NPER Question 4 of 20 5.0 Points The function IRR: A. approximates the internal rate of return for a series of cash flows. B. returns an error. C. computes the modified internal rate of return. D. computes the interest rate per period required to make a present investment. Question 5 of 20 5.0 Points The function that calculates straight line depreciation is: A. DEPR. B. DDB. C. SYD. D. SLN. Question 6 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 7 of 20 5.0 Points __________ is a statistical function. A. RATE B. DDB C. FORECAST D. RAND Question 8 of 20 5.0 Points =INT(27.3) will return the value of: A. 81. B. 27. C. 24. D. 9. 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 mathematical function. A. ABS B. DDB C. VARP D. NPER Question 11 of 20 5.0 Points The function SQRT (9) returns a value of: A. 9. B. 3. C. 27. D. 18. Question 12 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 13 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 14 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 15 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 16 of 20 5.0 Points NOW will return the date and time, based on the computer's clock, at the time the function is executed. __________ will only return the date. A. DATE B. TODAY C. PRESENT D. DAY Question 17 of 20 5.0 Points __________ represents the number of periods for annuity or amount to reach future value. A. RATE B. FV C. PMT D. NPER Question 18 of 20 5.0 Points The function SUM: A. is sometimes used to display long division. B. summarizes key data in a spreadsheet. C. is used to add the values of two or more cells. D. will only add positive numbers. Question 19 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 20 of 20 5.0 Points __________ is a depreciation function. A. FORECAST B. INT C. SYD D. SQRT