TCO 2 by xiuliliaofz

VIEWS: 31 PAGES: 4

• pg 1
```									(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