BUSI 520 All Chapters Study Guide | Complete Marketing Management Notes

BUSI 520 All Chapters Study Guide | Complete Marketing
Management Notes


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



In Excel, after having copied something, what keystroke combination performs a Paste
operation? - ANS ✔✔Ctrl+v



In Excel, what keystroke combination quickly removes a border from the selected cell or range?
- ANS ✔✔Ctrl+Shift+_ (Ctrl, Shift and underscore)



If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting
formula? - ANS ✔✔=$B$4-SUM(C2:C6)



Pressing Ctrl+Shift+# applies the number format. - ANS ✔✔False



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



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) - ANS ✔✔Ctrl+minus



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



In Excel, what keystroke combination selects the current row? - ANS ✔✔Shift+space



Using cell references is preferable to directly inputting values into a formula. - ANS ✔✔True

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



In Excel, what keystroke combination selects right, to the end of the current row of contiguous
(adjacent) cells? - ANS ✔✔Ctrl+Shift+right arrow



In Excel, what keystroke combination performs an "undo" of the last action? - ANS ✔✔Ctrl+z



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? - ANS ✔✔Ctrl+d



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. - ANS ✔✔False



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



The best way to center titles is to use the Merge & Center toolbar/ribbon button. - ANS
✔✔False



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



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



It is okay to send your homework file to someone else in order to help the person understand a
particular topic. - ANS ✔✔False

, In Excel, what keystroke combination switches (the active worksheet) to the next worksheet (to
the right)? - ANS ✔✔Ctrl+Pg dn



The COUNTA function ignores cells with text - ANS ✔✔False



In Excel, what keystroke combination quickly applies the number format to two decimal places?
- ANS ✔✔Ctrl+Shift+! (Ctrl, Shift and exclamation mark)



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? - ANS ✔✔Ctrl+r



B1 is an example of a(n) _____ cell reference. - ANS ✔✔relative



If A1=2, the resulting value of =3*A1^3 is - ANS ✔✔24



In Excel, what keystroke combination closes the current workbook? - ANS ✔✔Ctrl+F4, Ctrl+w



_____ is(are) last in the order of precedence rules. - ANS ✔✔Addition and subtraction from left
to right



In Excel, what keystroke combination inserts cells? - ANS ✔✔Ctrl+Shift+plus



In Excel, what keystroke combination shows the format cells dialog window? - ANS ✔✔Ctrl+1
(Ctrl and 1)



In Excel, what keystroke combination selects the current column? - ANS ✔✔Ctrl+space