Click on the correct response for each question below.
 |
1 | |
Which of the following is (are) recommended shortcuts for entering data into a list. |
| | A) | AutoComplete |
| | B) | Ctrl key + ; to insert the current date |
| | C) | Alt key+ Down arrow key to display Pick List of values |
| | D) | all of the above. |
|
|
2 | |
Which of the following is not a database function? |
| | A) | DAVERAGE |
| | B) | COUNT |
| | C) | DMAX |
| | D) | DSUM |
|
|
3 | |
Which expression shows the correct syntax for the SUMIF function? |
| | A) | =SUMIF(field_range, criteria, sum_range) |
| | B) | =SUMIF(range, criteria) |
| | C) | =SUM(IF(condition, result_if_true, result_if_false)) |
| | D) | =SUMIF(criteria, list_range, sum_range) |
|
|
4 | |
When is automatic outlining effective? |
| | A) | it is always effective |
| | B) | only when there are not summary functions in the worksheet. |
| | C) | only when a worksheet contains DSUM and DAVERAGE summary functions. |
| | D) | only when a worksheet contains SUM and AVERAGE summary functions. |
|
|
5 | |
A __________ is a special dialog box that allows you to navigate, add, modify, delete, and search records. |
| | A) | data sheet |
| | B) | work form |
| | C) | data form |
| | D) | database |
|
2002 McGraw-Hill Higher Education