ECONOMICS,NURSING,BIOLOGY AND ALL REVISION MATERIALS

BITM SUNY ALBANY Review Test 2 Questions & Answers spreadsheet - ANSWERSelectronic file used to organize related data and perform calculations if data is altered - ANSWERSformulas automatically recalculate results worksheet - ANSWERSspreadsheet that contains formulas, value, text, and visual aids workbook - ANSWERSfile containing related worksheets worrksheet ROWS - ANSWERSHORIZONTAL NUMERIC worksheet COLUMNS - ANSWERSVERTICAL ALPHABETIC cell - ANSWERSthe intersection of...

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 study test questions & answers What is the purpose of a database? - ANSWERSis to keep track of things, databases store more complicated information that a simple list would What is the problem with lists? - ANSWERSRedundancy, because the same info may be inputed several times, -many themes going on at once what are some list modification issues? - ANSWERSdeletion problems, update problems, insertion problems what are relational databases designed to address? - ANSWERSMa...

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