|
1 | | Which of the following are used to retrieve data for use in displaying information and calculating formulas? |
| | A) | scenario manager |
| | B) | reference tables |
| | C) | lookup tables |
| | D) | data manager |
| | E) | custom view |
|
|
2 | | Which of the following is the correct syntax for the MATCH function? |
| | A) | =MATCH(match_type,lookup_array,lookup_value) |
| | B) | =MATCH(lookup_array,lookup_value,match_type) |
| | C) | =MATCH(lookup_value,lookup_array,match_type) |
| | D) | =MATCH(match_type,lookup_value,lookup_array) |
| | E) | =MATCH(lookup_value,match_type,lookup_array) |
|
|
3 | | When worksheet is protected, you cannot enter or edit data in _______________ cells. |
| | A) | hidden |
| | B) | locked |
| | C) | unprotected |
| | D) | formatted |
| | E) | none of the above |
|
|
4 | | Which of the following is a special type of workbook file that you can use as a model from which to create new workbooks? |
| | A) | wizard |
| | B) | template |
| | C) | master |
| | D) | model |
| | E) | guide |
|
|
5 | | Which of the following saves workbook data with fixed-length tabs to separate data into columns resembling a worksheet layout? |
| | A) | tab delimited |
| | B) | fixed tabs |
| | C) | comma delimited |
| | D) | column delimited |
| | E) | fixed columns |
|