Bitm 215 exam - Study guides, Class notes & Summaries

BITM 215 PASSED Exam Questions and CORRECT Answers • Database - CORRECT ANSWER- Collection of data organized in a manner that allows access, retrieval, and use of that data • Data - CORRECT ANSWER- Collection of unprocessed items. Text, Numbers, Images, Audio, Video • Information - CORRECT ANSWER- Processed data. Documents, Audio, Images, Video • Database software/Database Management System (DBMS) - CORRECT ANSWER- provides means to ensure that only authorized users access da...

What is true of Goal Seek? A. You work forward, looking at the data present and determining best answer. B. You work forward, attempting to identify the optional solution. C. You work backward, starting at the outcome and backfill data to reach that outcome. D. You work backward, comparing multiple scenarios to identify the one that provides the best possible outcome. - ANS C. You work backward, starting at the outcome and backfill data to reach that outcome. (sometimes there is just...

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

BITM 215 Questions &Exam (elaborations) answers 100% satisfaction guarantee

You want to apply a subtotal to a dataset containing names, departments, and salaries. What is the first step you need to do? - ANS (d): sort the data by a field containing categories Why would you click the collapse outline symbol above a column of outlined data? - ANS (b): You want to hide the detailed columns to focus on the result column After creating a blank PivotTable, you click a field containing monetary amounts in the PivotTable Fields task pane. Where does Excel plac...

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

when do you use structured references? - w/ respect to tables with data ***must specifically name a data table what is the difference btwn a qualified and unqualified structured reference? - if you use a structured reference within a table, unqualified if you use a structured reference outside a table, fully qualified reference qualified has table name in formula what is analysis of variance used for? - Test to determine if samples of data were taken from the same population

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