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

1
Which of the following objects is not an argument of the IF function in an Excel worksheet?
A)Logical_test
B)Value_if_false
C)Value_when_false
D)Value_if_true
2
In a custom date format in an Excel worksheet, which of the following codes is used to build the month's format?
A)D
B)Y
C)M
D)H
3
Which one of the following relational operators represents "Less than or equal to" in an Excel formula or function?
A)=<
B)=>
C)<=
D)>=
4
Which of the following terms applies to a set of formatting attributes for labels or values in an Excel worksheet?
A)Cell button
B)Cell property
C)Cell style
D)Cell template
5
If the custom date format code is mmmm d, yyy in an Excel worksheet, which of the following dates represents the appearance of the date on screen?
A)October 1, 2012
B)10 Oct 2012
C)Oct 10, 2012
D)10 October 2012
6
What is the name of the category in the Format Cells dialog box that enables you to build a unique format for a date in an Excel worksheet?
A)Custom
B)Date
C)Special
D)Text
7
Which of the following choices lists commands and formatting that may not work if an Excel workbook is saved in an early Excel format?
A)Error Checking Options
B)Excel Compatibility Checker
C)Publish as Excel 97-2003 dialog box
D)Check for Problems button
8
In an Excel workbook, which of the following commands is executed when you press [Ctrl]+[Y]?
A)Go To
B)Repeat
C)Undo
D)Reset
9
Which of the following characters is used to separate arguments in an Excel function?
A)/ (forward slash)
B)\ (backward slash)
C); (semicolon)
D), (comma)
10
Which of the following Excel formulas would result in TRUE if C4 is less than 10 and D4 is less than 100?
A)=AND(C4>10, D4>10)
B)=AND(C4>10, C4<100)
C)=AND(C4>10, D4<10)
D)=AND(C4<10, D4<100)







Hinkle, Microsoft2010 CompleteOnline Learning Center

Home > Excel > Lesson 06 Quiz