BUSI 520 Final Exam Study Guide.docx

BUSI 520 Final Exam
Study Guide

,Alt+Pg dn - correct answer In Excel, what keystroke combination moves one screen to the right within the
k k k k k k k k k k k k k k k k k k




current worksheet? k




ctrl+shift+right arrow - correct answer Keystroke combination that selects right, to the end of the current row k k k k k k k k k k k k k k k k k




of contiguous (adjacent) cells?
k k k




ctrl+right arrow - correct answer moves the active cell right, to the end of the current row of continuous
k k k k k k k k k k k k k k k k k k k




(adjacent) cells with values k k k




Ctrl+r - correct answer If multiple horizontal cells are selected/highlighted, what keystroke combination
k k k k k k k k k k k k k




copies the formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the other cells in the
k k k k k k k k k k k k k k k k k k k k




range of selected cells? k k k




#VALUE - correct answer wront type of formula argument or operand
k k k k k k k k k k




Ctrl+F4 & Ctrl+w - correct answer Close the current workbook
k k k k k k k k k




Ctrl+space - correct answer Selects the current column k k k k k k k




False - correct answer When using Excel to open a file that is in .csv format, formulas and formatting entered in
k k k k k k k k k k k k k k k k k k k k k




the sheet can be safely saved in either .csv, .xls or .xlsx format.
k k k k k k k k k k k k




Ctrl+d - correct answer Copies formulas/values in the topmost cells of the selected range down to the other
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
k k k k k k




True - correct answer Exponents come before mulitplication
k k k k k k k




F4 - correct answer Changes the cell reference type when editing a formula
k k k k k k k k k k k k




#NAME - correct answer unrecognized text in formula k k k k k k k

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




False - correct answer #REF! means invalid numerical values in a formula or function
k k k k k k k k k k k k k




Ctrl+shift+& - correct answer quickly applies border k k k k k k




Ctrl+shift+_ - correct answer removes border k k k k k




Ctrl+shift+% - correct answer Percentage format, with no decimal places
k k k k k k k k k




Ctrl+shift+: - correct answer Inserts current time
k k k k k k




Ctrl+minus - correct answer Deletes selected cells
k k k k k k




Ctrl+1 - correct answer Shows the format cells dialog window
k k k k k k k k k




Ctrl+Shift+! - correct answer Quickly applies number format to two decimal places
k k k k k k k k k k k




Ctrl+Alt+V - correct answer Paste special operation
k k k k k k




Parenthesis - correct answer First in order of operation
k k k k k k k k




Ctrl+tab - correct answer switches between open workbooks
k k k k k k k




Ctrl+shift+~ - correct answer General format k k k k k




Ctrl+shift+plus - correct answer inserts cells k k k k k




Ctrl+pg dn - correct answer Switches to the next worksheet to the right
k k k k k k k k k k k k