TCO 2 by xiuliliaofz

VIEWS: 31 PAGES: 4

									(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.

								
To top