Microsoft Excel Questions... 9 pages of questions.

Name _________________________ Date ___________

Excel 2010: Chapter 5 – Multiple Choice

Instructions: Circle the correct response.

1. A ____________ is an organized collection of data.

a. cell b. database c. formula d. key

2. A range of blank rows or columns on the side of a table is called a(n) ____________.

a. moat of cells b. class c. range line d. column margin

3. ____________ causes adjacent rows to have different formatting so that each row in the table is distinguished from surrounding rows.

a. Merging b. Sorting c. Row banding d. AutoFilter

4. Excel allows you to refer to the column headings in formulas by placing the column heading in brackets and adding ____ to the beginning of the column name.

a. * b. @ c. # d. $

5. A value being looked up outside the range of the table causes the VLOOKUP function to return as error message ___________.

a. 0 b. -1

c. #ERROR# d. #N/A

6. Excel includes which of the following conditional formats?

a. absolute b. relative c. mixed d. data bars

7. Arranging records in a specific sequence is called ____________.

a. ranging b. merging c. sorting d. keying

8. When Excel sorts, which of the following has the highest priority?

a. Blanks b. Special characters c. Text d. Numbers

9. The query technique that uses the column heading arrows is called ____________.

a. AutoFilter b. OpenCriterion c. Name Manager d. Query Wizard

10. Which of the following operators would you use if you wanted each and every comparison criteria to be true?

a. EACH b. AND c. OR d. ALL