Info Systems Possible Questions

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

$A$5

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60. Which of these functions will you insert in C2 cell to check if the student has passed or failed?

=IF(B2>=60, "Pass", "Fail")

Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. What is the formula used in cell C2, which can be copied down to cell C3 through C5, to generate the results shown below? *

=IF(B2>=E2, "Accept", "Reject")

In the formula =B6*$B$2, which of the following describes $B$2?

Absolute cell reference

Which area of corporate law is connected to technology?

All of the above

Big data does not refer to

Datasets with fewer than a billion records

A data warehouse is composed of

Historic and current internal data

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

IF

You work for a retail clothing chain whose primary outlets are in shopping malls, and you are conducting an analysis of your customers and their preferences. You wish to find out if there are any particular activities that your customers engage in, or the types of purchases made in the month before or after purchasing select items from your store. To do this, you will want to use data mining software that is capable of...

Identifying sequences

In a complex formula, how does Excel determine which calculation to perform first?

It follows the order of operations

Technology experts in the area of process design:

Leverage technology to make firms more efficient

A company uses radio frequency identification (RFID) tags to keep track of its inventory. This is an example of the impact of technology in the area of _____.

Operations

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

SUM

You have been asked to implement enterprise software for a manufacturer of kitchen appliances. What is the first step you should take?

Select the business processes you wish to automate

Select the accurate statement(s). 1) The world's most valuable retailer, China's Alibana, also carries the world's largest product inventory. 2) Uber, the world's largest taxi service, owns no vehicles for hire. 3) Airbnb, the world's largest accommodation provider, owns several major hotel corporations 4) Facebook does not create media content.

Statements 2 and 4 are accurate

You have been hired by a worldwide non-profit agency to implement a system to handle their donations. The system must be able to handle and record telephone, sms, and Internet donations, provide up-to-the-minute reports, and create highly customizable mailing lists. In addition, event fundraisers need to be able to quickly access a donor's information and history. Which of the following systems will best meet these needs?

TPS with MIS capabilities

Some of the radical changes brought about by new technologies include:

The creation of an unprecedented set of security and espionage threats

Experts working in the area of _____ work to make sure systems are easy to use, while people working in the area of _____ work to leverage technology to make firms more efficient.

User-interface design; process design

Technology experts in the area of user-interface design:

Work to make sure systems are intuitive and easy to use

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of...

classification

Data cleansing not only corrects errors but also

enforces consistency among different sets of data

Data mining is a tool for allowing users to...

find hidden relationships in data

A DBMS makes the

physical database available for different logical views

A nationwide magazine publisher has hired you to help analyze their social media datasets to determine which of their news publications are seen as the most trustworthy. Which of the following tools would you use to analyze this data?

sentiment analysis software