MIS FINAL 1

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

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

A) HTML or Hypertext Markup Language

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

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

A) SQL Server

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

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

A) thin- client application

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 )

B) D5>45

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

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.

B) It is license-free for most applications

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

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

C) Annuity

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

C) Cash flows are present payments or receipts

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__________. A) Customization B) Duplication C) Integration D) Customer acquisition

C) Integration

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

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

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

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

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

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

39. The five-component framework considers individuals who maintain the data and who support the networks of computers as ________ components.

people

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

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

A) Auto number

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

b) design view

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

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

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

c. 24

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

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

d) defined name