Bitm Study guides, Class notes & Summaries

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

Workbook - An Excel file with one or more worksheets. cell - The intersection of a column and a row in a worksheet. cell reference - The column letter and the row number. Example: B12 range - a rectangular group of cells such as A1:B3 label - text data in a worksheet that is not used in calculations value - numerical data in a worksheet

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

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

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

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

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

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

Activity 3.2.5 Orbital Mechanics Modeling Introduction Aerospace engineers design satellite orbits to suit the unique requirements of the mission. The orbit is described with six parameters to cover an area on the ground aligned with the mission. In this activity you will apply your knowledge of orbital mechanics to describe the orbit of a satellite based on its ground trace. You will also use Analytical Graphics, Inc. (AGI) Orbit Tuner application within the Satellite Tool Kit software t...

NASM CES Final Exam ACTUAL EXAM QUESTIONS AND CORRECT DETAILED ANSWERS [ALREADY GRADED A] what is the process by which a tight muscle diminishes neural drive and inhibits recruitment of its functional antagonist? - ANSWER-Altered reciprocal inhibition what is the process whereby a synergist compensates for a prime mover to maintain force production? - ANSWER-synergistic dominance what motions occur at the knee during lower extremity supination? - ANSWER- extension, abduction, extern...