BIS 155 Week 2 Quiz( New) For more course tutorials visit www. uophelp. com
14.( TCO 7) Which of the following file formats can store macros?( Points: 2)
15.( TCO 7) By default, Excel automatically _____ macros and displays a security warning when a file containing macros is opened.( Points: 2)
16. ==========================================
BIS 155 Week 2 Quiz( New) For more course tutorials visit www. uophelp. com
Question 1. Question:( TCO 2) In Excel, a relative cell reference indicates a cell ' s specific location and the reference does not change when you copy the formula. contains both an absolute and a relative cell reference. indicates a cell ' s relative location from the cell containing the formula; the reference changes when you copy the formula. occurs when a formula directly or indirectly refers to the cell containing the formula.
Question 2. Question:( TCO 2) Which of the following best describes a mixed cell reference? Occurs when a formula directly or indirectly refers to the cell containing the formula Causes a potential error Contains absolute or relative cell references, but not both Contains both an absolute and a relative cell reference
Question 3. Question:( TCO 2) You have a cell that contains the formula = A1 * 2. When you copy this formula to other cells, you want it to always reference column A, but you want the row number to change automatically. You should make the A1 in this formula a( n) _____ cell reference.