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 Questions with Complete Solutions

BITM 215 exam #1 Questions with Complete Solutions

BITM 215 Exam Guide Questions and CORRECT Answers consolidated worksheet - CORRECT ANSWER- combines data from multiple worksheets using a mathematical or statistical function A static data consolidation - CORRECT ANSWER- 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 - CORRECT ANSWER- on the Data tab in the Data Tools group. A dynamic data consolidation places - CORRECT AN...

BITM 215 EXAM #1 Questions with Complete Solutions

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

_________ 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

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

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