Devry BIS 155 Week 7 Quiz
- (TCO 8) Which of the following is a not an Excel file type? (Points : 2)
- .xls
- .xlsx
- text file
- .xltm
Question 2.2. (TCO 8) When importing an Access database table, Excel _____. (Points : 2)
- imports the data as text.
- formats the data in default table style.
- imports the data in delimited format.
- imports the data is CSV format.
Question 3.3 (TCO 8) Where are web query tools and options located? (Points : 2)
- Formulas tab
- Insert tab
- Data tab
- Review tab
Question 4.4 (TCO 8) Which of the following are settings that control how imported data in cells connect to their source data? (Points : 2)
- Import settings
- Connection properties
- Link settings
- Data range properties
Question 5.5 (TCO 8) Where is the Text to Columns Wizard located in Excel? (Points : 2)
- Data tab
- Insert tab
- Formulas tab
- Backstage
Question 6.6 (TCO 8) ) Which of the following functions does not manipulate text? (Points : 2)
- CONCATENATE
- PROPER
- UPPER
- INDEX
Question 7.7 (TCO 8) Which function will convert a text string to lowercase? (Points : 2)
- UPPER
- PROPER
- LOWER
- CONCATENATE
Question 8.8 (TCO 8) What governing body created XML? (Points : 2)
- IEEE
- World Wide Web Consortium
- The Computer Science Society
- ICANN
Question 9.9 (TCO 7) Which of the following is not a tool to help provide a unified look and feel within a workbook? (Points : 2)
- Themes
- Custom functions
- Backgrounds
- Styles
Question 10.10. (TCO 7) Where is the Insert Background feature located? (Points : 2)
- Backstage
- Page Layout tab
- Formulas tab
- Insert tab
Question 11.11. (TCO 7) Which of the following is not a predefined cell style category? (Points : 2)
- Data and Model
- Number Format
- Titles and Headings
- Analysis
Question 12.12. (TCO 7) What is the default file extension for a template? (Points : 2)
- .xls
- .xlsx
- .xltx
- .xlm
Question 13.13. (TCO 7) What is the password character limit in Excel? (Points : 2)
- 325
- 255
- 355
- 100
Question 14.14. (TCO 7) Which of the following is a method for creating macros? (Points : 2)
- Macro recorder
- Formula builder
- Insert function button
- Developer tools
Question 15.15. (TCO 7) Which of the following items is not stored inside VBA modules? (Points : 2)
- Sub procedures
- Keywords
- Comments
- Index documents
