BIS 155 Week 7: Lab Exercise, Quiz plus Discussion
(BIS 155 Week 7)
- Excel shares very well with other applications. Why does it import data so easily from other external sources? What features make it easy to manipulate this imported data?
- Adding a macro to an Excel workbook is almost like clicking the “Easy” button. They can automate very simple tasks. Why are people often intimidated by macros?
- Question 1. (TCO 8) Which of the following is a file type that cannot … imported into Excel?
- Question 2. (TCO 8) Which of the following file types uses tabs to separate data into columns?
- Question 3. (TCO 8) Where are web query tools and options …?
- Question 4. (TCO 8) Which of the following are settings that control how imported data in cells connect to their source data?
- Question 5. (TCO 8) Which feature is best … to split imported text into multiple columns?
- Question 6. (TCO 8) What is the maximum number of strings that can … manipulated with the CONCATENATE function?
- Question 7. (TCO 8) Which of the following is an alternative to using the CONCATENATE function?
- Question 8. (TCO 8) What governing body created XML?
- Question 9. (TCO 7) Where is the Template gallery …?
- Question 10. (TCO 7) Which of the following formats is … as a background in Excel?
- Question 11. (TCO 7) Which of the following is not a … cell style category?
- Question 12. (TCO 7) What is the default file extension for a template?
- Question 13. (TCO 7) What is the password character limit in Excel?
- Question 14. (TCO 7) Which of the following tools is best … to complete repetitive tasks in Excel?
- Question 15. (TCO 7) Which of the following items is not … inside VBA modules?