Bundle of BITM 215 Exams All with Questions and Correct Verified Answers

In a calculation, the difference between actual values and predicted values is called: - Forecast Error Which type of function would you use to format a value as a label? - Text In a financial function, nper stands for - number of payments Like many financial functions, the PV function uses the ...

T/F: If you change the order of your worksheets after entering a 3-D formula, your formula will be automatically altered. - FALSE What would you use a web query for in Excel? - To import sports scores into a spreadsheet. What is Metadata? - Pieces of data that describe other data. What is a Docu...

Which of the following is an Excel add-in? (a) Goal Seek (b) Solver (c) One- or two-variable data table (d) Scenario Manager - (b) Solver

what is depreciation? - decline in value of an asset payback period - length of time required for an investment to recover its initial cost what is VDB - amount of depreciation changes over time what is DB function - declining balance- asset declines by a constant percentage eac

Formula AutoComplete - A feature that speeds up the manual entry of functions. relative cell reference - A cell address such as B2 absolute cell reference - A cell reference with dollar signs such as $B$2 mixed cell reference - a cell reference that contains both relative and absolute references

What is the number format style? - A number with or without the comma separator and with any number of decimal places. Negative numbers can be displayed with parentheses and/or red What is the currency format style? - A number, the dollar sign immediately to the left of the number, a comma for ev...