Exam 3
acc/bus/cis 310x exam3 chapter 7 due Dec 2
Multiple Choice
Identify the choice that best completes the statement or answers the question.
__C__ 1. A(n)_____ is a special workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.
a. guide c. template
b. program d. budget
__B__ 2. _____ can describe any type of data.
a. HTML c. XLTX
b. XML d. DOCX
__D__ 3. _____ help speed and simplify work because Excel users often work with the same types of problems repeatedly.
a. Worksheets c. Text files
b. Workbooks d. Templates
__A__ 4. You can press the _____ key while dragging the fill handle to fill a series with numbers that increment by one.
a. CTRL c. TAB
b. SHIFT d. ALT
__C__ 5. In the accompanying figure, the range C4:F4 contains _____.
a. sample formulas c. sample data
b. actual data d. none of the above
__C__ 6. When developing a template, you can modify the default color scheme by clicking the _____ tab, clicking the Colors button in the Themes group, and clicking a new color scheme in the gallery.
a. Home c. Page Layout
b. Insert d. Data
__A__ 7. A(n) _____ contains little or no formatting.
a. text file c. Access query
b. Web page d. Word table
__C__ 8. A _____ file contains data separated by a selected character.
a. fixed c. delimited
b. marked d. formatted
__C__ 9. The _____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.
a. Import Text Wizard c. Text Import Wizard
b. Import Wizard d. Text Wizard
__A__ 10. Which of the following is the path to the From Web button?
a. (Data tab | Get External Data group) c. (View tab | Launch Web Query group)
b. (Get External Data tab | Web group) d. none of the above
__A__ 11. A Word document often contains data stored in a(n) _____ that can then be copied and pasted into an Excel worksheet.
a. table c. box
b. object d. window
__B__ 12. Imported data may be
Multiple Choice
Identify the choice that best completes the statement or answers the question.
__C__ 1. A(n)_____ is a special workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.
a. guide c. template
b. program d. budget
__B__ 2. _____ can describe any type of data.
a. HTML c. XLTX
b. XML d. DOCX
__D__ 3. _____ help speed and simplify work because Excel users often work with the same types of problems repeatedly.
a. Worksheets c. Text files
b. Workbooks d. Templates
__A__ 4. You can press the _____ key while dragging the fill handle to fill a series with numbers that increment by one.
a. CTRL c. TAB
b. SHIFT d. ALT
__C__ 5. In the accompanying figure, the range C4:F4 contains _____.
a. sample formulas c. sample data
b. actual data d. none of the above
__C__ 6. When developing a template, you can modify the default color scheme by clicking the _____ tab, clicking the Colors button in the Themes group, and clicking a new color scheme in the gallery.
a. Home c. Page Layout
b. Insert d. Data
__A__ 7. A(n) _____ contains little or no formatting.
a. text file c. Access query
b. Web page d. Word table
__C__ 8. A _____ file contains data separated by a selected character.
a. fixed c. delimited
b. marked d. formatted
__C__ 9. The _____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.
a. Import Text Wizard c. Text Import Wizard
b. Import Wizard d. Text Wizard
__A__ 10. Which of the following is the path to the From Web button?
a. (Data tab | Get External Data group) c. (View tab | Launch Web Query group)
b. (Get External Data tab | Web group) d. none of the above
__A__ 11. A Word document often contains data stored in a(n) _____ that can then be copied and pasted into an Excel worksheet.
a. table c. box
b. object d. window
__B__ 12. Imported data may be