ECONOMICS,NURSING,BIOLOGY AND ALL REVISION MATERIALS

BITM Chapter 1 Exam Questions & Answers Database - ANSWERS-A structured collection of similar data -Data organized and stored on a computer that can be searched and retrieved -Dynamic Site: Real Time Updates Data - ANSWERSCollection of unprocessed items -Text -Numbers -Images -Audio/Video Information - ANSWERSProcessed Data -Documents Advantages of using Databases - ANSWERS-Store and retrieve large quantities of info -Enable information Sharing -Provide data centralizat...

BITM Exam 1 Intro to Databases Questions & Answers simulation - ANSWERSthe imitation of the operation of a real world process overtime What is a database? - ANSWERS- A structured collection of similar data -Data organized and stored on a computer that can be searched and retrieved -Dynamic Site: Real time updates Database - ANSWERSCollection of data organized in a manner that allows access, retrieval and use of the data ** allows actual usage of the data Data - ANSWERSCollection...

BITM Exam 1 Questions Grade A+

BITM Excel exam chapters 1-5 questions & answers Cells content is generally classified as - ANSWERSa DATA or as a FORMULA. =SUM(1,2) - ANSWERSFormula that includes its own data =A3+A4+A5+A6 - ANSWERSFormula using Cell References. =SUM(A1:A4) - ANSWERSFORMULAS USING A RANGE RELATIVE reference - ANSWERSis the default method of referring to a cell: A1, B2, C3, etc. When formulas are moved or copied and pasted, the formulas are adapted to their new RELATIVE position. No DOLLAR S...

BITM Exam 2 Questions Grade A+ Range rules - ANSWERSmust contain 2-5 characters cannot contain spaces cannot use special symbols can't start with a number new name dialog box - ANSWERSused to name a specific range Data table - ANSWERSOrganizes the results of several what if analysis step value - ANSWERSindicates the distance between cells PMT - ANSWERSrefers to loans and loan payments Goal-seeking analysis - ANSWERSa what if analysis command that tests values in a cell ...

BITM Excel Exam 1 Ch 1-4 Questions & Answers

BITM 330 Final Review Exam Questions & Answers

BITM Exam 3 : Set 3 Questions & Answers Customizing Excel - ANSWERSthink of Excel Options dialog box as the control center Excel Options dialog box - ANSWERSpermits you to change a variety of settings contained in the options category - general - formulas - proofing - save - language customizable excel options - ANSWERS- color scheme - formula rules - automatic corrections - autocomplete rules - items display onscreen Set the User Name - ANSWERSYou use this feature to iden...

BITM exam 2 study questions with 100% correct answers consolidated worksheet - ANSWERSsummarizes data from multiple sheets with a mathematical or statistical function source worksheet - ANSWERSyou create a consolidation sheet by copying one of these static data consolidation - ANSWERSsummarizes the data and displays a result on the consolidated sheet dynamic data consolidation - ANSWERSplaces formulas on the consolidated sheet in an outline linking workbooks - ANSWERSprocess of ...

BITM Exam 2 Questions with 100% Correct Answers Range Name - ANSWERSA range name is a word or string of characters assigned to one or more cells. Think of range names in this way: Your college identifies you by your student ID; however, your professors call you by your name, which is easier to remember, such as Miles or Ingrid. Another benefit of using range names is that they are absolute references, which helps ensure accuracy in your calculations when they are copied. Range Name Rules...

BITM 331 Test 1 Questions & Answers 2025/2026 system boundary - ANSWERSmanual part of the system - tasks completed by the people Automation boundary - ANSWERSautomated part of the system - tasks completed by the computer business analyst - ANSWERSperforms activities in support of business operations, strategy, and vision system analysis - ANSWERSthose activities that enable a person to **understand and specify** what an information system should accomplish system design - ANSWER...

BITM EXAM 1 QUESTIONS WITH 100% CORRECT ANSWERS Workbook - ANSWERSMultiple sheets you group your work into Cell - ANSWERSSmall boxes where you put content Formula bar - ANSWERSWhat is typed (formulas/raw data) that appears in the active cell Cell reference - ANSWERSHow to refer to the cell (A1) Name box - ANSWERSName for the cell (rent) Range - ANSWERSSeries of contiguous (adjacent) cells Formula - ANSWERSManipulation of a variable Alignment - ANSWERSVertical & horizont...

BITM Exam 2 Questions with Complete Solutions E - ANSWERSProjects in a Functional Organization have the following advantages: A) Maximum flexibility in the use of staff B) Individual experts can be utilized by many different projects C) Specialists in the division can be grouped to share knowledge and experience D) The functional division also serves as a base of technological continuity E) All of the above E - ANSWERSProjects in a Projectized Organization have the following advanta...

BITM Exam 1 Questions with Complete Solutions The core drivers of the Information Age - ANSWERSDate Information Business intelligence Knowledge Data - ANSWERSraw facts that describe the characteristics of an event or object Structured data - ANSWERSStored in a traditional system such as a relational database or spreadsheet Machine-generated data - ANSWERScreated by a machine without human intervention Human-generated data - ANSWERSdata that humans, in interaction with comput...

BITM Final Exam Ch 9-12 Questions & Answers 3-D formula - ANSWERSA formula or function that refers to the same range in multiple worksheets Data validation - ANSWERSRequires that rules be followed in order to allow data to be entered in a cell Dependent cell - ANSWERSA cell containing a formula that is dependent on other cells to obtain its value Destination file - ANSWERSA file that contains a pointer to the source file Error alert - ANSWERSA message that appears when the user...

BITM 215 Exam 1 Chapters 1-4 Questions & Answers Worksheet - ANSWERSA spreadsheet that contains formulas, functions, values, text & visual aids Workbook - ANSWERSA file containing related worksheets Name Box - ANSWERSIdentifies the address of the current cell Formula Bar - ANSWERSDisplays the contents stored in the active cell Sheet Tab - ANSWERSDisplays the name of a worksheet within a workbook Cell - ANSWERSThe intersection of a column and a row Output Area - ANSWERSA ra...

BITM exam 1 study guide questions & answers

BITM 215 Final Test Questions & Answers Grouping - ANSWERSProcess of selecting two or more worksheets to perform the same action at the same time Ungrouping - ANSWERSProcess od deselecting worksheets that were grouped Hyperlink - ANSWERSElectronic marker to another location in a worksheet, workbook, file, web page or email 3-D Formula - ANSWERSFormula that refers to the same cell or range in multiple worksheets Linking - ANSWERSProcess of connecting cells between worksheets or ...

BITM Exam 3 Questions & Answers 2025/2026 grouping/ungrouping data - ANSWERS-group rows or columns of related data into an outline -only creates an automatic outline if the data contains a formula subtotal data - ANSWERSpresents summary information that helps to analyze the data what to enter in subtotal dialogue box - ANSWERS1. at each change in: select area 2. function: select sum (most commonly used) 3. add subtotal to list: select fields you want to subtotal outline - ANSWER...

BITM 215 Exam 2 Questions & Answers 2025/2026 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 - ANSWERS(d): sort the data by a field containing categories Why would you click the collapse outline sy...