BUSI 520 Final Exam Study Guide Questions With Correct Answers

BUSI 520 Final Exam Study Guide
Questions With Correct Answers

In |Excel, |what |keystroke |combination |moves |one |screen |to |the |right |within |the
|current |worksheet? |- |CORRECT |ANSWER✔✔-Alt+Pg |dn




Keystroke |combination |that |selects |right, |to |the |end |of |the |current |row |of |
contiguous |(adjacent) |cells? |- |CORRECT |ANSWER✔✔-ctrl+shift+right |arrow



moves |the |active |cell |right, |to |the |end |of |the |current |row |of |continuous |
(adjacent) |cells |with |values |- |CORRECT |ANSWER✔✔-ctrl+right |arrow



If |multiple |horizontal |cells |are |selected/highlighted, |what |keystroke |
combination |copies |the |formula(s)/value(s) |in |the |leftmost |cell(s) |of |the |
selected |range |to |the |right, |to |the |other |cells |in |the |range |of |selected |cells? |- |
CORRECT |ANSWER✔✔-Ctrl+r



wront |type |of |formula |argument |or |operand |- |CORRECT |ANSWER✔✔-#VALUE



Close |the |current |workbook |- |CORRECT |ANSWER✔✔-Ctrl+F4 |& |Ctrl+w



Selects |the |current |column |- |CORRECT |ANSWER✔✔-Ctrl+space



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. |- |
CORRECT |ANSWER✔✔-False

,Copies |formulas/values |in |the |topmost |cells |of |the |selected |range |down |to |the |
other |cells |in |the |range |of |selected |cells |- |CORRECT |ANSWER✔✔-Ctrl+d



Exponents |come |before |mulitplication |- |CORRECT |ANSWER✔✔-True



Changes |the |cell |reference |type |when |editing |a |formula |- |CORRECT |
ANSWER✔✔-F4



unrecognized |text |in |formula |- |CORRECT |ANSWER✔✔-#NAME



COUNTA |function |ignores |cells |with |text |- |CORRECT |ANSWER✔✔-False



#REF! |means |invalid |numerical |values |in |a |formula |or |function |- |CORRECT |
ANSWER✔✔-False



quickly |applies |border |- |CORRECT |ANSWER✔✔-Ctrl+shift+&



removes |border |- |CORRECT |ANSWER✔✔-Ctrl+shift+_



Percentage |format, |with |no |decimal |places |- |CORRECT |ANSWER✔✔-
Ctrl+shift+%



Inserts |current |time |- |CORRECT |ANSWER✔✔-Ctrl+shift+:



Deletes |selected |cells |- |CORRECT |ANSWER✔✔-Ctrl+minus



Shows |the |format |cells |dialog |window |- |CORRECT |ANSWER✔✔-Ctrl+1

, Quickly |applies |number |format |to |two |decimal |places |- |CORRECT |ANSWER✔✔-
Ctrl+Shift+!



Paste |special |operation |- |CORRECT |ANSWER✔✔-Ctrl+Alt+V



First |in |order |of |operation |- |CORRECT |ANSWER✔✔-Parenthesis



switches |between |open |workbooks |- |CORRECT |ANSWER✔✔-Ctrl+tab



General |format |- |CORRECT |ANSWER✔✔-Ctrl+shift+~



inserts |cells |- |CORRECT |ANSWER✔✔-Ctrl+shift+plus



Switches |to |the |next |worksheet |to |the |right |- |CORRECT |ANSWER✔✔-Ctrl+pg |
dn



before |adjusting |widths |- |CORRECT |ANSWER✔✔-Wrap |text



Ctrl+shift+# |applies |the |number |format |- |CORRECT |ANSWER✔✔-False



selects |current |row |- |CORRECT |ANSWER✔✔-Shift+space



currency |format |- |CORRECT |ANSWER✔✔-Ctrl+shift+$



Mixed |cell |reference |- |CORRECT |ANSWER✔✔-$B1



Display |formulas |- |CORRECT |ANSWER✔✔-Ctrl+'