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 .