Question 1. Question : An absolute cell reference:
causes a potential error.
indicates a cell's specific location and the reference does not change when you copy the formula.
occurs when a formula directly or indirectly refers to the cell containing the formula.
contains both an absolute and a relative cell reference.
Question 2. Question :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 : The rules for constructing a function can be referred to as the function's _____.
synthesis
synergy
synchronization
syntax
Question 4. Question :To display the current date on each page of an Excel worksheet, use the _____ function.
PRESENT
TODAY
CURRENT
SET
Question 5. Question :The _____ function returns a result based on a condition.
MAX
TODAY
FIND
IF
Question 6. Question :The MAX function identifies the _____.
highest value in a range.
number of blank cells in a range.
lowest value in a range.
midpoint value in a range.
Question 7. Question : The NOW function would perform which of the following?
Contains another function embedded inside one or more of its arguments.
Evaluates a condition and returns one value if the condition is true and a different value if the condition is false.
Evaluates true or false.
Displays the current date and time.
Question 8. Question : The _____ number is the number of the column in the lookup table that contains the return values.
lookup value
column index
lookup table
random
Question 9. Question :To copy a formula, you may use the _____, which is found in the bottom right-hand corner of an active cell.
sizing handle
pointer
fill handle
insertion point
Question 10. Question : To simplify entering ranges in formulas, you can use _____.
range names
a cell's relative location
both an absolute and a relative cell reference
a cell's specific location
Question 11. Question :When calculating a PMT function, the RATE would be described best by which of the following?
It is the periodic interest rate, such as a monthly interest rate.
It is the total number of payment periods.
It is a word or a string of characters that represent one or more cells.
It is the present value of the loan.
Question 12. Question : A _____ is a partially completed workbook that you can use to create other workbooks that have the same structure and purpose.
theme
style
template
macro
Question 13. Question :The process of protecting a worksheet requires you to enter a(n) _____.
user name
e-mail address
IN user key
password
Question 14. Question :You must _____ the recording of the macro when you have completed the tasks it was designed to do.
begin
stop
copy
paste
Question 15. Question :To create a macro button, click the _____ tab, click Insert, then click Button in the Form Controls section of the Insert palette.
View
Data
Insert
Developer