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?