Busi 520

######Insufficient cell width to display data #NAME?unrecognized text in a formula #N/Ano answer can be found #REF!invalid cell reference #VALUE!wrong argument type or operand #NUM!Invalid numeric values in a formula or function #DIV/0!Division by zero Error Alertschecking error messages - error alert button

What keystroke combination toggles between displaying formulas and values? Ctrl + ' If the formula =$b$4-sum(a1:a5) is copied from a9 to c10, what is the result? =$b$4- sum(c2:c6) What keystroke combination moves the active cell right, to the end of the current row of adjacent cells with values? Ctrl + right arrow What keystroke combination moves one screen to the right within the current worksheet Alt + pg dn What keystroke combination shows the formal cells dialog window Ctrl + 1 __...

Current dateCtrl+; (Ctrl and semi-colon) Shows format cells dialog windowCtrl+1 (Ctrl and 1) using cell reference is preferred to directly inputting values into a formulatrue inserts cellsCtrl+Shift+plus documentation sheet should be showing when saving a file so its seen first when opening itTrue ######cells not wide enough selects current rowShift + space displays formulasCtrl +

(Annual Percentage Rate / Pmts per Year) - answer-Rate for PMT? (# of Years * Pmts per Year - answer-Nper for PMT? False - answer-In order to calculate the Future Value of a stream of monthly cash flows which start immediately, and also include an additional lump sum at the beginning of the transaction, the value in the PMT argument should equal the Lump Sum amount plus the monthly Payment amount. True - answer-The "values" argument in the formula =IRR(values,guess) is a list of posit...

What keystroke combination toggles between displaying formulas and values? Ctrl + ' If the formula =$b$4-sum(a1:a5) is copied from a9 to c10, what is the result? =$b$4- sum(c2:c6) What keystroke combination moves the active cell right, to the end of the current row of adjacent cells with values? Ctrl + right arrow What keystroke combination moves one screen to the right within the current worksheet Alt + pg dn What keystroke combination shows the formal cells dialog window Ctrl + 1 __...

######Insufficient cell width to display data #NAME?unrecognized text in a formula #N/Ano answer can be found #REF!invalid cell reference #VALUE!wrong argument type or operand #NUM!Invalid numeric values in a formula or function #DIV/0!Division by zero

Current dateCtrl+; (Ctrl and semi-colon) Shows format cells dialog windowCtrl+1 (Ctrl and 1) using cell reference is preferred to directly inputting values into a formulatrue inserts cellsCtrl+Shift+plus documentation sheet should be showing when saving a file so its seen first when opening itTrue ######cells not wide enough selects current rowShift + space

BUSI 520 Quiz 3. Questions & Answers.

BUSI 520 Quiz 2. Questions & Answers (Graded A).

BUSI 520