(TCO 2) Excel has preconstructed formulas, called __________, that can be used to return calculated results. macros functions programs procedures 2. (TCO 2) The fill handle can be used to copy formulas or to ________. finish a text series add a comment to a cell clear cell contents change references from relative to absolute 3. (TCO 2) To ensure that the reference to a specific cell does not change, use __________ cell referencing. relative absolute abstract mixed 4. (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. abstract relative mixed absolute 5. (TCO 2) Which group on the Formulas tab contains the Insert Function command? Defined Names Formula Auditing Calculation Function Library 6. (TCO 2) In the function SUM(C4:C10), the C4:C10 which specifies the range of numbers to be summed, is a(n) ______ of the SUM function. macro output argument format 7. (TCO 2) You want to determine the length of time an employee has worked for you, by calculating the difference between the employee’s start date and the present date. To do this calculation, you would most likely use ____________. Financial functions Logical functions Date functions Count functions 8. (TCO 2) The __________ function returns a result based on a condition. MAX TODAY FIND IF 9. (TCO 2) In an IF function condition, to compare the contents of cell C1 to the specific text OK, you would enter the condition as _________. C1="OK" C1=(OK) C1=[OK] C1=<OK> 10. (TCO 2) The __________ number is the number of the column in the lookup table that contains the return values. lookup value column index lookup table random 11. (TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it true or false, is also sometimes called a(n) ____________. logical test lookup value breakpoint table array 12. (TCO 7) To record a macro, select ___________ from the Macros down arrow in the Macros Group. Store Macro Macro security option Record Macro Insert Macro 13. (TCO 7) What is the time limit for the macro recording process? 30 seconds. 60 seconds. 5 minutes. There is no time limit. 14. (TCO 7) You can use the ___________ in Microsoft Excel to change security settings to make it easier to work with macros. Security Dashboard Trust Center Macro Control Panel Administrator Console 15. (TCO 7) What should you do when you finish recording a macro, to end recording and save your work? Press the Shift Key. Press the Tab Key. Click the Stop Recording command in the Macros down arrow list Open the Macro Dialog Box.
Pages to are hidden for
"TCO 2"Please download to view full document