Busi520 Comprehensive Final Assessment Review Question Bank 2026

Busi520
Comprehensive Final
Assessment Review
Question Bank 2026

,The Accounting Format inserts a dollar sign directly in front of (and flush against) the leftmost number in the
k k k k k k k k k k k k k k k k k k k




cell, like this: $1.00 - correct answer False
k k k k k k k




In the Windows version of Excel, the keyboard shortcut sequence of "Alt h, o, y" will autofit the column width
k k k k k k k k k k k k k k k k k k k k




of the active cell or range of cells. - correct answer True
k k k k k k k k k k k




In Excel, after having copied something, what keystroke combination performs a normal Paste operation? -
k k k k k k k k k k k k k k k




correct answer None of the answers listed. k k k k k k




If A1=2, then the resulting value of =3+5*A1 is - correct answer 13
k k k k k k k k k k k k




In Excel, what keystroke combination inserts cells? - correct answer Ctrl+Shift+plus (or Alt, h, i, i)
k k k k k k k k k k k k k k k




A workbook's documentation sheet should always be showing when saving the file a final time (right before
k k k k k k k k k k k k k k k k k




submitting the file), so that when someone opens your file, the documentation sheet will be the first sheet
k k k k k k k k k k k k k k k k k k




seen. - correct answer False k k k k




A quick way to apply the percent format is to press Ctrl+Shift+%. - correct answer True
k k k k k k k k k k k k k k k




Cells formatted with Accounting format can be aligned within a cell using the following formats: - correct
k k k k k k k k k k k k k k k k k




answer Any/all of choices listed k k k k




In Excel, what keystroke combination quickly applies the number format to two decimal places, with comma
k k k k k k k k k k k k k k k k




separator for thousands? - correct answer Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
k k k k k k k k k k k




In Excel, what keystroke combination quickly inserts the current date? - correct answer Ctrl+; (Ctrl and semi-
k k k k k k k k k k k k k k k k




colon)



It is okay to send your assignment file to someone else in order to help the person understand a particular
k k k k k k k k k k k k k k k k k k k k




topic. - correct answer False k k k k

, If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula? - correct
k k k k k k k k k k k k k k k k k k k




answer =$B$4-SUM(C2:C6) k




What Excel keystroke combination would you use to quickly format cells BELOW a top row cell formatted with
k k k k k k k k k k k k k k k k k k




the accounting format? - correct answer Alt 4 (or Alt+4 or Alt, 4)
k k k k k k k k k k k k




To quickly insert a new function or open the Function Arguments window for a currently entered function, use
k k k k k k k k k k k k k k k k k k




what keystroke combination? - correct answer Shift+F3 (or Shift+Fn+F3)
k k k k k k k k




In Excel, after having copied a cell, what keystroke combination opens the Paste Special dialog box? - correct
k k k k k k k k k k k k k k k k k k




answer Ctrl+Alt+v k




The quickest way to apply the Accounting format on an ongoing basis is to customize the Quick Access Toolbar
k k k k k k k k k k k k k k k k k k k




and then use a shortcut such as Alt 4. - correct answer True
k k k k k k k k k k k k




A quick way to apply the currency format is to press Ctrl+Shift+$. - correct answer True
k k k k k k k k k k k k k k k




#REF! means invalid numerical values in a formula or function. #REF means invalid cell reference (often when
k k k k k k k k k k k k k k k k k




a formula refers to a cell in deleted row/column) - correct answer False
k k k k k k k k k k k k




What keystroke combination switches between currently open workbooks? - correct answer Ctrl+tab
k k k k k k k k k k k




In order to maintain consistency within your workbooks, it is important to format cells with formulas
k k k k k k k k k k k k k k k k




(outputs) using the same colors as cells containing assumptions and/or values (inputs). - correct answer False
k k k k k k k k k k k k k k k




The best way to center titles is to use Merge & Center → best is to use Merge Across Selection - correct answer
k k k k k k k k k k k k k k k k k k k k k k k




False



To quickly increase or decrease the number of decimal places displayed, customize the Quick Access Toolbar
k k k k k k k k k k k k k k k k




and add "Decrease Decimal" and "Increase Decimal" buttons (so, for example, you can hold down the Alt key
k k k k k k k k k k k k k k k k k k




and press the 5 or 6 key the number of you want to decrease or increase decimals shown). - correct answer
k k k k k k k k k k k k k k k k k k k k k




True