520

The Error Alert Style of _____ indicates the entry does not conform to the data validation rules, and is accepted or canceled. Warning Information Critical Stop

Information

A(n) _____ function returns a value of FALSE only if all of its arguments are FALSE. AND OR

OR

What's the best FUNCTION to use to change all instances of United States of America" to U.S.A. ? None of the answers listed. REPLACE SUBSTITUTE FIND TEXT

SUBSTITUTE

The decision variables are the output cells objective (or target) cells changing cells constraints None of the answers listed.

changing cells

A(n) _____ cell uses the value in the active cell in its formula. independent precedent active dependent

dependent

If a cell contains the formula =Goodbye<Hello the resulting value is _____. (Assume no range names have been defined.) #N/A None of the answers listed. FALSE #NAME? TRUE

#NAME?

The wrong argument type or operand is shown by #REF! None of the answers listed. #NAME? #VALUE! #NUM!

#VALUE

Define #value Define #ref

#value - something wrong with formula #ref - something wrong with cell referenced

In financial functions, an argument Type of _____ indicates payments are made at the end of each period. None of the answers listed. 0 2 -1 1

0

To remove all nonprintable characters from a text string, use the _____ function. None of the answers listed. REMOVE REPT CLEAN EXACT

CLEAN

In Excel, what keystroke combination toggles between displaying formulas and displaying values? None of the answers listed. Ctrl+Shift+~ (Ctrl, Shift and tilde) Ctrl+Shift+! (Ctrl, Shift and exclamation mark) Ctrl+1 (Ctrl and 1) F4

Ctrl + ' None of the answers listed

To display the formulas on the worksheet, press Alt + ! (Alt + Exclamation) Ctrl + ` (Ctrl + Left quote) Alt + ` (Alt + Left quote) Ctrl + End

Ctrl + ` (Ctrl + Left quote)

Switch worksheet to right worksheet? Switch workbook? Move one sheet to right within current worksheet?

Ctrl Pg Down Ctrl Tab Alt Pg Down

In Excel, what keystroke combination shows the format cells dialog window? Ctrl+` (Ctrl and left quote (grave accent)) None of the answers listed. Ctrl+Shift+! (Ctrl, Shift and exclamation mark) Ctrl+Shift+~ (Ctrl, Shift and tilde) Ctrl+1 (Ctrl and 1)

Ctrl+1 (Ctrl and 1)

In Excel, what keystroke combination quickly inserts the current date? Ctrl+; (Ctrl and semi-colon) Ctrl+Shift+: (Ctrl, Shift and colon) None of the answers listed. Ctrl+Shift+# (Ctrl, Shift and number sign) Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)

Ctrl+; (Ctrl and semi-colon)

To display tracer arrows that indicate which formulas use the value in the active cell, use the _____ button on the Formula Auditing toolbar. Error Checking Trace Dependents Trace Error Trace Precedents

Trace Dependents

In Excel, what keystroke combination selects right, to the end of the current row of contiguous (adjacent) cells? None of the answers listed. Shift+End Shift+right arrow Ctrl+Shift+end Ctrl+Shift+right arrow

Ctrl+Shift+right arrow

In Excel, what keystroke combination moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values? Ctrl+end Alt+end Ctrl+right arrow Alt+right arrow None of the answers listed.

Ctrl+right arrow

#REF! means invalid numerical values in a formula or function. TRUE FALSE

FALSE

If the cell M1 contains Monkey1 and cell D1 contains Dog2, the formula =M1<=D1 results in a value of TRUE FALSE #Name? #Value! None of the answers listed.

FALSE

If the values in cells F3, F4, F5, and F6 are all greater than 100, the formula =OR(F3:F6>100) will always return a value of TRUE. TRUE FALSE

FALSE

If you want apply formatting to G3 based on the value in cell F3, use conditional formatting's "Format only cells that contain" option. TRUE FALSE

FALSE

SUMPRODUCT ranges cannot have blank cells within the ranges. TRUE FALSE

FALSE

Solver's "Changing Variable Cells" can be cells with either values or formulas. TRUE FALSE

FALSE

The syntax of the NOT function can evaluate a range of values. TRUE FALSE

FALSE

When using Excel to open a file that is in .csv format, formulas and formatting entered in the sheet can be safely saved in either .csv, .xls or .xlsx format. TRUE FALSE

FALSE

The SEARCH function is case sensitive. TRUE FALSE

FALSE (FIND is case sensitive)

Pressing Ctrl+Shift+# applies the number format. True False

False

The Error Alert Style of _____ indicates the entry is incorrect and must be canceled or corrected before continuing. Critical Warning Information Stop

Stop

Relational expressions are not case sensitive. TRUE FALSE

TRUE

The payment Type does not affect lump sum amounts...it only applies to periodic payments (located in the PMT box). TRUE FALSE

TRUE

Use the _____ button on the Formula Auditing toolbar to display tracer arrows that indicate which cells the formula references Error Checking Trace Precedents Trace Errors Trace Dependents

Trace Precedents

Use the _____ button on the Formula Auditing toolbar to display tracer arrows that indicate which cells the formula references. Trace Precedents Trace Dependents Trace Errors Error Checking

Trace Precedents

The Circle Invalid Data button circles cells that don't meet their data validation criteria have errors All of the answers listed. are in the wrong format

don't meet their data validation criteria

A _____ identifies the end of each record in a comma-delimited file. period None of the answers listed. comma colon paragraph mark

paragraph mark

A(n) _____ cell contains a value that is used in a formula. dependent precedent active independent

precedent