Bitm 215 exam 2 - Study guides, Class notes & Summaries

BITM 215 Exam 2 Questions Solved 100% with Certified Correct Answers • Data consistency - all tables must contain the correct information • Interactive processing - allows users to access data in real time • Batch processing - requires transactions to be accumulated and then fed into computers in large batches • Dirty data - records containing errors

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 concept of a(n) - Annuity

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 Document Property? - An attribute that describes a file: - author's name, title, subject, company, creation date, revision date, keywords