KU IST 310 Quiz 5 & 6 & 7

Which error message means that no answer can be found?

#N/A

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()

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

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

False

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

False

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

False

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

Maintenance

By default, all cells are "Locked".

True

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

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

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 ROWS function return 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 benefits of cloud computing include cheaper costs to an organization for a system deployment and backup and maintenance maintained by the vendor.

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

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

True

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

True

Workbook protection is primarily used to protect the structure of an Excel workbook.

True

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

relative

The ISBLANK function returns either YES or NO.

False

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

False

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

B2B

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

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

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

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

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

Which of the following items is an example of data?

Who is customer number 12345?