Bitm 215 exam - Study guides, Class notes & Summaries

Database - Collection of data organized in a manner that allows access, retrieval, and use of that data • Data - Collection of unprocessed items. Text, Numbers, Images, Audio, Video • Information - Processed data. Documents, Audio, Images, Video • Database software/Database Management System (DBMS) - provides means to ensure that only authorized users access data at permitted times

BITM 215 Final Exam Questions with Complete Solutions

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.

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

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

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