MIS

29. A_______ is a word or string of characters in Excel that represent a cell, a range of cells, a formula or a constant value. A) Cell range B) Table array C) Validation list D) Defined name

A) Cell range

34. A________ provides a visual cue about the value of a cell relative to other cells. A) Data bar B) Criteria C) Sheet tab D) Pane

A) Data bar

35. When using the PMT function to calculate payments, which of the following is NOT a required argument? A) Future value (Fv) B) Nper C) Principal D) Rate

A) Future value (Fv)

27. A method to find a specific value for a cell by adjusting the value of one other cell is: A) Goal Seek B) Lookup C) Protection D) Validation

A) Goal Seek

6. Which of the following is a valid observation of MySQL? A) It is offered by Oracle. B) It is license-free for most applications C) It is closed-source database product. D) It is yet to be widely adopted.

A) It is offered by Oracle.

16. Like many financial functions, the PV function uses the concept of: A) Mortgage B) Credit line C) Annuity D) None of the above

A) Mortgage

9. RFM analysis is used to analyze and rank customers according to their_______. A) Purchasing patterns B) Propensity to respond to a marketing stimulus C) Socio-economic states D) Motivation and needs

A) Purchasing patterns

32. The COUNTIF function takes two arguments: A) The range of cells to check the criteria. B) The range of cells to check and the filter. C) The range of cells to check and the sheet tab. D) The range of cells to check and the pane.

A) The range of cells to check the criteria.

28. If you want to see how different interest rates and number of months affect a monthly payment, you would use a: A) Two-variable data table. B) One-variable data table. C) Defined name D) Table array

A) Two-variable data table.

26. The process of changing the values in cells to see how those changes affect the outcome of formulas on a worksheet is called: A) What-If Analysis B) Goal Seek C) Validation D) Lookup

A) What-If Analysis

2. A data_______ is a data collection, smaller than the data warehouse that addresses a particular partment or functional area of the business. A) mart B) mine C) model D) cube

A) mart

14. A client-server application that requires nothing more than a browser is called a _________

A) thin- client application

24. Which of following types of files can be readily exchanged with various database programs? A) HTML or Hypertext Markup Language B) CSV or comma separated values C) TBL or table D) RGB or red green blue

B) CSV or comma separated values

19. Which of the following is a method to copy character formatting? A) Clear Format B) Format Painter C) Reveal Format D) Quick Format

B) Format Painter

38. Using _________ enables you to select one or more rows or columns and lock them into place. A) Drag and drop B) Freeze Panes C) Find and Replace D) Conditional formatting

B) Freeze Panes

3. ____________ is a term that came to be used when companies such as Google offered thin-client as Gmail for free, as a service. A) Platform as a service B) Software as a service C) Infrastructure as a service D) Cloud as service

B) Software as a service

37. The Office Clipboard holds up to _________ copied items. A) 50 B) 34 C) 24 D) 12

C) 24

5. The forked lines on the right side of a line on an E-R diagram that indicates a 1:N related...two entities is referred to as________. A) Kerberos B) Maximum cardinality C) Crow's feet D) Minimum cardinality

C) Crow's feet

10. _________ is the application of statistical techniques to find patterns and relationships among data classification and prediction. A) Data optimization B) Database normalization C) Data mining D) Data warehousing

C) Data mining

4. Major objects in an Access database include the following: A) Fields, Records, and Tables B) Fields, Records, and Queries C) Forms, Queries, Reports, and Tables D) Fields, Queries, Reports, and Tables

C) Forms, Queries, Reports, and Tables

11. The primary purpose of an ERP system is__________. (Enterprise resource planning): Process by which companies manage and integrates important parts of it's business A) Customization B) Duplication C) Integration D) Customer acquisition

C) Integration

31. Which of the following explains the symbols, textures, or colors used to differentiate data series? A) Axis B) Chart area C) Legend D) Plot area

C) Legend

12. Which of the following type of DBMS products is designed for smaller and simpler database applications? A) Object-oriented DBMS B) Strategic DBMS C) Personal DBMS D) Enterprise DBMS

C) Personal DBMS

21. In an Excel worksheet, what would result in cell C5 from =NOT(C4=10) if cell C4=11? A) 10 B) 11 C) TRUE D) FALSE

C) TRUE

18. What happens in the chart when underlying data is changed? A) A wizard starts to update the chart B) Sitting handles appear to resize the chart C) The chart updates automatically D) (COULDN'T DECIPHER THIS CHOICE)

C) The chart updates automatically

1. Because of the various problems with operational data, large organizations choose to extract data and store them into a(n)_________. A) OLAP cube B) neural network C) data warehouse D) Web server

C) data warehouse

*3 DDL (data definition language)

Create Table Alter Table Drop Table

33. Which of the following is an example of a logical test? A) =NOW (0) B) D5>45 C) 6*8 D) =SUM ( B5: D5 )

D) =SUM ( B5: D5 )

13. ________ is an example of an Enterprise DBMS. A) SQL Server B) DB3 C) Publisher 2013 D) Access

D) Access

25. Which of the following keys create a default chart sheet for selected data? A) F5 B) F7 C) F9 D) F11

