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

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

You want to apply a subtotal to a dataset containing names, departments, and salaries. What is the first step you need to do? (a) Filter the dataset by salaries (b) Select the function to be used for the subtotal (c) Insert new rows where you want the subtotal rows within the dataset (d) Sort the data by a field containing categories - (d): sort the data by a field containing categories

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

consolidated worksheet - combines data from multiple worksheets using a mathematical or statistical function A static data consolidation - places a non-changing result in the consolidation sheet. If the source data is edited, the consolidated sheet is not updated. The Consolidate button is located - on the Data tab in the Data Tools group. A dynamic data consolidation places - formulas in the consolidation worksheet. If the source data is edited, the consolidated sheet is automatically upd...

What is Grouping? - Selecting two or more worksheets so you can perform the same action at the same time. T/F: You must ungroup the worksheets if you want to perform a task only on one worksheet. - TRUE Data Entry - Entering labels, values, dates, and formulas Structural Changes - Inserting and deleting rows and widening columns. Formatting - Changing fonts, alignment, and number formats. Page Layouts - Inserting headers and changing page orientation.

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 every three digits on the left side of the decimal point, and two digits to the right of the decimal point. Negative values are preceded by a minus sign. Zero displays as $0.00

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

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