Business 520 End of Course Final Assessment Review Question Bank 2026

Business 520 End of
Course Final
Assessment Review
Question Bank 2026

,What keystroke combination toggles between displaying formulas and values? - correct answer Ctrl + '
k k k k k k k k k k k k k k




If the formula =$b$4-sum(a1:a5) is copied from a9 to c10, what is the result? - correct answer =$b$4-
k k k k k k k k k k k k k k k k k




sum(c2:c6)



What keystroke combination moves the active cell right, to the end of the current row of adjacent cells with
k k k k k k k k k k k k k k k k k k k




values? - correct answer Ctrl + right arrow
k k k k k k k




What keystroke combination moves one screen to the right within the current worksheet - correct answer Alt
k k k k k k k k k k k k k k k k k




+ pg dn
k k




What keystroke combination shows the formal cells dialog window - correct answer Ctrl + 1
k k k k k k k k k k k k k k




_____ is the last in the order of precedence rules. - correct answer Addition and subtraction left to right
k k k k k k k k k k k k k k k k k k




COUNT(number1, number2,...) determines the sum of a list of values - correct answer False k k k k k k k k k k k k k




What keystroke combination quickly inserts the current time? - correct answer Ctrl + shift + :
k k k k k k k k k k k k k k k




After copying something what keystroke combination quickly performs a paste special operation - correct
k k k k k k k k k k k k k k




answer Ctrl + alt + v k k k k k




What keystroke combo inserts cells? - correct answer Ctrl + shift + plus
k k k k k k k k k k k k




If multiple cells are selected, what KC copies the formulas in the topmost cells of the range down to the other
k k k k k k k k k k k k k k k k k k k k k




cells in the range of selected cells? - correct answer Ctrl + d
k k k k k k k k k k k k




What keystroke combination changes the cell reference type (to absolute, mixed, relative) while
k k k k k k k k k k k k k




entering/editing a formula? - correct answer f4 k k k k k k

, A workbook's documentation should always be showing when saving the file a final time. - correct answer
k k k k k k k k k k k k k k k k k




True



What KC quickly applies the number format to two decimal places? - correct answer Ctrl + shift + !
k k k k k k k k k k k k k k k k k k




______ is the first in the order of precedence rules - correct answer Parentheses
k k k k k k k k k k k k k




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




What KC selects the current column? - correct answer Ctrl + space
k k k k k k k k k k k




What KC closes the current workbook? - correct answer Ctrl + f4 and Ctrl + w
k k k k k k k k k k k k k k k




The COUNTA function ignores cells with text - correct answer False
k k k k k k k k k k




Using cell references is preferable to directly inputting values into a formula. - correct answer True
k k k k k k k k k k k k k k k




The wrong argument type or operand is shown by - correct answer #VALUE!
k k k k k k k k k k k k




The best way to center titles is to use the Merge & Center toolbar/ribbon button. - correct answer False
k k k k k k k k k k k k k k k k k k




Center Across Selection
k k




After copying something, what KC performs a paste operation? - correct answer Ctrl + v
k k k k k k k k k k k k k k




$b1 is an example of a ______ reference. - correct answer Mixed
k k k k k k k k k k k




After selecting a range of cells, what KC deletes those cells? - correct answer Ctrl + -
k k k k k k k k k k k k k k k k