BITM 215

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED Spreadsheet an electronic file used to organize related data and perform calculations Worksheet a spreadsheet that contains formulas, values, text, and visual aids Workbook a file containing related worksheets - identified by a sheet tab Active Cell Represented by black/dark border, cell you are currently working on What are two of the basic components of a spreadsheet? Workbooks and worksheets Formula Bar The contents ...

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED Comma-separated values (CSV) Uses commas to separate data into columns and a newline character to separate data in to rows Data model collection of related tables that contain structured data used to create a database; enables you to integrate data from multiple sources within a workbook data shaping the process of editing information from one or more data sources to desired parameters before importing into an application dat...

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED grouping -selecting 2 or more worksheets so you can perform the dame action at the same time, the worksheets will have identical structure and formatting -can group and ungroup What does grouping worksheets improve? -productivity, can perform data entry, structural changes (add,deleting,widening rows/columns), formatting page layouts, and printing -You can copy worksheets from one workbook to another Worksheet refrences Allo...

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED Alignment The position of data between the cell margins Auto Fill Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells Cell The intersection of a column and row Column Width The horizontal measurement of a column Fill Color The background color appearing behind data in a cell Fill Handle A small green square at the bottom-ri...

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED You used the Subtotal feature on a dataset containing states, major cities within each state, and populations. You intended to create one subtotal for each state; however, a subtotal row displays below each city. What caused this result? The At a change setting was City within the subtotal dialog box Why would you click the collapse outline symbol above a column of outlined data? You want to hide the detailed columns to focus on...

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED Accounting Number Format A number format that displays $ on the left side of a cell and formats values with commas for the thousands separator and two decimals Active Cell The current cell in a worksheet. It is indicated by a dark green border onscreen Alignment Placement of data within cell boundaries AutoComplete A feature that searches for and automatically displays any other label in that column that matches the letters ...

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED IOT Internet of things BRIC Brazil, Russia, India and China Blackstone Private equity company Product/Service (Solution) how will your business solve their problem. Students registered Spring 2017 2300+ The amount of prize money $15K Number of undeclared students. 43% Number of declared students. 57% Average success rate for restaurants 6+ years 20% Amount of restaurants that fail after 6 months Under 50% Compan...

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 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 dat...

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED DAY function =DAY(serial_number) MONTH function =MONTH(serial_number) YEAR function =YEAR(serial_number) DAYS function =DAYS(end_date, start_date) NETWORKDAYS function =NETWORKDAYS(start_date, end_date, [holidays]) YEARFRAC function

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED what is a visible cue that shows when a table is made? Drop down arrows for sorting are visible calculated fields formulas added to an existing table a structured reference contains column names from an existing table the order in which filters are applied matters false the order in which sorting fields are applied matters true conditional formatting changes the appearance of cells based on user criteria what is the PMT...