D) F11

20. Which of the following SmartArt graphic categorize would be used to show a timeline? A) List B) Pyramid C) Cycle D) Process

D) Process

36. Which of the following calculations can be viewed in AutoCalculate for selected cell range in an Excel worksheet? A) SUM and AVERAGE B) SUBTRACT and SUM C) AVERAGE and TODAY D) SUM and CALCULATE

D) SUM and CALCULATE

17. Which of the following functions adds or totals cells only if they meet the specified criteria? A) REPLACEDIF function B) AVERAGEIF function C) COUNTIF function D) SUMIF function

D) SUMIF function

7. Which of the following views is used to modify the structure (metadata, data dictionary) of a table? A) Database view B) Design view C) Layout view D) Table view

D) Table view

23. Which code would display a date like this: 10 April 2014? A) d mm yy B) d mmm yy C) dd mmm yyy D) dd mmmm yyy

D) dd mmmm yyy

22. A predesigned set of colors, fonts, lines, and fill effects that look good together and which can be applied across all Office 2013 applications is called x: A) layout B) design C) style D) theme

D) theme

*DML(Accesses)

Tblemployee Qryemployee Frmemployee Rptemployee

39. In addition to Datasheet View, objects can displayed in Design View. (T/F)

True

40. When you attend a business function for the purpose of meeting people and reinforce relationships, you are investing in your social capital.

True

*Relational Database

is a relationship between 2 tables.

*Virtualization

-Host Operating System = Runs one or more operating systems as applications -PC Virtualization = Personal computer hosts several different operating systems -Server virtualization = Server computers hosts other server computers, Make cloud computing feasible -Virtual desktop = Allows access from any computer a user has authorization to use

*4 types of relationship between 2 tables.

1 to 1 1 to many Many to 1 Many to many

*What is information?

1. Knowledge derived from data, and data are recorded facts or figures. 2. Data presented in a meaningful context. 3. Data processed by summing, ordering, averaging, grouping, comparing, or other similar operations. 4. "A difference that makes a difference"

*Four DBMS Operations

1. Read 2. Insert 3. Modify 4. Delete

8. Which of the following data types automatically generates a consecutive number? A) Auto number B) Memo C) Number D) Text

A) Auto number

All SQL ends with________.

;

30. In the Name Manager dialog box, defined names are listed by: A) Alphabetical order B) Length of the name with shortest first. C) The order in which they were named. D) Reverse order in which they were named.

A) Alphabetical order

*What is Firmware?

A= Computer software installed on read-only memory Printers, Print servers, Communication devices Coded like other software Can be changed and upgraded

*What type of SQL do we use to create table?

A= DDL (Data Definition Language)

*What is MIS? (5 component framework)

A= Five - Component Framework (hardware, software, data, procedures, people).

IT

A= Information technology(IT) 1.products 2.methods 3.investment 4.standards IT=Hardware + Software + Data

*What is the purpose of a Database?

A= Organize and keep track of things, keep track of multiple themes *Columns, also called fields Rows, also called records Characters, also called bytes

*What key word do we use to define primary key?

A= Primary_key

*If I deleted all the records from the table department, is the table department disappeared?

A= no, because delete is DML keyword, the only way to destroy or remove a table is the keyword from DDL called drop table.

*Which table are you going to remove first? Tbldepartment or tblemployee, and why?

A= we need to remove the dependent table tblemployee first, because if we removed the parent Tbldepartment first, we are in violation of the referential integrity rule.

*Can we use DDL to change the size of a table?

A= yes

*What keyword do I need to use to remove a table?

A=Drop table

*What are the major operating systems?

A=Windows, Mac OS, Unix, Linux, Symbian, Blackberry OS, iOS, Android, Windows RT

*Is open source software a viable alternative?

GNL = General Public License -Open Office -Firefox -MySQL -Apache -Ubuntu -Android -Cassandra -Hadoop

IS

IS= IT + People + Procedures

*Why is the difference between IT and IS important?

IT=Hardware + Software + Data You can buy IT, but can never buy an IS IS= IT + People + Procedures

*DML (data manipulation language)

Insert into.... values Delete from.... where Update.... set.... where Select x from....

*How many database objects is there on access?

Table, query, forms, reports

*Own Versus License

License = Rights to use specified number of copies, Limits vendor's liability Site License = Flat fee to install software products on all company computers or all computers at a specific site. Open source software = free usage license

*N:M

Many to Many

15. When using the NPV function which of the following statements is not true? A) For a year with neither a positive or negative cash flow, type a zero (0) for the ValueN argument. B) Cash flows amount can be negative or positive C) Cash flows are present payments or receipts D) The NPV Function has two required arguments

NPV = Net present value function C) Cash flows are present payments or receipts

Can insert, update, and delete be undone?

No

*SQL (Two types)

Structured Query Language: Data Definition Language Data Manipulation Language

*data Model

Things you want to keep track off

*What are the components of a Database Application System?

User > Database Application > DBMS (Database Management System) > Database

*Thick-Client

You are required to have a lot of software

*Thin-Client

Your computer only has