( TCO 1 ) Which of the following best describes the AutoComplete function ? ( Points : 2 )
Adds all the numbers in the row automatically
Searches for and displays any other similar label in the current column as you begin to type
Adds all the numbers in the columns automatically Is a number that represents a quantity and can be the basis of calculations
( TCO 1 ) Why would you use cell references in formulas instead of constant values ? ( Points : 2 )
You can easily include letters , numbers , and spaces It is easier to debug the errors You can change the input values without changing the formulas You can control the sequence in which Excel performs arithmetic operations
( TCO 1 ) In Excel 2010 , a column width ________. ( Points : 2 ) is adjustable so you can display more or less characters in a columnis not adjustable so keep the formulas as short as possible always switches back to default
is best left unchanged unless you absolutely have to ( TCO 1 ) Which of the following best describes a “ Range ” in Excel 2010 ? ( Points : 2 ) Cannot be selected with the mouse Are the numbers that fall between the smallest and largest in the formula Is another word for the active worksheet Refers to a group of adjacent or contiguous cells
( TCO 1 ) The fill handle in Excel 2010 _______. ( Points : 2 ) is the fastest way to type A1 in the name box
helps carry over the fill to the remaining slides is the same action as pressing “ Enter ”