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?