BUSI 520 Final Exam Questions With Correct Answers

BUSI 520 Final Exam Questions With
Correct Answers

A |workbook's |documentation |sheet |should |always |be |showing |when |saving |
the |file |a |final |time |(right |before |submitting |the |file), |so |that |when |someone |
opens |your |file, |the |documentation |sheet |will |be |the |first |sheet |seen. |- |
CORRECT |ANSWER✔✔-True



A |quick |way |to |apply |the |percent |format |is |to |press |Ctrl+Shift+% |- |CORRECT |
ANSWER✔✔-True



In |Excel, |what |keystroke |combination |changes |the |cell |reference |type |(to |
absolute, |mixed, |mixed, |relative) |while |entering/editing |a |formula?

a. |none |of |the |answers |listed

b. |ctrl+shift+f4

c.ctrl+`

d.ctrl+f4

e. |f4 |- |CORRECT |ANSWER✔✔-e



In |Excel, |what |keystroke |combination |quickly |inserts |the |current |date?

a. |Ctrl+Shift+: |(Ctrl, |Shift |and |colon) |

b. |Ctrl+; |(Ctrl |and |semi-colon) |

c. |Ctrl+Shift+# |(Ctrl, |Shift |and |number |sign) |

d. |Ctrl+Shift+@ |(Ctrl, |Shift |and |"at" |symbol) |- |CORRECT |ANSWER✔✔-b



The |error |message |#NAME? |means |that |there |is(are) |- |CORRECT |ANSWER✔✔-
unrecognized |text |in |a |formula

,In |Excel, |what |keystroke |combination |moves |one |screen |to |the |right |within |the
|current |worksheet?



a. |alt+pg |dn

b. |shift+pg |dn

c. |ctrl+pg |dn

d. |ctrl+tab |- |CORRECT |ANSWER✔✔-a



In |order |to |maintain |consistency |within |your |workbooks, |it |is |important |to |
format |cells |with |formulas |(outputs) |using |the |same |colors |as |cells |containing |
assumptions |and/or |values |(inputs) |- |CORRECT |ANSWER✔✔-False



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



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



In |Excel, |what |keystroke |combination |quickly |applies |the |number |format |to |
two |decimal |places? |- |CORRECT |ANSWER✔✔-ctrl+shift+!



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



The |best |way |to |center |titles |is |to |use |the |Merge |& |Center |toolbar/ribbon |
button. |- |CORRECT |ANSWER✔✔-false



In |Excel, |what |keystroke |combination |closes |the |current |workbook? |- |
CORRECT |ANSWER✔✔-ctrl+w |and |ctrl+f4

,B1 |is |an |example |of |a(n) |_____ |cell |reference. |- |CORRECT |ANSWER✔✔-relative



What |keystroke |combination |switches |between |currently |open |workbooks? |- |
CORRECT |ANSWER✔✔-ctrl+tab



In |Excel, |what |keystroke |combination |performs |an |"undo" |of |the |last |action? |- |
CORRECT |ANSWER✔✔-ctrl+z



Using |cell |references |is |preferable |to |directly |inputting |values |into |a |formula. |- |
CORRECT |ANSWER✔✔-true



If |multiple |cells |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



In |Excel, |after |selecting |a |range |of |cells, |what |keystroke |combination |deletes |
those |cells? |(not |just |deletes |the |contents |of |cells, |but |deletes |the |actual |cells,
|so |that |other |cells |adjust |to |replace |the |deleted |cells) |- |CORRECT |ANSWER✔✔-


ctrl+minus



In |Excel, |what |keystroke |combination |selects |the |current |row? |- |CORRECT |
ANSWER✔✔-shift+space



In |Excel, |what |keystroke |combination |quickly |applies |the |General |format?

a.Ctrl+Shift+@ |(Ctrl, |Shift |and |"at" |symbol) |

b.Ctrl+Shift+# |(Ctrl, |Shift |and |number |sign) |

c.Ctrl+Shift+! |(Ctrl, |Shift |and |exclamation |mark) |

Correct!

d.Ctrl+Shift+~ |(Ctrl, |Shift |and |tilde) |- |CORRECT |ANSWER✔✔-d

, In |Excel, |what |keystroke |combination |moves |(the |active |cell) |right, |to |the |end |
of |the |current |row |of |contiguous |(adjacent) |cells |with |values? |- |CORRECT |
ANSWER✔✔-ctrl+right |arrow



In |Excel, |what |keystroke |combination |selects |the |current |column?

a.Alt+space |

b.Alt+enter |

c.Ctrl+space |- |CORRECT |ANSWER✔✔-c



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



In |Excel, |after |having |copied |something, |what |keystroke |combination |quickly |
performs |a |Paste |Special |operation?

a.Ctrl+Shift+p |

b.Ctrl+Shift+v |

c.Ctrl+v |

d.Ctrl+Alt+v |- |CORRECT |ANSWER✔✔-d



The |error |message |###### |means |that |there |is(are)

a.insufficient |width |in |cell |to |display |data, |or |negative |date/time.

b.an |invalid |cell |reference. |

c.invalid |numeric |values |in |a |formula |or |function. |

d.no |valid |answer. |- |CORRECT |ANSWER✔✔-a



You |should |always |adjust |column |widths |first, |before |attempting |to |Wrap |Text |
for |the |column |headings. |- |CORRECT |ANSWER✔✔-False



In |Excel, |what |keystroke |combination |shows |the |format |cells |dialog |window?