BUSI 520 Final Exam Questions With Correct Answers

BUSI 520 Final Exam Questions With
Correct Answers

Current |date |- |CORRECT |ANSWER✔✔-Ctrl+; |(Ctrl |and |semi-colon)



Shows |format |cells |dialog |window |- |CORRECT |ANSWER✔✔-Ctrl+1 |(Ctrl |and |1)



using |cell |reference |is |preferred |to |directly |inputting |values |into |a |formula |- |
CORRECT |ANSWER✔✔-true



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



documentation |sheet |should |be |showing |when |saving |a |file |so |its |seen |first |
when |opening |it |- |CORRECT |ANSWER✔✔-True



###### |- |CORRECT |ANSWER✔✔-cells |not |wide |enough



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



displays |formulas |- |CORRECT |ANSWER✔✔-Ctrl |+ |`



percent |format |- |CORRECT |ANSWER✔✔-Ctrl+Shift+%



#REF |- |CORRECT |ANSWER✔✔-invalid |cell |reference

,removes |a |border |- |CORRECT |ANSWER✔✔-Ctrl+Shift+_ |(Ctrl, |Shift |and |
underscore)



wrap |text |first, |then |adjust |width |- |CORRECT |ANSWER✔✔-True



best |way |to |center |titles |is |merge |and |center |- |CORRECT |ANSWER✔✔-False



switch |between |currently |open |workbooks |- |CORRECT |ANSWER✔✔-Ctrl |+ |tab



deletes |the |actual |cell |- |CORRECT |ANSWER✔✔-Ctrl |+ |- |(control |plus |minus)



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



Current |Time |- |CORRECT |ANSWER✔✔-Ctrl |+ |shift |+ |:



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



If |multiple |cells |(in |more |than |one |column) |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



adds |a |border |- |CORRECT |ANSWER✔✔-Ctrl+Shift+& |(Ctrl, |Shift |and |
ampersand)



moves |one |screen |(worth |of |columns) |to |the |right |within |the |current |
worksheet? |- |CORRECT |ANSWER✔✔-Alt+Pg |dn

, COUNT(number1, |number |2, |...) |determines |the |sum |of |a |list |of |values. |- |
CORRECT |ANSWER✔✔-False



changes |the |cell |reference |type |(to |absolute, |then |mixed, |then |mixed, |then |
relative) |while |entering |or |editing |a |formula |- |CORRECT |ANSWER✔✔-F4



If |multiple |cells |(in |more |than |one |row) |are |selected/highlighted, |what |
keystroke |combination |copies |the |formula(s)/value(s) |in |the |topmost |cell(s) |of |
the |selected |range |down |to |the |other |cell(s) |in |the |range |of |selected |cells |- |
CORRECT |ANSWER✔✔-Ctrl |+ |d



applies |the |number |format |to |two |decimal |places |- |CORRECT |ANSWER✔✔-
Ctrl+Shift+! |(Ctrl, |Shift |and |exclamation |mark)



date |format |- |CORRECT |ANSWER✔✔-Ctrl+Shift+#



closes |the |current |workbook |- |CORRECT |ANSWER✔✔-Ctrl |+ |F4

Ctrl |+ |w



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



general |number |format |- |CORRECT |ANSWER✔✔-Ctrl |+ |shift |+ |~



switches |(the |active |worksheet) |to |the |next |worksheet |(to |the |right) |- |
CORRECT |ANSWER✔✔-Ctrl+Pg |dn



$B1 |is |an |example |of |a(n) |_____ |reference |- |CORRECT |ANSWER✔✔-mixed