MIS Final Exam
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
[Using MIS] _________ is the application of the statistical techniques to find patterns and relationships among data for classification and prediction.
A) Data optimization B) Database normalization C) Data mining D) Data warehousing C) Data mining
Which of the following views is used to modify the structure (metadata, data dictionary) of a table?
A) Datasheet View B) Design View C) Layout View D) Table View B) Design View
The top two ranked ERP vendors are ________.
A) Epicor and Oracle B) Oracle and SAP C) Microsoft Dynamics and Infor D) Microsoft Dynamics and SAP B) Oracle and SAP
Which of the following keys create a default chart sheet for selected data?
A) F5 B) F7 C) F9 D) F11 D) F11
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
Which command is used to move to a specific cell address?
A) Find B) Go To (Ctrl + G) C) Look D) Search B) Go To (Ctrl + G)
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
Which of the following is a valid observation of MySQL?
A) It is offered by Oracle B) It is a license-free for most applications C) It is a closed-source database product D) It is yet to be widely adopted B) It is a license-free for most applications
The forked lines on the right side of a line on an E-R diagram that indicates a 1:N relationship between two entities is referred to as _______
A) Kerberos B) maximum cardinality C) crow's feet D) minimum capacity C) crow's feet
Because of the various problems with operational data, large organizations choose to extract operational data and store them into a (n) _______
A) OLAP cube B) neural network C) data warehouse D) Web server C) data warehouse
[Database] A relationship is created between how many tables in minimum?
A) One B) Two C) Three D) Any Number B) Two
__________ is a term that came to be used when companies such as Google offered thin-client email such 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 a service B) Software as a service
[EXCEL Section] Which of the following functions adds or totals cells only if they meet the specified criteria?
A) REPLACEIFS function B) AVERAGEIFS function C) COUNTIFS function D) SUMIFS function D) SUMIFS function
__________ are the companies that operate the Social Media (SM) sites.
A) SM application providers B) SM sponsors C) SM client servers D) SM consultants A) SM application providers
_______ is an example of an Enterprise DBMS.
A) SQL Server B) DB3 C) Publisher 2013 D) Access A) SQL Server
Which of the following statements is true about consolidating data by category?
A) To consolidate data by category, begin with a copy of one of the source worksheets. B) On the copied sheet that you use to create the consolidation worksheet, delete the data cells to be consolidated including the labels. C) When you select the cell range on each supporting worksheet, you select the same range, including the top row labels D) all of the above D) all of the above
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
Push publishing delivers business intelligence ________.
A) according to a schedule or as a result of an event or particular data condition B) through reporting, data mining, and knowledge management C) by obtaining, cleaning, organizing, relating, and cataloging source data D) in response to requests from users A) according to a schedule or as a result of an event or particular data condition
A ___________ is a word or string or characters in Excel that represents 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
The primary purpose of an ERP system is _______.
A) customization B) duplication C) integration D) customer acquisition C) integration
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
Relational databases represents relationships using ___________.
A) foreign keys B) file systems C) metadata D) unique identifiers A) foreign keys
A data ________ is a data collection, smaller than the data warehouse, that addresses a particular department or functional area of the business.
A) mart B) mine C) cube D) model A) mart
Which of the following types 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
Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.
A) primary key B) identifier C) foreign key D) primary record A) primary key
The five-component framework considers individuals who maintain the data and who support the networks of computers as ________ components.
A) procedural B) people C) data D) networking B) people
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 status D) motivation and needs A) purchasing patterns
The COUNTIF function takes two arguments:
A) the range of cells to check and the criteria B) the range of cells to check and the filter C) the range of cells to check and sheet tab D) the range of cells to check and the pane A) the range of cells to check and the criteria
A client-server application that requires nothing more than browser is called a _______
A) thick-client application B) desktop application C) firmware D) thin-client application D) thin-client application
If you want to see how different interest rates and numbers 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
<H1> is a tag use in the ___________ section (Hint: Head or Body)
BODY
Which of the following functions counts the number of cells in a range based on specified criteria?
A) COUNTA B) COUNTBLANK C) COUNTIF D) DCOUNT C) COUNTIF
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
What is the syntax for an IF function?
A) =IF(logical_test) B) =IF(logical_test, value_if_false, value_if_true) C) =IF(logical_test, value_if_true, value_if_false) D) =IF(value_if_true, value_if_false) C) =IF(logical_test, value_if_true, value_if_false)
Which of the following is an example of a logical test?
A) =NOW() B) =D5>45 C= 6*8 D= SUM(B5:D5) B) =D5>45
