Site MapHelpFeedbackLesson 05 Quiz
Lesson 05 Quiz
(See related pages)

1
Which Excel command can be used to copy selected data from one worksheet to another?
A)Group Copy
B)Fill Across Worksheets
C)Move or Copy
D)Select and Paste
2
Which of the following Excel functions belongs to the Statistical category?
A)NOW()
B)TODAY()
C)AVERAGE
D)PMT
3
If an Excel function has more than one argument, what separates the arguments in the formula bar?
A)Periods
B)Commas
C)Colons
D)Semicolons
4
Which of the following statements describes this function: =SUMIF(D7:D14, ">1") in an Excel worksheet?
A)It adds the values in cells D7:D14 if the value is greater than 1.
B)It adds all the negative values in cells D7:D14.
C)If the value in a cell is greater than 1, it is added to the other values in column D.
D)If the value in a cell is greater than 1, the range D7:D14 is placed on a summary sheet.
5
Which of the following statements best describes the PMT function in an Excel worksheet?
A)It calculates a monthly payment over a specified period of time for money owed.
B)It calculates how much money can be borrowed based on a specified monthly payment.
C)It calculates the payback period for a monthly payment for money owed.
D)It calculates the money owed over the entire payback time for the monthly payment.
6
In an Excel worksheet, what would result from =AVERAGE(A1:A3) if A1=10, A2=20 and A3=30?
A)40
B)30
C)20
D)60
7
Which Excel command button, when clicked, offers three options for data visualizations?
A)Cell Styles
B)Conditional Formatting
C)Visualization Library
D)Visualization Formatting
8
Which of the following command buttons leads to the Function Arguments dialog box?
A)Function Library
B)Formula Wizard
C)Insert Function
D)AutoCalculate
9
In an Excel worksheet, which of the following statements describes the results of modifying a named range that is used in worksheet formulas?
A)The formula cell displays an error message #NAME?
B)The formula cell is updated to show the new range name.
C)The formula cell is deleted.
D)The formula cell displays a circular reference notation.
10
Which of the following properties is included for a new defined name from the New Name dialog box?
A)Comments
B)Dependents
C)Connections
D)Precedents







Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 05 Quiz