IST 310 Quizzes

Which error message means that no answer can be found?

#N/A

Moore's law states that computer chip performance per dollar doubles every __________ months.

18

The function =ROUND(247,-2) returns:

200

The function =EVEN(242.578) returns:

244

Which function returns the current date and time (and recalculates)?

=NOW()

What ebusiness model represents 80% of all online businesses and is typically more complex and requires greater security needs?

Business-to-business

In order to freeze columns A and B plus rows 1, 2, and 3, which cell should be active before applying the "Freeze Panes" command?

C4

Which phase of the SDLC takes all of the detailed design documents from the design phase and transforms them into the actual system?

Development

What is a common tool that is used to support visualizations and track KPIs and CSFs by compiling information from multiple sources?

Digital dashboards

The United States has many laws that prohibit the export of electronic waste to other countries.

False

The cell reference for the cell in the fourth column and fifth row of a worksheet is E5.

False

The default range_lookup type for the VLOOKUP and HLOOKUP functions is FALSE.

False

The formula =CHOOSE(3,"dog","cat","horse","pig") returns TRUE.

False

The formula =MATCH(40,{10,20,40,50},0) returns the value TRUE.

False

The formula =NOT(OR(FALSE,FALSE,TRUE)) will return a value of TRUE.

False

The formula =OR(AND(TRUE,FALSE),FALSE) returns TRUE.

False

United Airlines is the only airline that still uses the original automated baggage handling system at the Denver International Airport.

False

Automatic heat (i.e. temperature) sensor data from a critical piece of equipment in a company's manufacturing facility is an example of which type of data?

Machine-generated structured data

Which phase of the SDLC involves performing changes, corrections, additions, and upgrades to ensure the system continues to meet the business goals.

Maintenance

A PivotTable does not automatically refresh when the underlying data is updated or changed.

True

A slicer can be used to filter a PivotTable.

True

A worksheet's tab color can be changed, but the text color of the tab cannot be changed.

True

A worm spreads itself not only from file to file but also from computer to computer.

True

Business intelligence is one of the four most common extended ERP components.

True

Business process reengineering is the analysis and redesign of the workflow within and between enterprises.

True

By default, all cells are "Locked".

True

Choosing not to fire a sales representative who is underperforming because you know that he/she is experiencing family problems is a form of knowledge.

True

Data does not have to be in the form of a designated Excel table in order to use the Remove Duplicates tool.

True

Data does not have to be in the form of an official Excel table in order to use the Remove Duplicates tool.

True

Fault tolerance is the ability for a system to respond to unexpected failures or system crashes as the backup system immediately and automatically takes over with no loss of service.

True

For the Subtotal command to work properly, the related rows of data must be together (i.e. the data must be sorted).

True

In Excel, text that begins with a number is still considered text.

True

In a VLOOKUP formula with a TRUE lookup type, the first column in the lookup table that is referenced by the formula must be in ascending order to retrieve the correct values.

True

It is not possible to hide all of the worksheets in a workbook.

True

Operational decisions are considered to be structured decisions.

True

Slicers are used to filter the data in an Excel table.

True

The AVERAGEA function treats text as a 0.

True

The COUNT function ignores cells with text.

True

The IFERROR function allows the user to specify his/her own text when an error is encountered rather than returning the standard Excel error message.

True

The INDEX function allows data to be retrieved from multidimensional tables.

True

The NOW function returns the current date and time (and recalculates).

True

The REPLACE function removes all spaces from a text string except for single spaces between words.

True

The ROWS function return the number of rows in a reference.

True

The ROWS function returns the number of rows in a reference.

True

The Watch Window can be used to monitor the value in one or more cells.

True

The XLOOKUP function defaults to an exact match.

True

The benefits of cloud computing include cheaper costs to an organization for a system deployment and backup and maintenance maintained by the vendor.

True

The goal of ERP is to integrate all of the organizational systems.

True

The most common reason that systems fail is because the business requirements are either missing or incorrectly gathered during the analysis phase.

True

The question mark wildcard (?) specifies that a single character can be substituted.

True

The two key components of an ERP system are a common data repository and a modular software design.

True

Three-dimensional printing promotes mass customization, small production batches, and a reduction in inventory.

True

What value will be returned by the following formula? =AND(TRUE,NOT(FALSE),80>=60)

True

What value will be returned by the formula displayed below? =OR(13<15,MAX(8,12,5,15,6)<10,20<=14+5)

True

When a workbook is protected, users cannot insert, delete, or rename worksheets.

True

The RAND function returns a random number between 1 and 10.

False

The ISBLANK function returns either YES or NO.

False

The LOOKUP function cannot be used when the lookup_vector is horizontal and the result_vector is vertical.

False

The Quick Access Toolbar can be customized, but the Ribbon can not be customized.

False

What is a sniffer?

A program or device that can monitor data traveling over a network

A click-and-mortar business operates only on the Internet without any physical stores.

False

A cold site is a separate and fully equipped facility where the company can move immediately after a disaster and resume business.

False

Analytical CRM focuses on business operations such as sales and marketing.

False

Assume that cell B1 has the text "mark r. best" typed into it. The formula =UPPER(B1) would return the text "Mark R. Best".

False

Authentication is the process of providing a user with permission including access levels and abilities such as file access, hours of access, and amount of allocated storage space.

False

Excel's "Goal Seek" tool can handle up to ten changing input values at the same time.

False

If cell A1 contains the text JAYHAWK, the function =MID(A1,4,4) returns JAYH.

False

In Excel, "n=" means not equal to.

False

In Excel, >= means less than or equal to.

False

It is a scientific fact that facial appearance is a reliable predictor of character.

False

It is not possible to create a PivotTable that is based on multiple underlying data sources.

False

Slicers are used to separate the data so that each field appears in a separate column in a worksheet.

False

Spaces are not allowed in worksheet names.

False

Strategic business processes are static, routine, daily business processes such as stocking inventory, checking out customers, or daily opening and closing processes.

False

Structured data accounts for a much higher percentage of the data that surrounds us than unstructured data does.

False

The EXACT function is not case sensitive.

False

Which function capitalizes the first letter in each word in a text string and converts all other letters to lowercase?

Proper

Excel creates which type of cell references in formulas by default?

Relative

Which statement below is inaccurate?

Web 2.0 is a simple, static website without any interaction with its users.

Which of the following items is an example of data?

Who is customer number 12345?