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

BITM 215 Exam #2 Multiple Choice (The multiple choice section of the end of chapter questions) Questions Correctly Answered!!

BITM 215 Exam #1 Study Guide With Verified Solutions. Workbook - answerAn Excel file with one or more worksheets. cell - answerThe intersection of a column and a row in a worksheet. cell reference - answerThe column letter and the row number. Example: B12 range - answera rectangular group of cells such as A1:B3 label - answertext data in a worksheet that is not used in calculations value - answernumerical data in a worksheet Active Cell - answera selected worksheet cell that is ready for...

BITM 215 EXAM #1 Study Guide. • Database - answerCollection of data organized in a manner that allows access, retrieval, and use of that data • Data - answerCollection of unprocessed items. Text, Numbers, Images, Audio, Video • Information - answerProcessed data. Documents, Audio, Images, Video • Database software/Database Management System (DBMS) - answerprovides means to ensure that only authorized users access data at permitted times • Data Integrity - answerDefines the quali...

BITM 215 EXAM #1 Questions with Complete Solutions

BITM 215 exam #1 Questions with Complete Solutions

BITM 215 exam #1 Questions with Complete Solutions

_________ are small charts that appear in a single cell? A. Bar chart B. Column chart C. Sparklines D. Pie chart - C. sparklines _________ change(s) the appearance of cells based on user criteria. A. Sorting B. Filtering C. Structured references D. Conditional formatting - D. conditional formatting

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

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

BITM 215 exam 3 Questions and Complete Solutions Graded A+.