Bitm exam 2 - Study guides, Class notes & Summaries

E - ANS Projects in a Functional Organization have the following advantages: A) Maximum flexibility in the use of staff B) Individual experts can be utilized by many different projects C) Specialists in the division can be grouped to share knowledge and experience D) The functional division also serves as a base of technological continuity E) All of the above E - ANS Projects in a Projectized Organization have the following advantages: A) The PM has full line authority ove...

consolidated worksheet - ANS summarizes data from multiple sheets with a mathematical or statistical function source worksheet - ANS you create a consolidation sheet by copying one of these static data consolidation - ANS summarizes the data and displays a result on the consolidated sheet dynamic data consolidation - ANS places formulas on the consolidated sheet in an outline linking workbooks - ANS process of referring to data in another workb...

spreadsheet - ANS electronic file used to organize related data and perform calculations if data is altered formulas automatically recalculates results worksheet - ANS a spreadsheet that contains formulas, values, text, and visual aids workbook - ANS file containing related worksheets input area - ANS range of cells including data output area - ANS range of cells containing results cell - ANS intersection of a column and...

External Reference Syntax - ANS a reference to a cell or range of cells in another workbook. Precedent Cell - ANS Cells referenced by a formula in another cell Use Trace Precedents command to graphically display, using tracer arrows, the relationship between these cells and formulas Select the cell that contains the formula for which you will find the precedent cells Click Trace Precedents in the Formula Auditing group on the Formulas Tab PROPER function - ANS Ca...

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

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...

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...