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